Haroldo Stenger wrote:
> And I add one of my own: It is not really necessary to have continuity in nearly
> all apps. Your question is valid anyhow, but ask yourself: How does Oracle
> resolve this? How would I program it myself by hand? And there you'll understand
> the issue deeply.
How funny i
Ryan Kirkpatrick wrote:
>
Ryan,
This issue has been asked & answered MANY times, once a week perhaps. I'll copy
here what a folk answered once
"You can't. Sequences are not designed for continuity, they are designed for
uniqueness. If you want to have a set of contiguous numbers, in ascendi
That is not a bug, it is well documented behavior. PostgreSQL will NOT roll
back a sequence for any reason, regardless of whether it is in a transaction
that has been rolled back. Think of how you would have to code a sequence to
support that type of behavior. In the case of multiple clients drawi
Either I am missing something or I found a bug in PostgreSQL.
Hopefully it is the former. :)
Simply, I am trying to use a sequence to generate unique id
numbers for a table. Now, a number of the fields in this table have 'check
constraints'. What happens, is if I attempt to insert
