Horton

Re: "Transaction over connections"

Karsten Hilbert <karsten.hilbert@gmx.net>

View thread View on postgr.es
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-general@postgresql.org
Date: 2003-11-20T08:19:30Z
Lists: pgsql-general 
> So, my direct question: can I invoke automatically some function in PgSql to
> make condition to EVERY sql statement ?
You can add an attribute "work-in-progress" to your tables. Then
set up views that filter out rows with work-in-progress=true.
Your production client then needs to be modified to look at
those views instead of the tables.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346