duplicated tables

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: duplicated tables
Date: 2009-01-23 20:49:43
Message-ID: Pine.LNX.4.64.0901232346150.9554@sn.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi there,

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 ?

List of relations
Schema | Name | Type | Owner
--------+-------+-------+----------
public | tt | table | postgres
public | tt | table | postgres
public | tt | table | postgres
public | tt | table | postgres
public | tt | table | postgres
public | tt2 | table | postgres
public | tt2 | table | postgres
public | tt2 | table | postgres
public | tt2 | table | postgres
public | tt2 | table | postgres
public | ttins | table | postgres
public | ttins | table | postgres
public | ttins | table | postgres
public | ttins | table | postgres
public | ttins | table | postgres
(15 rows)

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bernd Helmle 2009-01-23 20:55:44 Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle
Previous Message Bruce Momjian 2009-01-23 20:17:25 Re: AIX 4.3 getaddrinfo busted