My machine just crashed in the middle of an
update.
When I restart the postgresql server the database
engine appears ok and then tells me that a file /data/pg_clog/0697 is not there.
I presume that these are the transaction log files.
I would like to truncate the old logfiles, re-inde
I just re-read your message, and it occurred to me that for the second
insert you may have provided an explicit value for the 'id', is that right?
You may need to give more detail about the inserts. I'd be mildly surprised,
but not concerned if the insert that failed used an explicit value for the
Hi Colin,
You have done a nice job of demonstrating the documented behaviour of
sequences.
Sequences are designed for speed and high concurrency. They do not guarantee
contiguous numbers and are not included in any transaction as I understand
it.
regards
Iain
- Original Message -
From:
