we make a dump before ... and with a product pgmanager (ems tech) we do not show any foreign keys.<br /><br /> But I
thinkall of triggers of referenced table are not deleted.<br /><br /> We recreate the schemas ... and now is
running.<br/><br /> How is it possible to identify Triggers with no referenced tables ?<br /><br /><br /> Stephan Szabo
aécrit:<br /><blockquote cite="mid20030811061208.T72304-100000@megazone.bigpanda.com" type="cite"><pre wrap="">On Mon,
11Aug 2003, [ISO-8859-1] Beno?t Bournon wrote:
</pre><blockquote type="cite"><pre wrap="">No trigger
Just triggers for foreign key in spectacle and none in spectacle_v
How is it possible to verify triggers for foreign keys ? </pre></blockquote><pre wrap="">
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?
<a class="moz-txt-link-freetext"
href="http://archives.postgresql.org">http://archives.postgresql.org</a>
</pre></blockquote>