On Thu, Jul 19, 2007 at 02:53:50PM +0300, Abraham, Danny wrote:
> Fails on: Cannot run inside a transaction block.
PostgreSQL functions run in the context of a transaction so they
can't execute statements that aren't allowed inside a transaction
block. A workaround is to have the function connect to the database
via contrib/dblink (or dbi-link, or some such mechanism) and execute
the statements over that connection. Caveat: if the function's
transaction rolls back then statements already committed over the
connection won't be rolled back.
In response to
pgsql-admin by date
|Next:||From: Jessica Richard||Date: 2007-07-20 16:06:53|
|Subject: "_" in a serach pattern|
|Previous:||From: Dimitri Fontaine||Date: 2007-07-20 13:01:49|
|Subject: SkyTools Londiste HowTo|