From: | "Ian deSouza" <iandesouza(at)earthlink(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: DROP SEQUENCE ? |
Date: | 2001-01-06 17:42:35 |
Message-ID: | fOI56.7342$Ps.333215@newsread2.prod.itd.earthlink.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Figure it out:
metamousetrap=> create table my_table (first serial, second varchar);
NOTICE: CREATE TABLE will create implicit sequence 'my_table_first_seq' for SERIAL column 'my_table.first'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'my_table_first_key' for table 'my_table'
CREATE
metamousetrap=> drop table my_table;
DROP
metamousetrap=> drop sequence my_table_first_seq;
DROP
Anyone know how to list what sequences already exist?
Thanks, Ian
"Ian deSouza" <iandesouza(at)earthlink(dot)net> wrote in message news:%4I56(dot)7010$Ps(dot)320023(at)newsread2(dot)prod(dot)itd(dot)earthlink(dot)net(dot)(dot)(dot)
> 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 | Thomas T. Thai | 2001-01-06 17:46:30 | XLogWrite: had to create new log file |
Previous Message | GH | 2001-01-06 17:22:07 | Re: PHP and PostgreSQL |