X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id A304FD1C4C7
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 13 Aug 2003 13:45:04 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 16583-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 13 Aug 2003 10:43:32 -0300 (ADT)
Received: from param.aztec.soft.net (param.aztec.soft.net [164.164.151.8])
	by svr1.postgresql.org (Postfix) with ESMTP id 30A5DD1C508
	for <pgsql-sql@postgresql.org>; Wed, 13 Aug 2003 10:44:50 -0300 (ADT)
Received: from maya.aztec.soft.net (maya.aztec.soft.net [164.164.151.5])
	by param.aztec.soft.net (8.11.2/8.11.2) with ESMTP id h7DETku20391
	for <pgsql-sql@postgresql.org>; Wed, 13 Aug 2003 19:59:48 +0530
Received: by maya.aztec.soft.net with Internet Mail Service (5.5.2653.19)
	id <PXRPXK8Z>; Wed, 13 Aug 2003 19:14:29 +0530
Message-ID: <F83B457BE363174B8233DE042A1445703ADA9A@maya.aztec.soft.net>
From: Jomon Skariah <jomons@aztec.soft.net>
To: pgsql-sql@postgresql.org
Subject: Porting from PL/SQL to PLPGSQL 
Date: Wed, 13 Aug 2003 19:14:28 +0530
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200308/155
X-Sequence-Number: 14771

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.