Re: [BUGS] BUG #5421: pg_attribute broken

2010-04-14 Thread Tom Lane
"cool shower" writes: > > attrelid addname atttypidattstattarget attlen > attnum > 45762santeiflg18_4 0 0 0 > 0 (?) What do you mean by "0 (?)"? There shouldn't be any entries in pg_attribute with attnum zero. The

Re: [BUGS] BUG #5421: pg_attribute broken

2010-04-14 Thread Kevin Grittner
"cool shower" wrote: > PostgreSQL version: 8.1.8 > Q2:Does anything have repair patches ? You may want to review the fixes between 8.1.8 and the latest 8.1 bug fix release, which is 8.1.20: http://www.postgresql.org/docs/8.1/static/release.html Perhaps one of these fixes would help. I'd

[BUGS] BUG #5421: pg_attribute broken

2010-04-14 Thread cool shower
The following bug has been logged online: Bug reference: 5421 Logged by: cool shower Email address: coolshower2...@yahoo.co.jp PostgreSQL version: 8.1.8 Operating system: debian 2.6.18-6-686 Description:pg_attribute broken Details: We use PostgreSQL Databse on Hospi