| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | "[Jos_] Soares" <jose(at)sferacarta(dot)com> |
| Cc: | Kyle <kyle(at)actarg(dot)com>, pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] begin/end/abort work for sequences? |
| Date: | 1999-07-01 03:26:12 |
| Message-ID: | 199907010326.XAA05930@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> > The sequence po_seq is advancing to the next value even though the
> > transaction was aborted. If I put other things like updates, inserts, etc.
> > inside the transaction, they seem to be rolled back OK, but not the
> > update of the sequence.
> >
> > Am I doing something wrong?
>
> No. I can't explain you why but AFAIK sequences don't rollback.
If we rolled back sequence numbers, we would have to lock the table
until the transaction commited or was rolled back. That is too much
locking so was not worth it.
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-07-01 03:41:05 | Re: [SQL] String concat operator??? |
| Previous Message | Chris Bitmead | 1999-07-01 02:13:35 | Re: [SQL] Beginner's headache of joins |