From: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com> |
---|---|
To: | Ron Peterson <rpeterson(at)yellowbank(dot)com> |
Cc: | Hrvoje Niksic <hniksic(at)iskon(dot)hr>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Dropping tables |
Date: | 2000-06-15 16:13:42 |
Message-ID: | 394900B6.D77A911E@austin.rr.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ron Peterson wrote:
>
> Hrvoje Niksic wrote:
> >
> > 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
> >
> > Huh? What is this? Oh, x_id_key somehow survived DROP TABLE.
> > Bummer. Maybe I can use DROP INDEX to drop it?
>
> Close. Try DROP SEQUENCE.
And this is a known gotcha (I now actually consider it a feature, if a bit unintuitive):
http://www.postgresql.org/docs/postgres/datatype.htm#AEN946
Regards,
Ed Loehr
From | Date | Subject | |
---|---|---|---|
Next Message | Robert D. Nelson | 2000-06-15 16:31:00 | RE: libpgtcl.so missing from pgaccess on FreeBSD4.0? |
Previous Message | Mike Mascari | 2000-06-15 16:13:04 | Re: |