Re: Pg (Perl for Postgresql) - Mailing list pgsql-interfaces

From Laurette Cisneros
Subject Re: Pg (Perl for Postgresql)
Date
Msg-id Pine.LNX.4.44.0212191546580.17348-100000@visor.corp.nextbus.com
Whole thread Raw
In response to Re: Pg (Perl for Postgresql)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Pg (Perl for Postgresql)
List pgsql-interfaces
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...



pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: Pg (Perl for Postgresql)
Next
From: Tom Lane
Date:
Subject: Re: Pg (Perl for Postgresql)