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

Re: UPDATE with database name alias

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: andres(at)sayago(dot)info
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: UPDATE with database name alias
Date: 2005-09-19 20:46:44
Message-ID: F7EF4AB6-B9F9-46D1-A6E5-9F39D42A6B90@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Don't use aliases ?

Dave
On 19-Sep-05, at 2:08 PM, andres(at)sayago(dot)info wrote:

> Hello friends.
>
> I'm new in this list, but not in the database world. I have a  
> question and
> I need yout colaboration.
>
> I am programming with JDeveloper 10g, and I want to use PostgreSQL
> database. I'm using Oracle but I wanna do the migration. But, I  
> have a big
> problem: I use PostgreSQL with ADF and ADF uses aliasses for the  
> database
> name when it need to do a UPDATE. Example:
>
> UPDATE conference_romms ConferenceRooms
> SET ConferenceRooms.room_name = 'Golden'
> WHERE ConferenceRooms.room_id = 57;
>
> That sentence fail because the UPDATE clause don't support aliasses.
>
> I'm thinking right? Or I am mistaked.
>
> PostgreSQL don't support database name aliasses for the UPDATE  
> option??
>
> How can I do it??
>
> Thanks,
>
> Andrés Säyago
> Bogotá D.C., Colombia
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>
>


In response to

Responses

pgsql-jdbc by date

Next:From: andresDate: 2005-09-19 20:47:00
Subject: Re: UPDATE with database name alias
Previous:From: andresDate: 2005-09-19 18:08:26
Subject: UPDATE with database name alias

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