Laura Scott <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]