Re: Strange problem with create table as select * from table; - Mailing list pgsql-general

On Thursday, November 03, 2011 1:25:58 am hubert depesz lubaczewski wrote:
> Hi
> We have pretty weird situation, which seems to be impossible, but perhaps
> you'll notice something that will let me fix the problem.
>
> System: SunOS 5.11      snv_130
> Pg: PostgreSQL 8.4.7 on i386-pc-solaris2.11, compiled by cc: Sun C 5.10
> SunOS_i386 2009/06/03, 64-bit
>

>
> I also verified that there are no concurrent updates that would set
> xobject_id to -1, so it's not a problem of isolation.
>
> During the night I repeated the procedure and the rows that got duplicated
> seem to be the same - at the very least - the same magic_id.
>
> Does above seem sensible for anyone? Any suggestions on what could be
> broken?

Do the xobject_id values have other negative numbers or is -1 just a special
case? The only thing I can think of is a corrupted index on xobject_id.

>
> Best regards,
>
> depesz

--
Adrian Klaver
adrian.klaver@gmail.com