DROP SEQUENCE ? - Mailing list pgsql-general

From Ian deSouza
Subject DROP SEQUENCE ?
Date
Msg-id 3Qv56.2577$Ps.115717@newsread2.prod.itd.earthlink.net
Whole thread Raw
List 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




pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: Loading optimization
Next
From: Tom Lane
Date:
Subject: Re: Postgres 7.03 table describe problem