On Mon, 17 Dec 2001, Tom Lane wrote:
> Justin <[EMAIL PROTECTED]> writes:
> > On Saturday 15 December 2001 03:06, Tom Lane wrote:
> >> It's too late to fix this in the standard catalogs for 7.2, but I'll
> >> make a note for 7.3.
>
> > Suitable for 7.2.1?
>
> Nyet. We don't do initdbs for dot-re
"Mikheev, Vadim" <[EMAIL PROTECTED]> writes:
> It was made to avoid WAL-loging on each nextval call, ie it should work
> like OID pre-fetching: value stored in WAL must always "exceed" values
> returned by nextval so on the after-crash-restart sequence should be
> advanced to value which was never
I have verified that killing the postmaster after a few nextval's
leaves things in a bad state after restart.
I think I see the problem: in nextval(), the sequence data written to
the WAL log is different from that written to the data page. Isn't
that bogus?
To WAL:
seq->last_va
"Henshall, Stuart - WCP" <[EMAIL PROTECTED]> writes:
> Setup: PostgreSQL 7.1.2 on Dual PIII WinNT4 server + Cygwin 1.3.2
> PostgreSQL is run as a service and when rebooting (which doesn't shutdown -
> previously on cygwin list (hence the ~Crash in title)) I have twice noticed
> that a sequence was
[EMAIL PROTECTED] writes:
> Permissions on sequences are not restored when upgrading to 7.1
> Got a write error stating that I don't have permission to update .nextval
Actually, the permissions *are* restored; the problem is that 7.1 is
making more permission checks than prior versions did.
Severity: Annoyance
Setup: PostgreSQL 7.1.2 on Dual PIII WinNT4 server + Cygwin 1.3.2
PostgreSQL is run as a service and when rebooting (which doesn't shutdown -
previously on cygwin list (hence the ~Crash in title)) I have twice noticed
that a sequence was not properly updated, however records wi
John Bradshaw ([EMAIL PROTECTED]) reports a bug with a severity of 4
The lower the number the more severe it is.
Short Description
Upgrade to 7.1 - sequence permissions not restored
Long Description
Permissions on sequences are not restored when upgrading to 7.1
Got a write error stating that I
