Re: "Transaction over connections" - Mailing list pgsql-general

From Lada 'Ray' Lostak
Subject Re: "Transaction over connections"
Date
Msg-id 012801c3af42$facbd2f0$0d01a8c0@utopia
Whole thread Raw
In response to "Transaction over connections"  ("Lada 'Ray' Lostak" <ray@unreal64.net>)
Responses Re: "Transaction over connections"  (Shridhar Daithankar <shridhar_daithankar@myrealbox.com>)
List 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.


pgsql-general by date:

Previous
From: "Craig O'Shannessy"
Date:
Subject: Re: Export CSV from psql
Next
From: Andrei Ivanov
Date:
Subject: ERROR: nodeRead: did not find '}' [x2]