Re: Q: Rename constraint

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tilo Schwarz <mail(at)tilo-schwarz(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Q: Rename constraint
Date: 2003-01-28 22:26:42
Message-ID: 4397.1043792802@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tilo Schwarz <mail(at)tilo-schwarz(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message eric soroos 2003-01-28 22:37:14 ERROR: ExecEvalAggref
Previous Message Gordan Bobic 2003-01-28 22:12:15 Re: list server problems?