| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
| Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Renaming a constraint |
| Date: | 2008-02-06 16:03:55 |
| Message-ID: | 9987.1202313835@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Csaba Nagy <nagy(at)ecircle-ag(dot)com> writes:
> On Tue, 2008-02-05 at 12:11 -0500, Tom Lane wrote:
>> Csaba Nagy <nagy(at)ecircle-ag(dot)com> writes:
>>> Is this still safe to do ?
>>
>> What kind of constraint?
> The only ones left are foreign key constraints. I had a few not nulls
> too, but those are not actually there anyway (see my other post).
IIRC, the name of an FK constraint also appears in the arguments for its
triggers. If you didn't update those too, the behavior might be a bit
inconsistent, depending on which PG version you're using. In particular
I'm not sure which name pg_dump will believe.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Hart | 2008-02-06 16:15:10 | Re: postgresql book - practical or something newer? |
| Previous Message | vincent | 2008-02-06 15:46:02 | Re: postgresql book - practical or something newer? |