Thread: relation X does not exist

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

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