Re: Can trigger procedures return value

From: nolan(at)celery(dot)tssi(dot)com
To: kdeepa(at)midascomm(dot)com (Deepa K)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can trigger procedures return value
Date: 2003-07-29 10:48:10
Message-ID: 20030729104810.21932.qmail@celery.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Jung 2003-07-29 10:48:35 Re: concurrent writes
Previous Message Shridhar Daithankar 2003-07-29 10:42:24 Re: concurrent writes