Re: plpgsql equivalent to plperl $_SHARED and plpythonu global dictionary GD? - Mailing list pgsql-general

From Zlatko Matic
Subject Re: plpgsql equivalent to plperl $_SHARED and plpythonu global dictionary GD?
Date
Msg-id 008701c7c2ee$02dcfab0$45ac0fd4@zlatkovyfkpgz6
Whole thread Raw
In response to recursive function  (Karen Springer <karen.springer@wulfsberg.com>)
List 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 -----
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.matic1@sb.t-com.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

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: russian case-insensitive regexp search not working
Next
From: "Zlatko Matic"
Date:
Subject: free scheduled import utility