Jomon, > 1) In Exceptions ORACLE have something called WHEN OTHERS THEN cluase.I > can't find a replacement for that in > PostGreSQL.
PL/pgSQL currently does not handle exceptions at all. This is on the TODO list. > 2 Oracle have a function USERENV to get the user session > information.Is there any replacement available in PostGres. ? There are several variables and tools which provide current user and session information. See the "PostgreSQL Administration" section of the documentation. > 3 Is there any replace available for INSTEAD OF INSERT/DELETE/UPDATE > for triggers in PostGreSQL. In Postgres, this is generally done through the RULES system instead of triggers. Please lookup CREATE RULE in the online docs. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
