X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id CBA28D1B554 for ; Thu, 9 Oct 2003 21:39:52 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 34543-06 for ; Thu, 9 Oct 2003 18:39:06 -0300 (ADT) Received: from mail.gmx.net (pop.gmx.de [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id F01EED1B507 for ; Thu, 9 Oct 2003 18:39:02 -0300 (ADT) Received: (qmail 31955 invoked by uid 65534); 9 Oct 2003 21:39:04 -0000 Received: from p5087F090.dip0.t-ipconnect.de (EHLO hermes.hilbert.loc) (80.135.240.144) by mail.gmx.net (mp013) with SMTP; 09 Oct 2003 23:39:04 +0200 X-Authenticated: #1433807 Received: (from ncq@localhost) by hermes.hilbert.loc (8.11.6/8.11.6/SuSE Linux 0.5) id h99LX8q03604 for pgsql-general@postgresql.org; Thu, 9 Oct 2003 23:33:08 +0200 Date: Thu, 9 Oct 2003 23:33:08 +0200 From: Karsten Hilbert To: Lista dyskusyjna pgsql-general Subject: Re: SQL query problem Message-ID: <20031009233308.B2022@hermes.hilbert.loc> Mail-Followup-To: Lista dyskusyjna pgsql-general References: <003401c38e9e$f1e74b70$f16b4cd5@marek> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <003401c38e9e$f1e74b70$f16b4cd5@marek> User-Agent: Mutt/1.3.22.1i Re-X-turn-receipt-to: Karsten.Hilbert@gmx.net Di-X-sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi-X-rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri-X-ority: 2 (High) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/461 X-Sequence-Number: 50534 > 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