Porting from PL/SQL to PLPGSQL

Поиск
Список
Период
Сортировка
От Jomon Skariah
Тема Porting from PL/SQL to PLPGSQL
Дата
Msg-id F83B457BE363174B8233DE042A1445703ADA9A@maya.aztec.soft.net
обсуждение исходный текст
Ответы Re: Porting from PL/SQL to PLPGSQL
Re: Porting from PL/SQL to PLPGSQL
Список pgsql-sql
Hi,

We are in the process of migrating of our application from Oracle to
PostGreSQL.


we are  facing a few problems with PL/SQL Code..

1)     In Exceptions ORACLE have something called WHEN OTHERS THEN cluase.I
can't find a replacement for that in            PostGreSQL.
2    Oracle have a function USERENV to get the user session
information.Is there any replacement available in PostGres. ?

3    Is there any replace available for INSTEAD OF INSERT/DELETE/UPDATE
for triggers in PostGreSQL.




Regards

Jomon Skariah.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Raymond Chui
Дата:
Сообщение: Why table has drop, but the foreign key still there?
Следующее
От: proghome@silesky.com (krystoffff)
Дата:
Сообщение: Re: Error message with a SQL function