Re: "Transaction over connections"

Lada 'Ray' Lostak <ray@unreal64.net>

From: "Lada 'Ray' Lostak" <ray@unreal64.net>
To: <pgsql-general@postgresql.org>
Date: 2003-11-20T08:47:50Z
Lists: pgsql-general
> 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.
I also though about this, but what about performance ? I have hundreds
tables. Anyone have experimence withs TONS of views ?

Is it possible to setup 'view' on whole database ? Or a 'part' of DB ? Same
expression for all/setof tables.

It is not problem to modify SQL statement 'table' name (it is in reality
easier than modify expression :). So, client doesn't need to be changed -
just 'SQL' exec handler... So, base condition is OK.

Thanks,
R.