Thank you for helping me get to the bottom of it.
Malcolm Warren
Richard Huxton wrote:
Malcolm Warren wrote:
Thank you for your reply. Yes, I get the next number and the number goes up one, as it should.
The rest of the table seems to function normally incidentally, just the serial column gets filled with 0.
By the way my version is 7.3 which I forgot to mention.
Hmm - since you say you've dumped/restored to another machine that leaves two things I can think of:
1. Schema issue (maybe it's not seeing the sequence). 2. Trigger is altering the value supplied. 3. The application isn't sending the query you think it is.
What happens if you manually:
INSERT INTO my_table (..., srl, ...) VALUES (..., nextval('booking_srl_seq',...)
If that works, it's not #2, and it's time to look at the application (and turn statement logging on).
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
