Re: Remove Modifiers on Table

Carlos Mennens wrote:
> I created a modifier for auto incrementing my primary key as follows:
>
> records=# \d users
>                                 Table "public.users"
>  Column |         Type          |                     Modifiers
> --------+-----------------------+----------------------------------------------------
>  id     | integer               | not null default
> nextval('users_seq_id'::regclass)
>  fname  | character varying(40) | not null
>  lname  | character varying(40) | not null
>  email  | character varying(40) | not null
>  office | character varying(5)  | not null
>  dob    | date                  | not null
>  title  | character varying(40) | not null
> Indexes:
>     "users_pkey" PRIMARY KEY, btree (id)
>     "users_email_key" UNIQUE, btree (email)
>
> I recently tried to remove the modifier and it failed because it was
> associated with the 'id' column so my question is how do I remove /
> delete the modifier so I can delete the sequence I created to auto
> increment my 'id' value? I don't want to drop the id column / loss my
> column data, I just want to remove the associated modifier so I can
> drop the sequence.

If you are truly intent on removing the sequence you'll need to do the
following:

   alter sequence users_seq_id owned by NONE
   alter table users alter column id drop default
   drop sequence users_seq_id

HTH

Bosco.