Invisible tables

From: Webb Sprague <wsprague100(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Invisible tables
Date: 2000-04-16 17:25:10
Message-ID: 20000416172510.12259.qmail@web804.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

In my quest to learn PG and SQL programming, I have
created tables in a database "foo". I am able to
insert, select, etc just fine, but when I use "\dt" to
show them they don't appear. They ARE listed in the
system table "pg_tables", however.

I have also tried to createdb "test1" after destroying
it once, but I get "Sorry, test1 already exists", even
though I deleted it from "data/base/"

Any ideas on how to fix this? I am running 6.5.3 (the
last one before 7.0) on RH 6.0. I have also run out
disc space before this and had to destroy some
databases and init them again, if that is leading to
this weird behavior.

Thanks in advance

__________________________________________________
Do You Yahoo!?
Send online invitations with Yahoo! Invites.
http://invites.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marten Feldtmann 2000-04-16 17:28:31 Re: To BLOB Or Not To BLOB
Previous Message Jurgen Defurne 2000-04-16 11:55:38 Re: Messages to Front End