Skip site navigation (1) Skip section navigation (2)

Postgres not finding tables

From: James Hall <James(dot)Hall(at)RadioShack(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Postgres not finding tables
Date: 2000-10-30 15:54:30
Message-ID: DD6FD0C9668DD311AA040008C7566E8A0313E6A3@ntmailc.tandy.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello All,

I have 2 identical machines running redhat 5.2 and postgres 6.5.
One machine is a replica of the other (backup).

Recently I noticed that postgres gives the error:
"Couldn't find any tables, sequences or indices!"

whenever I tried '\d' or '\d*' on one of the machines. 
BUT the database DOES contain tables because I can execute 'select * from
testtable;' and postgres will display the table info.

The tables are there, but for some reason postgres can't see them correctly.

Has anyone seen this before, if so any help is greatly appreciated!

TIA-
Jim

pgsql-novice by date

Next:From: Thomas GoodDate: 2000-10-30 16:12:53
Subject: changing datestyle
Previous:From: Poul L. ChristiansenDate: 2000-10-30 14:35:52
Subject: Re: Installation of Postgres + PHP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group