Re: Deletion - Mailing list pgsql-general

From Ramesh T
Subject Re: Deletion
Date
Msg-id CAK8Zd=ugTDMEZd0DUY2T=pKy=cKUh58pjtae_Qs4hH8Nisgmbw@mail.gmail.com
Whole thread Raw
In response to Re: Deletion  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Deletion  (David G Johnston <david.g.johnston@gmail.com>)
Re: Deletion  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Deletion  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
OK.. i created a function for delete customer from different tables in single database.

i want rollback..

my question:
                       where i need to place rollback ,with in a function along with deletion statements..? or after run the function ..?
i do not need commit..
please let me know..


On Thu, Aug 28, 2014 at 1:20 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 08/27/2014 11:59 AM, Ramesh T wrote:

In oracle I ran the deletion script to clean up the particular database
using custid.custid is the parameter .&&1 is used in the oracle Inthe
same way tried but $1 not possible ?but using function is possible is
their any problem with fun to Clean the database I have 100 statements
in script ...

First as has been pointed out before Oracle != Postgres.

Also as been pointed out before you have two options:

1) Pay for the EDB Postgres Advanced Sever + and get the Oracle compatibility built ins.

2) Spend the time to convert your Oracle code.

As always it comes down to that magic combination of time and/or money.

Second I do not understand what you are trying to say above. Maybe if you showed some actual code it would help.

--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: "Yogesh. Sharma"
Date:
Subject: Help related to Postgresql for RHEL 6.5
Next
From: Devrim Gündüz
Date:
Subject: Re: Help related to Postgresql for RHEL 6.5