Hello
2011/11/8 Lori Corbani :
>
> Richard,
>
> I manage to find one comment about an implicit rollback in a section of the
> developer's guide when porting from Oracle-to-Postgres: "when an exception
> is caught by an EXECPTION clause, all database changes since the block's
> BEGIN are automatic
Richard,
I manage to find one comment about an implicit rollback in a section of
the developer's guide when porting from Oracle-to-Postgres: "when an
exception is caught by an EXECPTION clause, all database changes since
the block's BEGIN are automatically rolled back"
Do you know of any o
ic examples that I
> am interested in finding.
>
> Thanks.
> Lori
>
>
>
> From: Lori Corbani [l...@informatics.jax.org]
> Sent: Tuesday, November 08, 2011 8:46 AM
> To: Richard Huxton
> Cc: Lori Corbani; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] function
On Tuesday, November 08, 2011 7:13:03 am Lori Corbani wrote:
> Richard,
>
> I manage to find one comment about an implicit rollback in a section of
> the developer's guide when porting from Oracle-to-Postgres: "when an
> exception is caught by an EXECPTION clause, all database changes since
> the
08, 2011 8:46 AM
To: Richard Huxton
Cc: Lori Corbani; pgsql-general@postgresql.org
Subject: Re: [GENERAL] function within a function/rollbacks/exception handling
Richard,
I manage to find one comment about an implicit rollback in a section of
the developer's guide when porting from Orac
On 07/11/11 19:18, Lori Corbani wrote:
I have a function, call it 'functionMain'. And I have several tables that each
have trigger functions. Each trigger function needs to call 'functionMain'
(with different parameters).
table A => trigger function A ==> functionMain
table B => trigger
Hello
2011/11/7 Lori Corbani :
>
> I have a function, call it 'functionMain'. And I have several tables that
> each have trigger functions. Each trigger function needs to call
> 'functionMain' (with different parameters).
>
> table A => trigger function A ==> functionMain
> table B => trigger
I have a function, call it 'functionMain'. And I have several tables that each
have trigger functions. Each trigger function needs to call 'functionMain'
(with different parameters).
table A => trigger function A ==> functionMain
table B => trigger function B ==> functionMain
table C => trigg