8000 Little changes. · postgrespro/postgres_cluster@a788027 · GitHub
[go: up one dir, main page]

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit a788027

Browse files
committed
Little changes.
1 parent 7a5d3fb commit a788027

File tree

2 files changed

+15
-9
lines changed

2 files changed

+15
-9
lines changed

src/man/create_trigger.l

Lines changed: 9 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,14 +1,17 @@
11
.\" This is -*-nroff-*-
22
.\" XXX standard disclaimer belongs here....
3-
.\" $Header: /cvsroot/pgsql/src/man/Attic/create_trigger.l,v 1.1 1997/09/26 15:13:08 thomas Exp $
3+
.\" $Header: /cvsroot/pgsql/src/man/Attic/create_trigger.l,v 1.2 1997/09/30 09:50:27 vadim Exp $
44
.TH "CREATE TRIGGER" SQL 09/25/97 PostgreSQL
55
.SH NAME
66
create trigger \(em create a new trigger
77
.SH SYNOPSIS
88
.nf
9-
\fBcreate trigger\fR trigname \fB{before|after}\fP \fB{insert|update|delete}\fB
9+
\fBcreate trigger\fR trigname \fB{before|after}\fP
10+
\fB{Event1 [OR Event2 [OR Event3]]}\fB
1011
\fBon\fR relname \fBfor each {row|statement}\fR
1112
\fBexecute procedure\fR funcname \fB(\fR arguments \fB)\fR
13+
14+
where \fBEventX\fR is one of INSERT, DELETE, UPDATE
1215
.fi
1316
.SH DESCRIPTION
1417
.BR "Create Trigger"
@@ -18,6 +21,9 @@ associated with the relation
1821
and will execute the specified
1922
.IR funcname .
2023

24+
Only relation owner may create a trigger on this relation.
25+
26+
Currently, STATEMENT triggers are not implemented.
2127
.PP
2228
The trigger can be specified to fire either
2329
.BR before
@@ -30,7 +36,7 @@ If the trigger fires
3036
.BR before
3137
then the trigger may
3238
skip the operation for the current tuple,
33-
or change the current tuple (for insert/delete operations only).
39+
or change tuple being inserted (for insert/update operations only).
3440
If the trigger fires
3541
.BR after
3642
then all changes including the last insertion/updation/deletion

src/man/drop_trigger.l

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -1,23 +1,23 @@
11
.\" This is -*-nroff-*-
22
.\" XXX standard disclaimer belongs here....
3-
.\" $Header: /cvsroot/pgsql/src/man/Attic/drop_trigger.l,v 1.1 1997/09/26 15:13:09 thomas Exp $
3+
.\" $Header: /cvsroot/pgsql/src/man/Attic/drop_trigger.l,v 1.2 1997/09/30 09:50:28 vadim Exp $
44
.TH "DROP TRIGGER" SQL 09/26/97 PostgreSQL
55
.SH NAME
6-
drop trigger \(em destroy existing classes
6+
drop trigger \(em destroy existing trigger
77
.SH SYNOPSIS
88
.nf
9-
\fBdrop trigger\fR trigname
9+
\fBdrop trigger\fR trigname \fBon\fR relname
1010
.fi
1111
.SH DESCRIPTION
1212
.BR "Drop Trigger"
13-
removes triggers from the data base. Only its owner may destroy a
13+
removes trigger for relation from the data base. Only relation owner may destroy a
1414
trigger.
1515
.SH EXAMPLE
1616
.nf
1717
--
18-
--Destroy the empverify trigger
18+
--Destroy the empverify trigger on relation emp
1919
--
20-
drop trigger empverify
20+
drop trigger empverify on emp
2121
.fi
2222
.SH "SEE ALSO"
2323
create trigger(l).

0 commit comments

Comments
 (0)
0