Re: "Transaction over connections"

Поиск
Список
Период
Сортировка
От Lada 'Ray' Lostak
Тема Re: "Transaction over connections"
Дата
Msg-id 012801c3af42$facbd2f0$0d01a8c0@utopia
обсуждение исходный текст
Ответ на "Transaction over connections"  ("Lada 'Ray' Lostak" <ray@unreal64.net>)
Ответы Re: "Transaction over connections"  (Shridhar Daithankar <shridhar_daithankar@myrealbox.com>)
Список 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 по дате отправления:

Предыдущее
От: "Craig O'Shannessy"
Дата:
Сообщение: Re: Export CSV from psql
Следующее
От: Andrei Ivanov
Дата:
Сообщение: ERROR: nodeRead: did not find '}' [x2]