Re: BUG #5420: pg_attribute broken

That is a serious problem.  Based on your ASAP requirement, I think you
need a commercial support contract or consultant to fix this for you.

---------------------------------------------------------------------------

cool wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5420
> Logged by:          cool
> Email address:      coolshower2008@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 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 ?
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com