From: | Gustavo Henrique <gustavoh(at)sysadmin(dot)com(dot)br> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | recovery |
Date: | 2000-04-12 10:02:08 |
Message-ID: | 200004120816.FAA28130@cebolinha.pontocom.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Suddenly, i started getting some weird errors with a table named xx:
db=> drop sequence xx_cod_seq;
ERROR: DeleteTypeTuple: xx_cod_seq type nonexistent
db=> drop table xx;
ERROR: mdopen: couldn't open xx_pkey: No such file or directory
Then, i noticed the file xx_pkey wasnt at the base directory anymore,
so i create a null file and droped the primary key. Now, I get this error
while trying to drop the table :
db=> drop table xx;
ERROR: DeleteTypeTuple: xx type nonexistent
Ï don't know how it happened, but i noticed that this table isnt on pg_type.
Can some help me ???? How do I fix that so i can't drop this table ?
And how did it happen ?
Regards,
Gustavo Henrique Maultasch de Oliveira
gustavoh(at)sysadmin(dot)com(dot)br
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2000-04-12 10:09:08 | PostgreSQL (fwd) |
Previous Message | Jeffrey | 2000-04-12 09:05:33 | Perl error: fetchrow_hashref failed |