| 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: | Whole Thread | Raw Message | 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.
| 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? |