list triggers ?
От | Urs Steiner |
---|---|
Тема | list triggers ? |
Дата | |
Msg-id | 0ab201c1a25a$6def9a20$ecb88481@ethz.ch обсуждение исходный текст |
Ответы |
Re: list triggers ?
|
Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: