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:

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 по дате отправления:

Предыдущее
От: "Yogesh. Sharma"
Дата:
Сообщение: Help related to Postgresql for RHEL 6.5
Следующее
От: Devrim Gündüz
Дата:
Сообщение: Re: Help related to Postgresql for RHEL 6.5