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"
|
| Список | 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 по дате отправления: