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.