12 Dec
2005
12 Dec
'05
10:26 p.m.
On Mon, 12 Dec 2005 22:35:11 +0100, Gerhard Killesreiter <gerhard@killesreiter.de> wrote:
Nicolas Tostin wrote:
Btw, due to the chaotic use of sequences table (sometime it's used, sometimes not)
When not?
I don't have an exact list, but I remember having found some examples, so I understood that it was better handling them by DB trigger (for Oracle schema I mean) than doing nothing .
The general scheme is that we use locking if we want to know the ID in advance or if we need it afterwards for further processing (example: node iD).
There are facilities that return the last ID on a per connection basis for pgsql & mysql. As long as we do not use pconnect , we are fine. Those that use pconnect are advanced enough to introduce locking.