Triggers ? - Mailing list pgsql-general

From Sergei Chernev
Subject Triggers ?
Date
Msg-id 002a01be8ff6$609d7050$59d17cc1@cnit.nsu.ru
Whole thread Raw
List 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@nsu.ru
Phone: +7-3832-397354



pgsql-general by date:

Previous
From: Statistical Solutions
Date:
Subject: Re: [GENERAL] advice on buying sun hardware to run postgres
Next
From: "Marko's Work"
Date:
Subject: Postgres/PHP error message