Received: from xfe3.d.ethz.ch (xsmtp.ethz.ch [129.132.97.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0MFmpl78695 for ; Tue, 22 Jan 2002 10:48:52 -0500 (EST) (envelope-from postgresql@darkstone.ch) Received: from xfe1.d.ethz.ch ([192.168.36.10]) by xfe3.d.ethz.ch with Microsoft SMTPSVC(5.0.2195.2966); Tue, 22 Jan 2002 16:48:55 +0100 Received: from ssdx ([129.132.184.236]) by xfe1.d.ethz.ch with Microsoft SMTPSVC(5.0.2195.2966); Tue, 22 Jan 2002 16:48:55 +0100 Message-ID: <0dfc01c1a35c$4c78fa00$ecb88481@ethz.ch> From: "Urs Steiner" To: References: <20020121100326.I95108-100000@megazone23.bigpanda.com> Subject: Re: list triggers ? Date: Tue, 22 Jan 2002 16:48:53 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-OriginalArrivalTime: 22 Jan 2002 15:48:55.0804 (UTC) FILETIME=[4C737BC0:01C1A35C] X-Archive-Number: 200201/255 X-Sequence-Number: 6339 Hi Stephan >> NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY >> check(s) >> CREATE > select relname, tgname, tgtype, proname, prosrc, tgisconstraint, > tgconstrname, tgconstrrelid, tgdeferrable, tginitdeferred, tgnargs, > tgattr, tgargs from (pg_trigger join pg_class on tgrelid=pg_class.oid) > join pg_proc on (tgfoid=pg_proc.oid); ok, if fone that and i could even modify the statement (where relname='kunden'), so i get only the ones i want to see ... relname | tgname | tgtype | proname | prosrc | tgisconstraint | tgconstrname | tgconstrrelid | tgdeferrable | tginitdeferred | tgnargs | tgattr | tgargs ---------+----------------------------+--------+----------------------+- ---------------------+----------------+-----------------------+--------- ------+--------------+----------------+---------+--------+-------------- --------------------------------------------------------------------- kunden | RI_ConstraintTrigger_19083 | 21 | RI_FKey_check_ins | RI_FKey_check_ins | t | kunden_abt_fk | 18972 | f | f | 6 | | kunden_abt_fk\000kunden\000kategorien\000UNSPECIFIED\000abteilung\000id\ 000 kunden | RI_ConstraintTrigger_19290 | 9 | RI_FKey_noaction_del | RI_FKey_noaction_del | t | mitarbeiter_kunden_fk | 19268 | f | f | 6 | | mitarbeiter_kunden_fk\000mitarbeiter\000kunden\000UNSPECIFIED\000id\000i d\000 [and some more] as much as i get it, i want the first one, and i want to delete it (erronous construction) ... deleting is done with "DROP TRIGGER ON kunden;" but what is the trigger name ? tgname doesnt work, tgconstrname also not or am i entirely on the wrong track ? TIA, Urs