a little doubt that came into my mind reading the official manual (chapter 37,
page 677): "functions and trigger procedures are always executed within a
transaction established by an outer query". What does "outer" means? If I'd
like a function to be execute within a transaction should I manually begin
and end the transaction or is the procedure code always executed in a kind of
subtransaction? I mean, supposing a function raises an exception, what
happens to all the sql statement issued by the function before the exception?
Are they automatically rollbacked?
pgsql-novice by date
|Next:||From: A. Kretschmer||Date: 2007-01-26 07:48:53|
|Subject: Re: pgsql & transaction doubt|
|Previous:||From: Jim Nasby||Date: 2007-01-26 04:42:15|
|Subject: Re: [SPAM] Restore single table from pg_dumpall.|