Triggers ?

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

Browse pgsql-general by date

  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