X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id AF2F1D1DD5D
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 19 Apr 2004 22:11:32 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 86959-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 19 Apr 2004 22:11:34 -0300 (ADT)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 7F9DAD1B8DF
	for <pgsql-sql@postgresql.org>; Mon, 19 Apr 2004 22:11:30 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i3K1BXHe002156;
	Mon, 19 Apr 2004 21:11:33 -0400 (EDT)
To: Laura Scott <l.e.scott@larc.nasa.gov>
Cc: pgsql-sql@postgresql.org
Subject: Re: relation X does not exist 
In-reply-to: <407BE1E3.39509CB@larc.nasa.gov> 
References: <407BE1E3.39509CB@larc.nasa.gov>
Comments: In-reply-to Laura Scott <l.e.scott@larc.nasa.gov>
	message dated "Tue, 13 Apr 2004 08:49:39 -0400"
Date: Mon, 19 Apr 2004 21:11:33 -0400
Message-ID: <2155.1082423493@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200404/184
X-Sequence-Number: 17559

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