Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3

we make a dump before ... and with a product pgmanager (ems tech) we do
not show any foreign keys.

But I think all of triggers of referenced table are not deleted.

We recreate the schemas ... and now is running.

How is it possible to identify Triggers with no referenced tables ?

Stephan Szabo a écrit:

>On Mon, 11 Aug 2003, [ISO-8859-1] Beno?t Bournon wrote:
>
>
>
>>No trigger
>>
>>Just triggers for foreign key in spectacle and none in spectacle_v
>>
>>How is it possible to verify triggers for foreign keys ?
>>
>>
>
>Generally a select on pg_trigger. Each foreign key should have 3
>triggers, 1 on the referencing table and 2 on the referenced. You find the
>tables involved by crossreferencing tgrelid against the oid of the row
>in pg_class.
>
>Can you send the results of a pg_dump -s?
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>