Postresql & triggers - Mailing list pgsql-hackers

From Sergey V. Mikheev
Subject Postresql & triggers
Date
Msg-id Pine.BSF.4.05.10003311317050.878-100000@md.uniyar.ac.ru
Whole thread Raw
List pgsql-hackers
Hi all!
 Can anybody help me with it?

Used FreeBSD 3.3-STABLE, PostgreSQL7.0beta2( and 6.5.Х  )
compiled with options: --enable-locale --enable-recode 
--enable-multibyte=KOI8  --with-odbc  --with-CC=gcc --with-CXX=gcc
--with-perl --with-tcl --with-maxbackends=5 --with-include=/usr/local/include
--with-tclconfig=/usr/local/lib/tcl8.0 --with-tkconfig=/usr/local/lib/tk8.0

sklad=> create table aaa ( id int4, hmm int4 );
CREATE
sklad=> \d aaa         Table "aaa"Attribute |  Type   | Modifier
-----------+---------+----------id        | integer |hmm       | integer |

sklad=> create table bbb ( id int4, hmm2 int4 );
CREATE
sklad=> \d bbb         Table "bbb"Attribute |  Type   | Modifier
-----------+---------+----------id        | integer |hmm2      | integer |

sklad=> create function proc_del_aaa ( int4 ) returns opaque as ' begin
delete from bbb where id = $1; end; ' language 'plpgsql';
CREATE

sklad=> create trigger trig_del_aaa after delete on aaa FOR EACH ROW
EXECUTE PROCEDURE proc_del_aaa ( id );
ERROR:  CreateTrigger: function proc_del_aaa() does not exist

sklad=> create trigger trig_del_aaa after delete on aaa FOR EACH ROW
EXECUTE PROCEDURE proc_del_aaa ( 'id' );
ERROR:  CreateTrigger: function proc_del_aaa() does not exist

sklad=> drop function proc_del_aaa( int4 );
DROP

sklad=>


------------------------------------------------------+-----------------------+
... One child is not enough, but two are far too many.|        FreeBSD          |                          |  The power
toserve!  |Mikheev Sergey <gsh@md.uniyar.ac.ru>          |http://www.FreeBSD.org/|
+=======================+



pgsql-hackers by date:

Previous
From: gravity@dds.nl
Date:
Subject: Re: 6.5.0 datetime bug?
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: slow join on postgresql6.5