Csaba Nagy <nagy@ecircle-ag.com> writes:
> On Tue, 2008-02-05 at 12:11 -0500, Tom Lane wrote:
>> Csaba Nagy <nagy@ecircle-ag.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