From: Tom Lane <tgl@sss.pgh.pa.us>
To: Laura Scott <l.e.scott@larc.nasa.gov>
Cc: pgsql-sql@postgresql.org
Subject: Re: relation X does not exist
Date: Mon, 19 Apr 2004 21:11:33 -0400
Message-ID: <2155.1082423493@sss.pgh.pa.us> (raw)
In-Reply-To: <407BE1E3.39509CB@larc.nasa.gov>
References: <407BE1E3.39509CB@larc.nasa.gov>
Laura Scott <l.e.scott@larc.nasa.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, l.e.scott@larc.nasa.gov
Subject: Re: relation X does not exist
In-Reply-To: <2155.1082423493@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox