[ic] Sessions in PostgreSQL
doug at scotweb.co.uk
Fri Feb 15 04:20:02 EST 2008
Jon Jensen wrote:
> (1) It modifies the row before it's ever written to disk, instead of
> doing a separate UPDATE, and so is more efficient -- almost no impact.
Yeah, that's going to help.
> (2) It uses the wallclock time instead of the start of transaction
> time, which may not matter much for sessions, but can be nice when
> making numerous updates in longer-running transactions, to see the
> order of operations. (Other times you may want the start of
> transaction time instead; it just depends on the circumstance.)
We're not going to need such fine granularity, but it won't do any harm.
> When using this function, your trigger should fire *before*, not *after*
Yep. We were originally doing other things in other places with the same
trigger, but have moved those elsewhere now.
Doug Whiteley, Web and Database Developer
Scotweb Marketing Ltd
Tel: 0131 510 0006 Fax: 0870 706 4938
doug at scotweb.co.uk http://www.scotweb.co.uk
More information about the interchange-users