Re: "Transaction over connections"

From: "Lada 'Ray' Lostak" <ray(at)unreal64(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: "Transaction over connections"
Date: 2003-11-20 08:47:50
Message-ID: 012801c3af42$facbd2f0$0d01a8c0@utopia
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-11-20 08:54:31 Re: "Transaction over connections"
Previous Message Craig O'Shannessy 2003-11-20 08:19:47 Re: Export CSV from psql