| 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: | Whole Thread | Raw Message | 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
| 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 |