[GENERAL] plperl %_SHARED and rollbacks

2006-03-08 Thread Kenneth Downs
If there are triggers writing to %_SHARED within a transaction, and the transaction is rolled back, do the changes to %_SHARED roll back also? If not then I assume I should manually clear it at the start of transactions, no? begin:vcard fn:Kenneth Downs n:Downs;Kenneth email;internet:[EMAIL

Re: [GENERAL] plperl %_SHARED and rollbacks

2006-03-08 Thread Michael Fuhr
On Wed, Mar 08, 2006 at 09:06:36AM -0500, Kenneth Downs wrote: If there are triggers writing to %_SHARED within a transaction, and the transaction is rolled back, do the changes to %_SHARED roll back also? What happened when you tried it? CREATE TABLE foo (id integer, t text, last_t text);