Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3AEE6475E40 for ; Thu, 19 Dec 2002 18:59:48 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 8CC7A475E2C for ; Thu, 19 Dec 2002 18:59:47 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id gBJNxmpd010059; Thu, 19 Dec 2002 18:59:48 -0500 (EST) To: Laurette Cisneros Cc: pgsql-interfaces@postgresql.org Subject: Re: Pg (Perl for Postgresql) In-reply-to: References: Comments: In-reply-to Laurette Cisneros message dated "Thu, 19 Dec 2002 15:51:22 -0800" Date: Thu, 19 Dec 2002 18:59:48 -0500 Message-ID: <10058.1040342388@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/63 X-Sequence-Number: 3476 Laurette Cisneros writes: > The column and the table are named the same: > select x, y from y; > In 7.3 it gives the error message: > ERROR: You can't use relation names alone in the target list, try relation.*. > It works fine in 7.2 Hm, there must be more to it than meets the eye, because that condition alone doesn't cause a problem: regression=# create table y (x int, y int); CREATE TABLE regression=# select x, y from y; x | y ---+--- (0 rows) How did you declare the table, exactly? regards, tom lane