Re: Fw: Removing foreign key and adding sequence - Mailing list 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