Thread: about raise exception

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

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).

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)
>