From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: Lista dyskusyjna pgsql-general <pgsql-general@postgresql.org>
Subject: Re: SQL query problem
Date: Thu, 9 Oct 2003 23:33:08 +0200
Message-ID: <20031009233308.B2022@hermes.hilbert.loc> (raw)
In-Reply-To: <003401c38e9e$f1e74b70$f16b4cd5@marek>
References: <003401c38e9e$f1e74b70$f16b4cd5@marek>
> 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
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: Karsten.Hilbert@gmx.net, pgsql-general@postgresql.org
Subject: Re: SQL query problem
In-Reply-To: <20031009233308.B2022@hermes.hilbert.loc>
* 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