Re: Can trigger procedures return value - Mailing list pgsql-general

From nolan@celery.tssi.com
Subject Re: Can trigger procedures return value
Date
Msg-id 20030729104810.21932.qmail@celery.tssi.com
Whole thread Raw
In response to Can trigger procedures return value  (Deepa K <kdeepa@midascomm.com>)
List pgsql-general
>  If it is not possible to return error from
>  trigger procedure, what could be the possible
>  way to solve the above problem.

What you want is 'raise exception', which allows you to return an
error message explaining things.

Use something like "RAISE EXCEPTION ''You are not authorized to
update this information'';"
--
Mike Nolan

pgsql-general by date:

Previous
From: Andreas Jung
Date:
Subject: Re: concurrent writes
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: concurrent writes