From: | "Ian deSouza" <iandesouza(at)earthlink(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: DROP SEQUENCE ? |
Date: | 2001-01-06 16:54:19 |
Message-ID: | %4I56.7010$Ps.320023@newsread2.prod.itd.earthlink.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
The PostgreSQL doc referencing this situation is at
http://www.postgresql.org/devel-corner/docs/user/datatype.htm#AEN1181
but it doesn't explain what the syntax is nor does it give an example.
So if Employee has an attribute called ID that is of type SERIAL, and we do
a
"DROP TABLE EMPLOYEE"
what kind of call should we issue to drop the sequence?
DROP SEQUENCE ...??
"Ian deSouza" <iandesouza(at)earthlink(dot)net> wrote in message
news:3Qv56(dot)2577$Ps(dot)115717(at)newsread2(dot)prod(dot)itd(dot)earthlink(dot)net(dot)(dot)(dot)
> 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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-06 16:54:22 | Re: Is libpq thread-safe? |
Previous Message | Frank Joerdens | 2001-01-06 16:12:27 | Re: PHP and PostgreSQL |