Postgres Pro
Downloads
Home   >   mailing lists

Re: transactions not working properly ? - Mailing list pgsql-hackers

From Douglas McNaught
Subject Re: transactions not working properly ?
Date
Msg-id m2wtmk4rgw.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to transactions not working properly ?  (Ali Baba <idofyear@yahoo.com>)
List pgsql-hackers
Tree view 
Ali Baba <idofyear@yahoo.com> writes:

> exception
> when others then
>     raise info 'error generated ';
>     commit;
>     RETURN 0;
> end;

You can't COMMIT inside a function.

-Doug

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: do we need inet_ntop check?
Next
From: Michael Fuhr
Date:
Subject: Re: transactions not working properly ?