How to drop sequence?

From: "Igor Kryltsov" <kryltsov(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to drop sequence?
Date: 2004-02-26 01:28:51
Message-ID: c1jhuh$28bq$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eric B.Ridge 2004-02-26 01:32:30 Re: key = currval('tab_key_seq') choses SEQSCAN?!
Previous Message cnliou 2004-02-26 01:04:23 Re: invalid memory alloc request size