Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B93A937C69C for ; Fri, 10 Oct 2008 17:03:49 -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 82581-06 for ; Fri, 10 Oct 2008 17:03:46 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.247]) by postgresql.org (Postfix) with ESMTP id 86D8D37BF16 for ; Fri, 10 Oct 2008 17:03:46 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id d30so84974and.33 for ; Fri, 10 Oct 2008 13:03:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type:references; bh=IxWg6FvJeKVJVjqBRrHxhI1iokHkmcMFHPSVpnvW3Bg=; b=FCsKhHFrxmjNzNlRDmVe/JA5yWpKseV/tj2vM4cDsE+qXAqOABMjPzBBKuOaWLICKH TRWyUm4QN6cb7kzkGalwkGYhGb2+7hVqo/s900DgNrghxuoqNblLmtOxC3RX3nzZhEFC B83NxJcgv87p4Au0sZ24+14xxX+cgtA5Eo1wo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:references; b=lukuo/JVN+9EZ8FmPboErgtq4qP4ROEG9XtFli57OHiHRelXrzAbBSPUCowqnWtr0J hZ2SkrH48WI5cSWBCCiZaA1ns0XHFR78hblB19da+cm2XugbO4d/3Snm2laJAFP8gng6 mY66kRKvTNJIhDV+AOZ0iSYPhe4aHmB1gQbDU= Received: by 10.143.12.19 with SMTP id p19mr1015018wfi.171.1223669024891; Fri, 10 Oct 2008 13:03:44 -0700 (PDT) Received: by 10.143.156.2 with HTTP; Fri, 10 Oct 2008 13:03:44 -0700 (PDT) Message-ID: Date: Fri, 10 Oct 2008 16:03:44 -0400 From: Sean To: rod@iol.ie Subject: Re: ERROR: relation "userroles" does not exist Cc: pgsql-php@postgresql.org In-Reply-To: <48EF9C24.40201@iol.ie> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_133012_18133933.1223669024736" References: <48EF9C24.40201@iol.ie> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.5 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, WEIRD_PORT=1.499 X-Spam-Level: * X-Archive-Number: 200810/7 X-Sequence-Number: 3904 ------=_Part_133012_18133933.1223669024736 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline That's it. thank you.. I created it using PgAdmin. On Fri, Oct 10, 2008 at 2:17 PM, Raymond O'Donnell wrote: > 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 > ------------------------------------------------------------------ > ------=_Part_133012_18133933.1223669024736 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
That's it. thank you..  I created it using PgAdmin. 

On Fri, Oct 10, 2008 at 2:17 PM, Raymond O'Donnell <rod@iol.ie> wrote:
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
> <http://localhost:8888/HH/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
------------------------------------------------------------------

------=_Part_133012_18133933.1223669024736--