Skip site navigation (1) Skip section navigation (2)

Re: Pg (Perl for Postgresql)

From: Laurette Cisneros <laurette(at)nextbus(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Pg (Perl for Postgresql)
Date: 2002-12-19 23:51:22
Message-ID: Pine.LNX.4.44.0212191546580.17348-100000@visor.corp.nextbus.com (view raw or flat)
Thread:
Lists: 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(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...


In response to

Responses

pgsql-interfaces by date

Next:From: Tom LaneDate: 2002-12-19 23:59:48
Subject: Re: Pg (Perl for Postgresql)
Previous:From: Tom LaneDate: 2002-12-19 23:14:25
Subject: Re: Pg (Perl for Postgresql)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group