diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/man/create_trigger.l | 12 | ||||
| -rw-r--r-- | src/man/drop_trigger.l | 12 |
2 files changed, 15 insertions, 9 deletions
diff --git a/src/man/create_trigger.l b/src/man/create_trigger.l index dee152d9b55..b4ecb48ab4d 100644 --- a/src/man/create_trigger.l +++ b/src/man/create_trigger.l @@ -1,14 +1,17 @@ .\" This is -*-nroff-*- .\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/src/man/Attic/create_trigger.l,v 1.1 1997/09/26 15:13:08 thomas Exp $ +.\" $Header: /cvsroot/pgsql/src/man/Attic/create_trigger.l,v 1.2 1997/09/30 09:50:27 vadim Exp $ .TH "CREATE TRIGGER" SQL 09/25/97 PostgreSQL .SH NAME create trigger \(em create a new trigger .SH SYNOPSIS .nf -\fBcreate trigger\fR trigname \fB{before|after}\fP \fB{insert|update|delete}\fB +\fBcreate trigger\fR trigname \fB{before|after}\fP + \fB{Event1 [OR Event2 [OR Event3]]}\fB \fBon\fR relname \fBfor each {row|statement}\fR \fBexecute procedure\fR funcname \fB(\fR arguments \fB)\fR + +where \fBEventX\fR is one of INSERT, DELETE, UPDATE .fi .SH DESCRIPTION .BR "Create Trigger" @@ -18,6 +21,9 @@ associated with the relation and will execute the specified .IR funcname . +Only relation owner may create a trigger on this relation. + +Currently, STATEMENT triggers are not implemented. .PP The trigger can be specified to fire either .BR before @@ -30,7 +36,7 @@ If the trigger fires .BR before then the trigger may skip the operation for the current tuple, -or change the current tuple (for insert/delete operations only). +or change tuple being inserted (for insert/update operations only). If the trigger fires .BR after then all changes including the last insertion/updation/deletion diff --git a/src/man/drop_trigger.l b/src/man/drop_trigger.l index 933bd8cbbb0..211a8539cf8 100644 --- a/src/man/drop_trigger.l +++ b/src/man/drop_trigger.l @@ -1,23 +1,23 @@ .\" This is -*-nroff-*- .\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/src/man/Attic/drop_trigger.l,v 1.1 1997/09/26 15:13:09 thomas Exp $ +.\" $Header: /cvsroot/pgsql/src/man/Attic/drop_trigger.l,v 1.2 1997/09/30 09:50:28 vadim Exp $ .TH "DROP TRIGGER" SQL 09/26/97 PostgreSQL .SH NAME -drop trigger \(em destroy existing classes +drop trigger \(em destroy existing trigger .SH SYNOPSIS .nf -\fBdrop trigger\fR trigname +\fBdrop trigger\fR trigname \fBon\fR relname .fi .SH DESCRIPTION .BR "Drop Trigger" -removes triggers from the data base. Only its owner may destroy a +removes trigger for relation from the data base. Only relation owner may destroy a trigger. .SH EXAMPLE .nf -- ---Destroy the empverify trigger +--Destroy the empverify trigger on relation emp -- -drop trigger empverify +drop trigger empverify on emp .fi .SH "SEE ALSO" create trigger(l). |