Hello,
I have postgresql 6.4.2 on bsdi3.1
here is one problem with triggers:
ser=> select updater();
updater
-------
t
(1 row)
ser=> \df updater
result|function|arguments|description
------+--------+---------+-----------
bool |updater | |
(1 row)
ser=> CREATE TRIGGER daemon_singleton BEFORE INSERT ON userd_users FOR EACH
ROW
EXECUTE PROCEDURE updater();
ERROR: CreateTrigger: function updater () does not exist
Can anybody tell me where is mistake ? updater is SQL function.
Thanx,
-----------------
Sergei Chernev
Internet: ser@nsu.ru
Phone: +7-3832-397354