UPDATE with database name alias

Поиск
Список
Период
Сортировка
Искать
От
andres@sayago.info
Тема
UPDATE with database name alias
Дата
Msg-id
2977.69.79.131.31.1127153306.squirrel@www.sayago.info
Список
Дерево обсуждения
Re: Problems with alias in UPDATE over JDeveloper+ADF: I havethe answer François <francois.gourdeau@mcccf.gouv.qc.ca>
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
В списке pgsql-jdbc по дате отправления
От: Gianluigi
Дата:
Сообщение: GCJ jdbc driver compilation
От: Dave Cramer
Дата:
FAQ