From: | "Sergey V(dot) Mikheev" <gsh(at)md(dot)uniyar(dot)ac(dot)ru> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Postresql & triggers |
Date: | 2000-03-31 09:17:50 |
Message-ID: | Pine.BSF.4.05.10003311317050.878-100000@md.uniyar.ac.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 to serve! |
Mikheev Sergey <gsh(at)md(dot)uniyar(dot)ac(dot)ru> |http://www.FreeBSD.org/|
+=======================+
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Meskes | 2000-03-31 10:02:45 | Re: BIT datatype |
Previous Message | gravity | 2000-03-31 08:21:34 | Re: 6.5.0 datetime bug? |