Dropping tables

From: Hrvoje Niksic <hniksic(at)iskon(dot)hr>
To: pgsql-general(at)postgresql(dot)org
Cc: hniksic(at)iskon(dot)hr
Subject: Dropping tables
Date: 2000-06-14 14:56:36
Message-ID: dp8zw8tior.fsf@mraz.iskon.hr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[ Please Cc the responses to me, because I'm not on the list. ]

DROP TABLE does not seem to allow me to fully drop a table. Example:

test=# CREATE TABLE x (id SERIAL);
NOTICE: CREATE TABLE will create implicit sequence 'x_id_seq' for SERIAL column 'x.id'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'x_id_key' for table 'x'CREATE

The notices look ominous, but I understand their meaning. OK. Now
say I want to drop the table:

test=# DROP TABLE x;
DROP

Cool. Now say I want to create an `x' table again:

test=# CREATE TABLE x (id SERIAL);
NOTICE: CREATE TABLE will create implicit sequence 'x_id_seq' for SERIAL column 'x.id'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'x_id_key' for table 'x'
ERROR: Relation 'x_id_seq' already exists

Huh? What is this? Oh, x_id_key somehow survived DROP TABLE. Maybe
I can use DROP INDEX to drop it?

test=# DROP INDEX x_id_seq;
ERROR: relation "x_id_seq" is of type "S"

Oh, x_id_seq is of type "S" -- of course I can't delete it. That was
a joke. Seriously, what am I supposed to do to get rid of it?

Or, better said, what do I do to completely and totally delete a
table?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed Loehr 2000-06-14 14:56:51 Re: Question reagarding serial type.
Previous Message Ron Peterson 2000-06-14 14:50:29 Re: Performance of PostgreSQL vs. Other DBs