Re: SQL query problem - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: SQL query problem
Date
Msg-id 20031009233308.B2022@hermes.hilbert.loc
Whole thread Raw
In response to SQL query problem  ("Marek Lewczuk" <newsy@lewczuk.com>)
Responses Re: SQL query problem (many table in FROM statement and many LEFT JOIN's)  ("Marek Lewczuk" <newsy@lewczuk.com>)
List pgsql-general
> fine). PG returns: ERROR:  Relation "_con" does not exist
>
> This is my query:
>
> SELECT
>   _CON.con_id,
Please make sure you get the quoting right regarding table
names. PostgreSQL will fold _CON into _con unless quoted
"_CON". So, it may be that you created the table with quotes
("_CON"). Now, in your query you don't use quotes and thusly
it is looking for a _con table. The simple rule of thumb is to
either always or never use quotes.

HTH,
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: question about a select
Next
From: Cindy
Date:
Subject: Re: question about a select