Is this a bug? (changing sequences in default value) - Mailing list pgsql-general

From Fernando Schapachnik
Subject Is this a bug? (changing sequences in default value)
Date
Msg-id 20080508115207.GA1159@bal740r0.mecon.gov.ar
Whole thread Raw
Responses Re: Is this a bug? (changing sequences in default value)
List pgsql-general
Pg 8.1.11, I try to change sequences as default value of a table, then
remove old sequence:

# \d table1
                               Table "table1"
 Column |  Type   |                           Modifiers
--------+---------+---------------------------------------------------------------
 id     | integer | not null default nextval('table1_id_seq'::regclass)
 nombre | text    | not null
Indexes:
    "table1_pkey" PRIMARY KEY, btree (id)

# ALTER TABLE table1 alter column id set default nextval('newseq_id_seq');
ALTER TABLE

# \d table1
                               Table "table1"
 Column |  Type   |                           Modifiers
--------+---------+---------------------------------------------------------------
 id     | integer | not null default nextval('newseq_id_seq'::regclass)
 nombre | text    | not null
Indexes:
    "table1_pkey" PRIMARY KEY, btree (id)

# drop SEQUENCE table1_id_seq ;
ERROR:  cannot drop sequence table1_id_seq because table
table1 column id requires it
HINT:  You may drop table table1 column id instead.

Am I doing something wrong?

Thanks!

Fernando.

pgsql-general by date:

Previous
From: "josep porres"
Date:
Subject: Re: reproducible database crash with simple sql command on postgres 8.3.1
Next
From: "Merlin Moncure"
Date:
Subject: Re: Is this a bug? (changing sequences in default value)