Steve Atkins wrote:
> I need to keep a small amount of information (things like a unique
> session identifier, the application - as opposed to database -
> username and so on) that is local to each database session. It needs
> to be visible from within plpgsql trigger functions and will be used
> on a large fraction of updates.
> Create a temporary table at the beginning of each session
> containing the data, and simply read it out of that, relying on the
> temporary table to be session-local.
This is exactly how you should do it.