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

Re: UPDATE with database name alias

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: UPDATE with database name alias
Date: 2005-09-20 04:29:19
Message-ID: 432F901F.1030901@hogranch.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Tom Lane wrote:
> Kris Jurka <books(at)ejurka(dot)com> writes:
> 
>>On Mon, 19 Sep 2005 andres(at)sayago(dot)info wrote:
>>
>>>JDeveloper use alias to UPDATE, an dthen, what can I do?
> 
> 
>>Your only option would be to ajdust the postgresql backend grammar to 
>>allow an alias.
> 
> 
> Isn't it an option to point out to the JDeveloper authors that they are
> emitting SQL that is illegal per spec?
> 

JDeveloper and ADF are from Oracle.  you expected something different?

In response to

pgsql-jdbc by date

Next:From: salman.ashraf@gmail.comDate: 2005-09-20 12:30:20
Subject: org.postgresql.util.PSQLException: The backend has broken the connection.
Previous:From: Dave CramerDate: 2005-09-20 03:01:02
Subject: Re: UPDATE with database name alias

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