Re: Q: Rename constraint - Mailing list pgsql-general

From Tom Lane
Subject Re: Q: Rename constraint
Date
Msg-id 4397.1043792802@sss.pgh.pa.us
Whole thread Raw
In response to Q: Rename constraint  (Tilo Schwarz <mail@tilo-schwarz.de>)
List pgsql-general
Tilo Schwarz <mail@tilo-schwarz.de> writes:
> Now my question is, if I can directly change the value of
> "pg_constraint.conname", or am I calling for trouble that way?

If it's a foreign-key constraint, I think you'd also need to update
pg_trigger.tgconstrname for the triggers belonging to the constraint.

            regards, tom lane

pgsql-general by date:

Previous
From: "Terri Lerose"
Date:
Subject: Re: How do I unsubscribe?
Next
From: Uros Gruber
Date:
Subject: Re: tsearch comments