Re: constraint triggers - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: constraint triggers
Date
Msg-id 4E82EC4A020000250004183A@gw.wicourts.gov
Whole thread Raw
In response to Re: constraint triggers  (Gilberto Castillo Martínez<gilberto.castillo@etecsa.cu>)
List pgsql-admin
Gilberto Castillo Martínez<gilberto.castillo@etecsa.cu> wrote:

>> CREATE OR REPLACE FUNCTION increment_dataset_granule_count()

>>         RETURN NULL;

> Replace RETURN NULL for RETURN NEW

That won't matter for an AFTER trigger:

http://www.postgresql.org/docs/9.0/interactive/trigger-definition.html

says:

| The return value is ignored for row-level triggers fired after an
| operation, and so they can return NULL.

-Kevin

pgsql-admin by date:

Previous
From: Gilberto Castillo Martínez
Date:
Subject: Re: constraint triggers
Next
From: Kasia Tuszynska
Date:
Subject: Re: Postgres 9 on 64 bit