pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCan't access a table. It seems to have been corrupted hsomehow
3+ messages / 3 participants
[nested] [flat]
* Can't access a table. It seems to have been corrupted hsomehow
@ 2000-04-01 08:49 Robert Chalmers <robert@chalmers.com.au>
0 siblings, 2 replies; 3+ messages in thread
From: Robert Chalmers @ 2000-04-01 08:49 UTC (permalink / raw)
To: pgsql-sql
I have a database with a group of tables in it.
One of the tables seems to have been modified somehow, and no - although I
can see it with \d I can't actually do anyting to it. Any action, like
rename, insert, drop gives a message "table doesn't exist". If I try to jsut
creat it again, it says "can't do that, it already exists!" (words to that
effect)
So - does it exist or not? How do I actually get rid of that particular
table all together without destroying the whole database?
bob
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can't access a table. It seems to have been corrupted hsomehow
@ 2000-04-01 11:00 Tulassay Zsolt <zsolt@tek.bke.hu>
parent: Robert Chalmers <robert@chalmers.com.au>
1 sibling, 0 replies; 3+ messages in thread
From: Tulassay Zsolt @ 2000-04-01 11:00 UTC (permalink / raw)
To: Robert Chalmers <robert@chalmers.com.au>; +Cc: pgsql-sql
On Sat, 1 Apr 2000, Robert Chalmers wrote:
> I have a database with a group of tables in it.
>
> One of the tables seems to have been modified somehow, and no - although I
> can see it with \d I can't actually do anyting to it. Any action, like
> rename, insert, drop gives a message "table doesn't exist". If I try to jsut
> creat it again, it says "can't do that, it already exists!" (words to that
> effect)
>
> So - does it exist or not? How do I actually get rid of that particular
> table all together without destroying the whole database?
I had the same problem a few days ago. The table file on disk has
disappeared somehow, and i couldn't DROP the table. The only way I found
is to copy a file from another table with the same fields to this
table's name (look into you database directory). After that I was able
to DROP the table.
But actually I have no idea how that file got deleted. Anybody?
Thanks,
Zsolt
>
> bob
>
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can't access a table. It seems to have been corrupted hsomehow
@ 2000-04-03 20:28 Joseph Shraibman <jks@p1.selectacast.net>
parent: Robert Chalmers <robert@chalmers.com.au>
1 sibling, 0 replies; 3+ messages in thread
From: Joseph Shraibman @ 2000-04-03 20:28 UTC (permalink / raw)
To: Robert Chalmers <robert@chalmers.com.au>; +Cc: pgsql-sql
Try vacuuming the database.
Robert Chalmers wrote:
> I have a database with a group of tables in it.
>
> One of the tables seems to have been modified somehow, and no - although I
> can see it with \d I can't actually do anyting to it. Any action, like
> rename, insert, drop gives a message "table doesn't exist". If I try to jsut
> creat it again, it says "can't do that, it already exists!" (words to that
> effect)
>
> So - does it exist or not? How do I actually get rid of that particular
> table all together without destroying the whole database?
>
> bob
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-04-03 20:28 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-04-01 08:49 Can't access a table. It seems to have been corrupted hsomehow Robert Chalmers <robert@chalmers.com.au>
2000-04-01 11:00 ` Tulassay Zsolt <zsolt@tek.bke.hu>
2000-04-03 20:28 ` Joseph Shraibman <jks@p1.selectacast.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox