Remove Modifiers on Table

From: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Remove Modifiers on Table
Date: 2011-05-16 18:26:21
Message-ID: BANLkTimtJz_q39j0MSaNHEmPvPVLtvR00g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks for any assistance.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Osvaldo Kussama 2011-05-16 18:37:30 Re: Query to return every 1st Sat of a month between two dates
Previous Message Bernardo Telles 2011-05-16 18:19:24 Re: How do we combine and return results from multiple queries in a loop?