pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
about raise exception
5+ messages / 4 participants
[nested] [flat]

* about raise exception
@ 2001-03-26 00:10 Jack <ycc@bigfoot.com>
  2001-03-26 03:40 ` Re: about raise exception Stephan Szabo <sszabo@megazone23.bigpanda.com>
  2001-03-26 04:03 ` Re: about raise exception Jie Liang <jliang@ipinc.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

* Re: about raise exception
  2001-03-26 00:10 about raise exception Jack <ycc@bigfoot.com>
@ 2001-03-26 03:40 ` Stephan Szabo <sszabo@megazone23.bigpanda.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 00:10 about raise exception Jack <ycc@bigfoot.com>
@ 2001-03-26 04:03 ` Jie Liang <jliang@ipinc.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

* About Raise Exception
@ 2001-03-26 00:25 datactrl <quals@bigfoot.com>
  2001-03-26 03:53 ` Re: About Raise Exception Jie Liang <jliang@ipinc.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 00:25 About Raise Exception datactrl <quals@bigfoot.com>
@ 2001-03-26 03:53 ` Jie Liang <jliang@ipinc.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


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