Re: about raise exception

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Jack <ycc(at)bigfoot(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: about raise exception
Date: 2001-03-26 03:40:32
Message-ID: Pine.BSF.4.21.0103251938470.57501-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Mon, 26 Mar 2001, Jack wrote:

> According to user guide, both Raise Notice & Raise Exception will write
> message to database log. Which system table is the database log about?

It's actually generally on either STDERR or sent to syslog depending
on configuration.

> By the way what is the difference between Raise Notice & Raise Exception?

Raising an exception means that an error has occurred and will force
rollback (just like normal error condition).

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jie Liang 2001-03-26 03:53:44 Re: About Raise Exception
Previous Message Stephan Szabo 2001-03-26 03:38:12 Re: Hi there, having problems with the following: