--
From: "Jomon Skariah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 3:15 PM
Subject: [SQL] Porting from PL/SQL to PLPGSQL
>
> Hi All,
>
> We are in the process of migrating of our application from Oracle to
> PostGreSQL.
>
On Wed, Aug 20, 2003 at 03:15:23PM +0530, Jomon Skariah wrote:
>
> we are facing a few problems with PL/SQL Code..
>
>
> 1)In Oracle sqlplus we can run sql script files as @script_name;
> How do we do the same in PostGres.
psql takes \i. See psql's \?
See the "Porting From Oracle PL
Hi All,
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 Oracle sqlplus we can run sql script files as @script_name;
How do we do the same in PostGres.
Also is there any replacement for
To: Jomon Skariah; [EMAIL PROTECTED]
Subject: Re: [SQL] Porting from PL/SQL to PLPGSQL
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
> 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)Can we perform DML statements on VIEWS in PostGreSQL as we do in
> ORACLE?
> Do I need to create some RULES for that ??
>
>
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 Oracl
> 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.
What does it do?
> 2 Oracle have a function USERENV to get the user session
> informati
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
>
