Re: UPDATE with database name alias

It's a perfect idea, but I don't use alias, ADF use them.

With JDeveloper+ADF, ADF is who connect to the database, I dont do it.

JDeveloper use alias to UPDATE, an dthen, what can I do?

PostgreSQL don't use alias to UPATE? Never?

Thanks,

Andrés


> Don't use aliases ?
>
> Dave
> On 19-Sep-05, at 2:08 PM, andres@sayago.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
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>