Online system & transactions
От | Lada 'Ray' Lostak |
---|---|
Тема | Online system & transactions |
Дата | |
Msg-id | 004101c4b524$ce946ba0$0d01a8c0@utopia обсуждение исходный текст |
Список | pgsql-general |
Hello ppl, Imagine some online system, based on PgSql. There are 'many' parts which depends on each other. I will give small example, but instead of simple table imagine changing tenths various tables (editing). So, 'change table A' can be work for hours. There are tables tableA and tableB. Changes are made by thin client. If you change tableA, you have to also change tableB to 'finish' operation. Between starting changing tableA until tableB is finished, data are 'not valid'. Record may be changes, deleted, inserted, whatever. Is there any simple way, how to create 'transactions' over database connections ? These relations are really complex in real live and doesn't fit table foundaries, so, it is basically not realistic to make it on application layer and need to be done somehow on DB layer.... The best solution should be possibility to 'begin' transaction, 'store' somehow on server, and next time, instead of begin new transaction return to stored one. Transactions solves all these problems, but they don't work across various/multiple connections.... Any ideas/references please ? Thank you, Best regards, Lada 'Ray' Lostak Unreal64 Develop group http://www.orcave.com http://www.unreal64.net -------------------------------------------------------------------------- In the 1960s you needed the power of two C64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.
В списке pgsql-general по дате отправления: