Re: Fw: Removing foreign key and adding sequence

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