| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Ben Grimm <bgrimm(at)zaeon(dot)com> |
| Cc: | "Tom Pfau" <T(dot)Pfau(at)emCrit(dot)com>, "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Bug #613: Sequence values fall back to previously chec |
| Date: | 2002-03-14 23:58:04 |
| Message-ID: | 18248.1016150284@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
Ben Grimm <bgrimm(at)zaeon(dot)com> writes:
> The behavior of SELECT nextval() should not be conditional on being in or
> out of a transaction block.
Nonsense. The behavior of INSERT or UPDATE is "conditional" in exactly
the same way: you should not rely on the reported result until it's
committed.
Given Vadim's performance concerns, I doubt he'll hold still for forcing
an XLogFlush immediately every time a sequence XLOG record is written
-- but AFAICS that'd be the only way to guarantee durability of a
nextval result in advance of commit. Since I don't think that's an
appropriate goal for the system to have, I don't care for it either.
I'm planning to try coding up Vadim's approach (pay attention to page's
old LSN to see if a WAL record must be generated) tonight or tomorrow
and see if it seems reasonable.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mikheev, Vadim | 2002-03-15 00:17:39 | Re: Bug #613: Sequence values fall back to previously chec |
| Previous Message | Ben Grimm | 2002-03-14 22:47:39 | Re: Bug #613: Sequence values fall back to previously chec |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-03-15 00:03:45 | Re: [SQL] Syslog |
| Previous Message | Larry Rosenman | 2002-03-14 23:35:23 | Re: [SQL] Syslog |