Re: trigger functions broken?

From: "Robert Haas" <robertmhaas(at)gmail(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Pg Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: trigger functions broken?
Date: 2008-10-08 18:38:00
Message-ID: 603c8f070810081138s427edfd8n72679d45d701a64c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I get the same thing on 8.2.9.

...Robert

On Wed, Oct 8, 2008 at 2:29 PM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com> wrote:
> Hi,
>
> Trigger functions are supposed to be able to be called only as triggers,
> but apparently the check is not working in CVS HEAD:
>
> alvherre=# create or replace function foo () returns trigger as $$ begin perform 1; return new; end; $$ language plpgsql;
> CREATE FUNCTION
> alvherre=# select foo();
> foo
> -----
>
> (1 fila)
>
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message A. Kretschmer 2008-10-08 18:56:11 Re: trigger functions broken?
Previous Message Alvaro Herrera 2008-10-08 18:29:23 trigger functions broken?