Postgres Pro
Downloads
Home   >   mailing lists

Raise exception from regular SQL? - Mailing list pgsql-general

From Steve - DND
Subject Raise exception from regular SQL?
Date
Msg-id LDEHKBBOEMIJKHKBOFNFEEPJNFAA.postgres@digitalnothing.com
Whole thread Raw
List pgsql-general
Tree view 
I'm trying to add some clarity to the rules I have on my tables. When a rule
is broken, I want to give a more informative message, so that the client
side can deal with it in a nicer manner. Right now I'm creating plpgsql
functions, and raising an exception in there with the customized text.

Is there a way to raise exceptions with regular SQL so that I don't have to
go to plpgsql?

Thanks,
Steve

pgsql-general by date:

Previous
From: Thomas Hallgren
Date:
Subject: Functions returning RECORD
Next
From: "Raymond O'Donnell"
Date:
Subject: (Fwd) Re: windows, cant find ostgresql.conf