DROP SEQUENCE ?

From: "Ian deSouza" <iandesouza(at)earthlink(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: DROP SEQUENCE ?
Date: 2001-01-06 02:57:03
Message-ID: 3Qv56.2577$Ps.115717@newsread2.prod.itd.earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Anybody know the syntax of the DROP SEQUENCE sql statement for PostgreSQL?

Once I create a table with an attribute of type SERIAL, and drop the table,
I cannot recreate the table since the sequence already exists (and DROP
TABLE tableName does not remove the sequence entry). Does anybody know what
I would have to do to follow the DROP TABLE w/ to remove the "sequence"
created by the SERIAL datatype?

Thanks in advance, Ian

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave VanAuken 2001-01-06 02:58:33 RE: SHM ids (was running pgsql 7 under Jail'ed virtual machine on FreeBSD 4.2)
Previous Message Tom Lane 2001-01-06 01:46:24 Re: PL/pgSQL NOT NULL variables