dropping an unused sequence? - Mailing list pgsql-novice

From
Subject dropping an unused sequence?
Date
Msg-id 028701c6100f$e6133490$0201a8c0@iwing
Whole thread Raw
Responses Re: dropping an unused sequence?
List pgsql-novice
hi list

during table creation i mistakenly had a SERIAL instead of INTEGER type for
a value. i removed the default value (nextval....) for this field. still i
can't drop the old sequence:

ERROR:  cannot drop sequence kinos_normal_kn_k_id_seq because table
kinos_normal column kn_k_id requires it
HINT:  You may drop table kinoprogramm.kinos_normal column kn_k_id instead.

i know i may drop the field and recreate it, but this is very annoying as
views and foreign keys are already assigned to that particular field. is
there another way to drop the unused sequence?

thanks,
thomas



pgsql-novice by date:

Previous
From: "Luis Silva"
Date:
Subject: Re: function problem
Next
From: Tom Lane
Date:
Subject: Re: dropping an unused sequence?