Re: [GENERAL] sequences and RULEs

2009-06-05 Thread Rafal Pietrak
On Fri, 2009-06-05 at 14:32 +0100, Richard Huxton wrote: > Rafal Pietrak wrote: > > The NEW tuple of the table EVENTLOG, in its ID field at the moment of > > RULE execution has a value of 5! But after everything is finished, the > > actual value deposited in that record is 4. > > A rule rewrites t

Re: [GENERAL] sequences and RULEs

2009-06-05 Thread Richard Huxton
Rafal Pietrak wrote: Now I'd like to write a RULE, that automatically updates references between EVENTLOG and STATUS: The NEW tuple of the table EVENTLOG, in its ID field at the moment of RULE execution has a value of 5! But after everything is finished, the actual value deposited in that reco

[GENERAL] sequences and RULEs

2009-06-05 Thread Rafal Pietrak
Hi All! I've seen sometning unexpected here. I'd apreciate it if someone could give me a hint of why this have happened and may be a sugesstion of a workaround. I'm writing "Building Access Control System" (BACS). My environment is "Debian testing" with "their current" postgresql version: 8.3.7.