Re: dropping sequences

I'm just getting around to dropping the sequence on my table (after a
hiatus)...

I would expect that you would first need to

ALTER TABLE ... COLUMN ... DROP DEFAULT

to remove the dependency on the sequence. Then drop sequence should work.

That doesn't seem to work, strangely -- I've executed the following command:

ALTER TABLE news ALTER COLUMN news_id DROP DEFAULT

Fine, and now my table looks like this:

be_db=# \d news;
Table "public.news"
+-[ RECORD 1 ]----------------------------+
| Column    | news_id                     |
| Type      | integer                     |
| Modifiers | not null                    |
+-[ RECORD 2 ]----------------------------+
| Column    | news_date                   |
| Type      | timestamp without time zone |
| Modifiers | not null                    |
+-[ RECORD 3 ]----------------------------+
| Column    | expire_date                 |
| Type      | date                        |
| Modifiers | not null                    |
+-[ RECORD 4 ]----------------------------+
| Column    | news_title                  |
| Type      | character varying(64)       |
| Modifiers | not null default ''         |
+-[ RECORD 5 ]----------------------------+
| Column    | news_info                   |
| Type      | text                        |
| Modifiers | not null                    |
+-[ RECORD 6 ]----------------------------+
| Column    | user_id                     |
| Type      | integer                     |
| Modifiers | not null                    |
+-----------+-----------------------------+
Indexes: news_pkey primary key btree (news_id)
Foreign Key constraints: $1 FOREIGN KEY (user_id) REFERENCES 
users(user_id) ON UPDATE NO ACTION ON D
ELETE NO ACTION

But when I try to drop the sequence altogether:

be_db=# DROP SEQUENCE news_news_id_seq;
ERROR: Cannot drop sequence news_news_id_seq because table news column
news_id requires it
You may drop table news column news_id instead

Anybody have a suggestion? I just want to remove these sequences from
the database altogether. Am I going to have to drop the news_id column
altogether?

Erik