Re: [SQL] transaction in plpgsql

2002-06-27 Thread Nils Höglund
> how can i implement transactions inside my plpgsql functions I would guess that this is not possible since postgres don't support nested transactions(?). -- /Nils Höglund, Naqua KB E-mail: [EMAIL PROTECTED] Web:http://www.naqua.se/ Home Phone: +46 (0)18 30 09 19 C

Re: [SQL] transaction in plpgsql

2002-06-27 Thread Josh Berkus
Joe, > how can i implement transactions inside my plpgsql functions You can't. Each PL/pgSQL function is automatically treated as a single transaction by Postgres. As such, the entire function either succeeds or fails. To manage a transaction *inside* the PL/pgSQL function, Postgres would h

[SQL] transaction in plpgsql

2002-06-27 Thread Joseph Syjuco
how can i implement transactions inside my plpgsql functions ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster