From: | "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> |
---|---|
To: | "hubert depesz lubaczewski" <depesz(at)gmail(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: plpgsql equivalent to plperl $_SHARED and plpythonu global dictionary GD? |
Date: | 2007-07-10 12:29:47 |
Message-ID: | 008701c7c2ee$02dcfab0$45ac0fd4@zlatkovyfkpgz6 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello.
OK. I created a new table that holds information about rows inserted/updated in a transaction.
I realized that after row-level trigger fires always before after statement-level trigger.
Therefore I can use row-level triger to populate the auxiliary table which holds information about affected rows, so that after statement-level trigger can read that information.
It works and is fast enough.
So, I emulated NEW and OLD for statement level trigger:)
Regards,
Zlatko
----- Original Message -----
From: hubert depesz lubaczewski
To: Zlatko Matic
Cc: pgsql-general(at)postgresql(dot)org
Sent: Tuesday, July 10, 2007 10:17 AM
Subject: Re: [GENERAL] plpgsql equivalent to plperl $_SHARED and plpythonu global dictionary GD?
On 7/9/07, Zlatko Matic <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> wrote:
Does plpgsql has something equivalent to plperl $_SHARED or plpythonu global
dictionary GD?
no, but you can use some table to emulate this. or a temp table.
depesz
--
http://www.depesz.com/ - nowy, lepszy depesz
From | Date | Subject | |
---|---|---|---|
Next Message | Zlatko Matic | 2007-07-10 12:32:58 | free scheduled import utility |
Previous Message | Karsten Hilbert | 2007-07-10 12:14:30 | Re: russian case-insensitive regexp search not working |