Re: [GENERAL] How to drop sequence?

[Ron St-Pierre]

Igor Kryltsov wrote:

Hi,

I have table:

# \d category;
 category_id   | integer                | not null default
nextval('public.category_category_id_seq'::text)
category_name | character varying(100) | not null
Indexes: category_pkey primary key btree (category_id)
My goal is to remove sequence from category_id column and remove it after
from DB.
First I tried:

DROP SEQUENCE  category_category_id_seq - fails saying that table category
column category_id uses it
Than I tried:

ALTER TABLE category ALTER COLUMN category_id DROP DEFAULT;

Now category_id column is shown as integer not null only but :

DROP SEQUENCE  category_category_id_seq - fails saying that table category
column category_id uses it again
Any suggestions?

Thank you,

Igor



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html
 

Try 

DROP SEQUENCE category_category_id_seq CASCADE;

Ron



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match