Re: duplicated tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: duplicated tables
Date: 2009-01-23 22:54:42
Message-ID: 23605.1232751282@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
> yesterday, testing GIN fast update with CVS HEAD I was able to crash backend
> (Teodor already fixed the problem in 0.25 version of the patch)
> and after restarting backend I found duplicated tables.
> How this can be possible and is this what somebody can see after crash ?

That doesn't look like duplicated tables so much as duplicated
pg_namespace rows --- try doing \d's query by hand and adding display
of pg_class.ctid and pg_namespace.ctid. However, if that theory is
correct then the next question is what you were doing to pg_namespace...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jaime Casanova 2009-01-23 23:02:55 Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle
Previous Message Josh Berkus 2009-01-23 22:54:02 Re: New pg_dump patch -- document statistics collector exception (REVISED PATCH)