Folks,
Please find enclosed a patch to the pl/perl documents that correctly
tells what arguments go to pl/perl triggers.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
Index: doc/src/sgml/plperl.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/plperl.sgml,v
retrieving revision 2.35
diff -c -r2.35 plperl.sgml
*** doc/src/sgml/plperl.sgml 30 Dec 2004 21:45:36 -0000 2.35
--- doc/src/sgml/plperl.sgml 17 Jan 2005 02:46:59 -0000
***************
*** 489,495 ****
</varlistentry>
<varlistentry>
! <term><literal>$_TD{name}</literal></term>
<listitem>
<para>
Name of the trigger being called
--- 489,495 ----
</varlistentry>
<varlistentry>
! <term><literal>$_TD->{name}</literal></term>
<listitem>
<para>
Name of the trigger being called
***************
*** 498,504 ****
</varlistentry>
<varlistentry>
! <term><literal>$_TD{event}</literal></term>
<listitem>
<para>
Trigger event: <literal>INSERT</>, <literal>UPDATE</>,
<literal>DELETE</>, or <literal>UNKNOWN</>
--- 498,504 ----
</varlistentry>
<varlistentry>
! <term><literal>$_TD->{event}</literal></term>
<listitem>
<para>
Trigger event: <literal>INSERT</>, <literal>UPDATE</>,
<literal>DELETE</>, or <literal>UNKNOWN</>
***************
*** 507,513 ****
</varlistentry>
<varlistentry>
! <term><literal>$_TD{when}</literal></term>
<listitem>
<para>
When the trigger was called: <literal>BEFORE</literal>,
<literal>AFTER</literal>, or <literal>UNKNOWN</literal>
--- 507,513 ----
</varlistentry>
<varlistentry>
! <term><literal>$_TD->{when}</literal></term>
<listitem>
<para>
When the trigger was called: <literal>BEFORE</literal>,
<literal>AFTER</literal>, or <literal>UNKNOWN</literal>
***************
*** 516,522 ****
</varlistentry>
<varlistentry>
! <term><literal>$_TD{level}</literal></term>
<listitem>
<para>
The trigger level: <literal>ROW</literal>,
<literal>STATEMENT</literal>, or <literal>UNKNOWN</literal>
--- 516,522 ----
</varlistentry>
<varlistentry>
! <term><literal>$_TD->{level}</literal></term>
<listitem>
<para>
The trigger level: <literal>ROW</literal>,
<literal>STATEMENT</literal>, or <literal>UNKNOWN</literal>
***************
*** 525,531 ****
</varlistentry>
<varlistentry>
! <term><literal>$_TD{relid}</literal></term>
<listitem>
<para>
OID of the table on which the trigger fired
--- 525,531 ----
</varlistentry>
<varlistentry>
! <term><literal>$_TD->{relid}</literal></term>
<listitem>
<para>
OID of the table on which the trigger fired
***************
*** 534,540 ****
</varlistentry>
<varlistentry>
! <term><literal>$_TD{relname}</literal></term>
<listitem>
<para>
Name of the table on which the trigger fired
--- 534,540 ----
</varlistentry>
<varlistentry>
! <term><literal>$_TD->{relname}</literal></term>
<listitem>
<para>
Name of the table on which the trigger fired
***************
*** 543,549 ****
</varlistentry>
<varlistentry>
! <term><literal>@{$_TD{argv}}</literal></term>
<listitem>
<para>
Arguments of the trigger function
--- 543,549 ----
</varlistentry>
<varlistentry>
! <term><literal>@{$_TD->{argv}}</literal></term>
<listitem>
<para>
Arguments of the trigger function
***************
*** 552,558 ****
</varlistentry>
<varlistentry>
! <term><literal>$_TD{argc}</literal></term>
<listitem>
<para>
Number of arguments of the trigger function
--- 552,558 ----
</varlistentry>
<varlistentry>
! <term><literal>$_TD->{argc}</literal></term>
<listitem>
<para>
Number of arguments of the trigger function
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org