Re: [GENERAL] function within a function/rollbacks/exception handling

2011-11-10 Thread 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 automatically rolled back Do you know of any

Re: [GENERAL] function within a function/rollbacks/exception handling

2011-11-10 Thread Pavel Stehule
Hello 2011/11/8 Lori Corbani l...@informatics.jax.org: 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

Re: [GENERAL] function within a function/rollbacks/exception handling

2011-11-08 Thread Lori Corbani
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 Oracle-to-Postgres: when an exception

Re: [GENERAL] function within a function/rollbacks/exception handling

2011-11-08 Thread Adrian Klaver
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

Re: [GENERAL] function within a function/rollbacks/exception handling

2011-11-08 Thread Merlin Moncure
: 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 within a function/rollbacks/exception handling Richard, I manage to find one comment about an implicit rollback

[GENERAL] function within a function/rollbacks/exception handling

2011-11-07 Thread 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 function B == functionMain table C = trigger

Re: [GENERAL] function within a function/rollbacks/exception handling

2011-11-07 Thread Pavel Stehule
Hello 2011/11/7 Lori Corbani lori.corb...@jax.org: 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

Re: [GENERAL] function within a function/rollbacks/exception handling

2011-11-07 Thread Richard Huxton
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