Re: UPDATE with database name alias

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Kris Jurka <books(at)ejurka(dot)com>, andres(at)sayago(dot)info, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: UPDATE with database name alias
Date: 2005-09-20 03:01:02
Message-ID: B138A915-5D8C-4BF3-85C5-00D16DFDD605@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

It's an option, but it's an Oracle product, chances are they would
ignore it.

Dave
On 19-Sep-05, at 10:53 PM, 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?
>
> regards, tom lane
>
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message John R Pierce 2005-09-20 04:29:19 Re: UPDATE with database name alias
Previous Message Tom Lane 2005-09-20 02:53:13 Re: UPDATE with database name alias