DROP TABLE Appears to Fail

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: DROP TABLE Appears to Fail
Date: 2011-06-28 22:34:16
Message-ID: alpine.LNX.2.00.1106281529570.30381@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I cannot recall issuing a DROP TABLE command from psql that did not work,
but seem to have this as a new experience.

When I look at the database table list with '\d' I see

public | station_type | table | rshepard
public | station_type_statype_seq | sequence | rshepard

and I want to drop and recreate these with a typo fixed. But, the drop
commands do not appear to work:

# drop table station_type

# \d

public | station_type | table | rshepard
public | station_type_statype_seq | sequence | rshepard

I fail to see what I'm doing incorrectly and would appreciate a clue stick
to set me on the proper path.

TIA,

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Firel 2011-06-28 22:41:13 Re: DROP TABLE Appears to Fail
Previous Message Grace Batumbya 2011-06-28 22:13:09 Windows x64 : How do I get OSSP-UUID.sql contrib for postgresql x64