Thread: about raise exception

about raise exception

From
"Jack"
Date:
According to user guide, both Raise Notice & Raise Exception will write
message to database log. Which system table is the database log about?

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


Jack



Re: about raise exception

From
Stephan Szabo
Date:
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).




Re: about raise exception

From
Jie Liang
Date:

Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.stbernard.com
www.ipinc.com

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?

I believe it means write a message to your log file such as /.../pgsql.log

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

raise notice does not terminate program but raise exception does.

> 
> Jack
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>