Re: Deletion
| От | Ramesh T |
|---|---|
| Тема | Re: Deletion |
| Дата | |
| Msg-id | CAK8Zd=ugTDMEZd0DUY2T=pKy=cKUh58pjtae_Qs4hH8Nisgmbw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Deletion (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: Deletion
Re: Deletion Re: Deletion |
| Список | 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:First as has been pointed out before Oracle != Postgres.
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 ...
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 по дате отправления: