Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1276: Backend panics on SETVAL('..', 0)... - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1276: Backend panics on SETVAL('..', 0)...
Date
Msg-id 28946.1096781202@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1276: Backend panics on SETVAL('..', 0)...  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
Tree view 
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> ERROR:  setval: value 0 is out of bounds for sequence "foo_id_seq"
> (1..9223372036854775807)
> FATAL:  block 0 of 1663/97972/98006 is still referenced (private 1, global
> 1)

Does that relation OID actually point to the sequence?  I couldn't
duplicate this in desultory testing, so I think there's something
you didn't tell us.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1276: Backend panics on SETVAL('..', 0)...
Next
From: peter pilsl
Date:
Subject: 8.0b3: problems with ILIKE and ~* on multibyte-chars