Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2689037C031 for ; Fri, 10 Oct 2008 15:17:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 60603-05 for ; Fri, 10 Oct 2008 15:17:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail11.svc.cra.dublin.eircom.net (mail11.svc.cra.dublin.eircom.net [159.134.118.27]) by postgresql.org (Postfix) with SMTP id D8C0037C01B for ; Fri, 10 Oct 2008 15:17:12 -0300 (ADT) Received: (qmail 67800 messnum 6766213 invoked from network[86.46.57.34/unknown]); 10 Oct 2008 18:17:10 -0000 Received: from unknown (HELO ?127.0.0.1?) (86.46.57.34) by mail11.svc.cra.dublin.eircom.net (qp 67800) with SMTP; 10 Oct 2008 18:17:10 -0000 Message-ID: <48EF9C24.40201@iol.ie> Date: Fri, 10 Oct 2008 19:17:08 +0100 From: Raymond O'Donnell Reply-To: rod@iol.ie User-Agent: Thunderbird 2.0.0.17 (Windows/20080914) MIME-Version: 1.0 To: Sean CC: pgsql-php@postgresql.org Subject: Re: ERROR: relation "userroles" does not exist References: In-Reply-To: X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 081010-0, 10/10/2008), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.499 tagged_above=0 required=5 tests=WEIRD_PORT=1.499 X-Spam-Level: * X-Archive-Number: 200810/6 X-Sequence-Number: 3903 On 10/10/2008 18:30, Sean wrote: > *I keep receiving the following when trying to select from a table in my > database. the Tables are there i see them in pgAdmin... > > *Warning*: pg_query_params() [function.pg-query-params > ]: Query failed: > ERROR: relation "userroles" does not exist Would you have defined the table using quoted upper-case? PG folds names to lower-case unless you double quote them, so: test=# create table test(); CREATE TABLE test=# create table "Test"(); CREATE TABLE test=# \dt List of relations Schema | Name | Type | Owner --------+------+-------+---------- public | Test | table | postgres public | test | table | postgres (2 rows) Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------