Postresql & triggers
От | Sergey V. Mikheev |
---|---|
Тема | Postresql & triggers |
Дата | |
Msg-id | Pine.BSF.4.05.10003311317050.878-100000@md.uniyar.ac.ru обсуждение исходный текст |
Список | 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 по дате отправления: