Ok, I see the problem...
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
Laurette (not guessing)
On Thu, 19 Dec 2002, Tom Lane wrote:
> Laurette Cisneros <laurette@nextbus.com> writes:
> > Is there a newer version of Pg that should be used that can read both 7.2
> > and 7.3 databases?
>
> I suspect this failure has nothing to do with Pg itself. I suggest
> printing out the query error message, rather than guessing about the
> problem ...
>
> regards, tom lane
>
--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
Life is an SQL old chum...