Re: DROP SEQUENCE ?
| От | Ian deSouza |
|---|---|
| Тема | Re: DROP SEQUENCE ? |
| Дата | |
| Msg-id | fOI56.7342$Ps.333215@newsread2.prod.itd.earthlink.net обсуждение исходный текст |
| Ответ на | Re: DROP SEQUENCE ? ("Ian deSouza" <iandesouza@earthlink.net>) |
| Ответы |
Re[2]: DROP SEQUENCE ?
Re: Re: DROP SEQUENCE ? |
| Список | 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
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@earthlink.net> wrote in message news:%4I56.7010$Ps.320023@newsread2.prod.itd.earthlink.net...
> 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@earthlink.net> wrote in message
> news:3Qv56.2577$Ps.115717@newsread2.prod.itd.earthlink.net...
> > 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 по дате отправления: