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 g0L931V59414 for ; Mon, 21 Jan 2002 04:03:01 -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); Mon, 21 Jan 2002 10:03:02 +0100 Received: from ssdx ([129.132.184.236]) by xfe1.d.ethz.ch with Microsoft SMTPSVC(5.0.2195.2966); Mon, 21 Jan 2002 10:03:01 +0100 Message-ID: <0ab201c1a25a$6def9a20$ecb88481@ethz.ch> From: "Urs Steiner" To: Subject: list triggers ? Date: Mon, 21 Jan 2002 10:03:01 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" 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: 21 Jan 2002 09:03:01.0793 (UTC) FILETIME=[6DEA9110:01C1A25A] X-Archive-Number: 200201/242 X-Sequence-Number: 6326 Hi all yesterday, i created the following table: create table kunden (id serial primary key, name varchar(30) not null, adresse1 varchar(30) not null, adresse2 varchar(30), plz varchar(10) not null, ort varchar(30) not null, legi varchar(10) not null, tel1 varchar(20), tel2 varchar(20), email varchar(60), rechnung boolean default False not null, login varchar(10) not null, password varchar(10) not null, abteilung integer not null, constraint kunden_abt_fk FOREIGN key(abteilung) references kategorien ); part of the output of this command was: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) CREATE now, the creation is actually OK. But how do i find out which triggers exist and what they look like ? (generically, in this case i assume it to be some default, available fropm the docu) Thanks, Urs