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 по дате отправления