From: Laura Scott <l.e.scott@larc.nasa.gov>
To: pgsql-sql@postgresql.org
Subject: relation X does not exist
Date: Tue, 13 Apr 2004 08:49:39 -0400
Message-ID: <407BE1E3.39509CB@larc.nasa.gov> (raw)
Morning,
I see lots of references to this error, but currently no fix for my
situation. I am converting an INFORMIX ESQL/C system to PostgreSQL
embedded C. I have hit several road blocks along the way and running
out of time to complete and test this convert - so I am coming to the
pros for some help.
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. The
embedded query is
EXEC SQL select count(*) into :var1 from measurement_type where
meas_type = :val2. Both var1 and var2 are within the EXEC SQL DECLARE
section (host variables) and valid types. I can see the relation
measurement_type within psql when I do \dt and as I stated, putting the
exact query into psql gives me my count back.
Any ideas?
Thanks - Laura
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: l.e.scott@larc.nasa.gov
Subject: Re: relation X does not exist
In-Reply-To: <407BE1E3.39509CB@larc.nasa.gov>
* 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