Re: Fw: Removing foreign key and adding sequence
От | Chad Thompson |
---|---|
Тема | Re: Fw: Removing foreign key and adding sequence |
Дата | |
Msg-id | 002f01c33c28$9c54fe00$32021aac@chad обсуждение исходный текст |
Ответ на | Fw: Removing foreign key and adding sequence ("Chad Thompson" <chad@weblinkservices.com>) |
Ответы |
Re: Fw: Removing foreign key and adding sequence
|
Список | pgsql-novice |
> > 7.32. Can I just drop the foreign key? That would be SO much easier :-) > > Since 7.3 it's very easy, but even with 7.2 you could: > > 7.3: > \d table_name > if the key is labeled with e.g. $1: > ALTER TABLE table_name DROP CONSTRAINT "$1"; > > Hrm... What could I be doing wrong? db=# \d lists Table "public.lists" Column | Type | Modifiers ------------------+-----------------------+--------------------------------- ----------------- id | bigint | not null default nextval('"lists_id_seq"'::text) first_name | character varying(50) | middle_initial | character(1) | last_name | character varying(30) | [SNIP] lol_id_idx btree (list_of_lists_id) Triggers: RI_ConstraintTrigger_10337839, RI_ConstraintTrigger_10337842, RI_ConstraintTrigger_10337860 db=# alter table lists drop constraint "RI_ConstraintTrigger_10337839"; ERROR: ALTER TABLE / DROP CONSTRAINT: RI_ConstraintTrigger_10337839 does not exist db=# alter table lists drop constraint RI_ConstraintTrigger_10337839; ERROR: ALTER TABLE / DROP CONSTRAINT: ri_constrainttrigger_10337839 does not exist
В списке pgsql-novice по дате отправления: