Re: Good Books

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: postgresql(at)bryden(dot)co(dot)za
Cc: Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-general(at)postgresql(dot)org
Subject: Re: Good Books
Date: 2005-03-24 14:13:10
Message-ID: 20050324141310.GK20726@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 24, 2005 at 03:41:06PM +0200, postgresql(at)bryden(dot)co(dot)za wrote:

Craig,

> There are a lot of the topics that I feel could have better (or more
> comprehensive examples). In particular I am thinking of plpgsql. One
> example is information about working with Exceptions (postgresql specific)
> and another is the small amount of info about the RAISE Statement.
>
> Refering to my mention of exceptions above, the following is information
> that I could not find in the standard docs:
> How to use(Return using RAISE) the actual exception code and message once
> you have handled the error. This is especially usefull if you have used
> WHEN OTHERS to catch the error.

No book will tell you how to do that, because the EXCEPTION support in
plpgsql is new as of Postgres 8.0, and some things are not there yet.

If the documentation doesn't say how to do it, then maybe there is no
way. You'd need to convince a hacker that it's a useful feature so they
can add it.

--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"I personally became interested in Linux while I was dating an English major
who wouldn't know an operating system if it walked up and bit him."
(Val Henson)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wolfgang Drotschmann 2005-03-24 14:18:56 How to retrieve the comment for a constraint?
Previous Message Sven Willenberger 2005-03-24 14:10:36 Re: plperl doesn't release memory