Re: plpgsql equivalent to plperl $_SHARED and plpythonu global dictionary GD?

["Zlatko Matic" <zlatko.matic1@xxxxxxxxxxx>]

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@xxxxxxxxxxxxxx

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@xxxxxxxxxxx> 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