Re: NOTICE: ignoring incomplete trigger group for constraint

On 05/21/2010 11:18 AM, Tom Lane wrote:
>
> Yeah, this is known to happen in some cases where there was a broken
> (incompletely enforced) foreign key constraint in your old database.
> The odds are good that what you should do is nothing at all, because
> you probably didn't even realize you still had the FK constraint in the
> old database: the most common error cases weren't enforced.  It's likely
> that if you try to add the FK constraint now, you'll find it fails
> because the data doesn't even satisfy the constraint.  So you could
> just leave things alone and the new database will behave approximately
> like the old one did.  But if you really want to add the FK constraint
> back in, ALTER TABLE ADD FOREIGN KEY is the way.
>
>

  hi,  i made  the alter table to add the foreign key, but  in some
constraints i have the  follow  error:


ERROR: there is no unique constraint matching given keys for referenced
table "table_name'"


there is a way to solve this?? what can i do ??


regards, erobles