pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Can'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>
  2000-04-01 11:00 ` Re: Can't access a table. It seems to have been corrupted hsomehow Tulassay Zsolt <zsolt@tek.bke.hu>
  2000-04-03 20:28 ` Re: Can't access a table. It seems to have been corrupted hsomehow Joseph Shraibman <jks@p1.selectacast.net>
  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 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>
  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-01 08:49 Can't access a table. It seems to have been corrupted hsomehow Robert Chalmers <robert@chalmers.com.au>
@ 2000-04-03 20:28 ` Joseph Shraibman <jks@p1.selectacast.net>
  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