pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedabout raise exception
5+ messages / 4 participants
[nested] [flat]
* about raise exception
@ 2001-03-26 00:10 Jack <ycc@bigfoot.com>
0 siblings, 2 replies; 5+ messages in thread
From: Jack @ 2001-03-26 00:10 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* About Raise Exception
@ 2001-03-26 00:25 datactrl <quals@bigfoot.com>
0 siblings, 1 reply; 5+ messages in thread
From: datactrl @ 2001-03-26 00:25 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: about raise exception
@ 2001-03-26 03:40 Stephan Szabo <sszabo@megazone23.bigpanda.com>
parent: Jack <ycc@bigfoot.com>
1 sibling, 0 replies; 5+ messages in thread
From: Stephan Szabo @ 2001-03-26 03:40 UTC (permalink / raw)
To: Jack <ycc@bigfoot.com>; +Cc: 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).
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: About Raise Exception
@ 2001-03-26 03:53 Jie Liang <jliang@ipinc.com>
parent: datactrl <quals@bigfoot.com>
0 siblings, 0 replies; 5+ messages in thread
From: Jie Liang @ 2001-03-26 03:53 UTC (permalink / raw)
To: datactrl <quals@bigfoot.com>; +Cc: pgsql-sql
At least
raise exception will abort the transaction but
raise notice does not.
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, datactrl wrote:
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: about raise exception
@ 2001-03-26 04:03 Jie Liang <jliang@ipinc.com>
parent: Jack <ycc@bigfoot.com>
1 sibling, 0 replies; 5+ messages in thread
From: Jie Liang @ 2001-03-26 04:03 UTC (permalink / raw)
To: Jack <ycc@bigfoot.com>; +Cc: pgsql-sql
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)
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-03-26 04:03 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-26 00:10 about raise exception Jack <ycc@bigfoot.com>
2001-03-26 03:40 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-03-26 04:03 ` Jie Liang <jliang@ipinc.com>
2001-03-26 00:25 About Raise Exception datactrl <quals@bigfoot.com>
2001-03-26 03:53 ` Re: About Raise Exception Jie Liang <jliang@ipinc.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox