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