Re: Pg (Perl for Postgresql)

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(at)nextbus(dot)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...