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
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 |