| 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: | Whole Thread | Raw Message | 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 |