From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Laura Scott <l(dot)e(dot)scott(at)larc(dot)nasa(dot)gov> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: relation X does not exist |
Date: | 2004-04-20 01:11:33 |
Message-ID: | 2155.1082423493@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Laura Scott <l(dot)e(dot)scott(at)larc(dot)nasa(dot)gov> writes:
> I have a table defined with only two fields. The create table statement
> did not have " " around the table name. I can cut and paste the query
> from my debug statement into psql and get the desired result set back.
> However, in the .pgc file, the query no matter how I write it (with " "
> , without, uppercase....) I get the relation X does not exist.
Are you sure your ecpg program is connecting to the same database as
you're using manually? Perhaps it's connecting as a different userid
that has a different search path?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2004-04-20 02:57:53 | Re: Prepared Statements and large where-id-in constant blocks? |
Previous Message | Tom Lane | 2004-04-20 01:02:38 | Re: [SQL] Prepared Statements and large where-id-in constant blocks? |