On 22/05/2010 17:03, erobles wrote:
> 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 ??
It means you need to have a primary key, or at least a unique
constraint, on the target table which uses the
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
erobles writes:
>
[ Please don't send all-html mail to the lists ]
> I have running postgres 8.3.1 and a dump file from postgers 7.2
> :-P , but when i tried to restore the dump i have the next
> message:
> psql:lostriggers:10: NOTICE: ignoring incomplete trigger group for
> const
hi !
I have running postgres 8.3.1 and a dump file from postgers 7.2
:-P , but when i tried to restore the dump i have the next
message:
(by the way i made the dump file using pg_dump of postgresql 8.3)
CREATE CONSTRAINT TRIGGER "valida_ent_a_sal" AFTER DELETE ON "ent_a"
IN
