| From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
|---|---|
| To: | Lista dyskusyjna pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SQL query problem |
| Date: | 2003-10-09 21:33:08 |
| Message-ID: | 20031009233308.B2022@hermes.hilbert.loc |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cindy | 2003-10-09 21:42:44 | Re: question about a select |
| Previous Message | Stephan Szabo | 2003-10-09 21:29:18 | Re: question about a select |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stuart Barbee | 2003-10-10 03:51:24 | Re: SQL query problem |
| Previous Message | Marek Lewczuk | 2003-10-09 19:52:58 | SQL query problem |