urgent, Table not shown but files are there. - Mailing list pgsql-admin

From Bill Hilburn
Subject urgent, Table not shown but files are there.
Date
Msg-id 1049835566.3e93382eefdac@webmail.frontier.net
Whole thread Raw
Responses Re: urgent, Table not shown but files are there.  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-admin
Hi All,

I have inherited a Postgresql DB server, this morning one of the tables is no
longer available to scripts and does not show up in psql.

The main directory for the database is still there and all of the files in it
including the file(s) for the table that is not showing up.

From what someone here said this has happened before and the old db admin
would just fix it in a couple of minutes, I'm new to Postgresql and have not a
clue.

Anyone seen this behaviour before?  Any ideas?


Thanks


Bill Hilburn
NOC Frontier Internet

-------------------------------------------------
This mail sent through frontier.net webmail service!


pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: How does PostgreSQL treat null values in unique composite
Next
From: Robert Treat
Date:
Subject: Re: How does PostgreSQL treat null values in unique