Re: Fw: Removing foreign key and adding sequence - Mailing list pgsql-novice

From Chad Thompson
Subject Re: Fw: Removing foreign key and adding sequence
Date
Msg-id 002f01c33c28$9c54fe00$32021aac@chad
Whole thread Raw
In response to Fw: Removing foreign key and adding sequence  ("Chad Thompson" <chad@weblinkservices.com>)
Responses Re: Fw: Removing foreign key and adding sequence  (Nabil Sayegh <postgresql@e-trolley.de>)
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


pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: basic question
Next
From: "Fontenot, Paul"
Date:
Subject: Greater than a value