From: | "Sergei Chernev" <ser(at)nsu(dot)ru> |
---|---|
To: | <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Triggers ? |
Date: | 1999-04-26 15:06:35 |
Message-ID: | 002a01be8ff6$609d7050$59d17cc1@cnit.nsu.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)nsu(dot)ru
Phone: +7-3832-397354
From | Date | Subject | |
---|---|---|---|
Next Message | Marko's Work | 1999-04-26 16:12:02 | Postgres/PHP error message |
Previous Message | Statistical Solutions | 1999-04-26 13:51:24 | Re: [GENERAL] advice on buying sun hardware to run postgres |