OpenForum RSS: pgsql trigger

pgsql trigger (oppofan)

Tue, 20 May 2008 15:13:12 GMT

��! �� , �� !

CREATE OR REPLACE FUNCTION fn_add_services()
RETURNS trigger AS $fn_add_services$
declare
id_user int8;
begin
id_user := currval('users_id_seq');
insert into proxy(user_id,allow,current,quote,login,password,base_quote) values(id_user,'f',0,0,'','',52428800);
insert into mail_users(user_id,allow,login,password) values(id_user,'f','','');
return NULL;
end;
$fn_add_services$ LANGUAGE plpgsql;

create trigger tg_add_user after insert on users for each row execute procedure fn_add_services();

�� - �� , � � �� :-)

pgsql trigger (pavel_simple)

Tue, 20 May 2008 14:18:43 GMT

>[�� ]
>>� �� --��
>
>:-( � �� ... �� ... � ��
>�� :-(
>
>create trigger tg_add_user after insert on users for each row execute procedure
>fn_add_services(int4);
>�� -�� ... ��-�� ...
>
>��... FreeBSD 6.1, PGSQL 8.2.1

�� -- return type �� trigger -- � �� -- �� http://www.postgresql.org/docs/8.2/static/index.html

pgsql trigger (oppofan)

Tue, 20 May 2008 14:03:12 GMT

>�� -- 0 � 1
>� �� --��

:-( � �� ... �� ... � �� :-(

create trigger tg_add_user after insert on users for each row execute procedure fn_add_services(int4);
�� -�� ... ��-�� ...

��... FreeBSD 6.1, PGSQL 8.2.1

pgsql trigger (pavel_simple)

Tue, 20 May 2008 13:56:12 GMT

�� -- 0 � 1
� �� --��