Skip site navigation (1) Skip section navigation (2)

BUG #5420: pg_attribute broken

From: "cool" <coolshower2008(at)yahoo(dot)co(dot)jp>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5420: pg_attribute broken
Date: 2010-04-14 08:25:25
Message-ID: 201004140825.o3E8PPlO030071@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5420
Logged by:          cool
Email address:      coolshower2008(at)yahoo(dot)co(dot)jp
PostgreSQL version: 8.1.8
Operating system:   debian 2.6.18-6-686
Description:        pg_attribute broken
Details: 

We use PostgreSQL Databse on Hospital Information System in Japan.
In case of normal condition(Not busy, Not Backup, Not Start up and Not
Shutdown),
Suddenly, PostgreSQL outputs error message  and "pg_attribute" catalog file
is broken as bellow.
Could you sent it to us A.S.A.P.
<Environment>
   debian debian 2.6.18-6-686 / PostgreSQL 8.1.8
<Error message>
   invalid attribute number 0 for tbl_syuday
<pg_attribute>
     attrelid     addname           atttypid    attstattarget   attlen    
attnum
     45762        tableoid          26          0               4         
-7
     45762        cmax              29          0               4         
-6
     45762        xmax              28          0               4         
-5
     45762        cmin              29          0               4         
-4
     45762        xmin              28          0               4         
-3
     45762        ctid              27          0               6         
-1
     45762        santeiflg18_4      0          0               0          
0 (?)
     45762        nyugaikbn       1042         -1              -1          
1
     45762        ptid            1700         -1              -1          
2
     .
     .(Omission)
     .
     45762        santeiflg17_1   1700         -1              -1        
343
     45762        ftmoney17_1     1700         -1              -1        
344
     45762        ftmoney18_4     1700         -1              -1        
380 (345..379 are deleted?)
     45762        comptfn18_4     1700         -1              -1        
381
     .
     .(Omission)
     .
Q1:Does anything have same reports ?
Q2:Does anything have repair patches ?

Responses

pgsql-bugs by date

Next:From: cool showerDate: 2010-04-14 11:02:49
Subject: BUG #5421: pg_attribute broken
Previous:From: Pavel StehuleDate: 2010-04-14 06:36:25
Subject: Re: BUG #5419: Default parameters in PLPGSQL functions skipping every other value in pgAdmin view

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group