Re: Query on exception handling in PL/pgSQL - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Query on exception handling in PL/pgSQL
Date
Msg-id 20041127162716.GC21842@dcc.uchile.cl
Whole thread Raw
In response to Re: Query on exception handling in PL/pgSQL  (Victor Ciurus <vikcious@gmail.com>)
List pgsql-general
On Sat, Nov 27, 2004 at 11:37:34AM +0200, Victor Ciurus wrote:
> And how does exactly PG8.0 help us with this?

You can use BEGIN ... EXCEPTION ... END blocks.  It doesn't help you
with COPY/IGNORE ON DUPLICATES though.

> Tom, coould you be so kind and tell me/us when will PG incorporate
> such a hugely claimed feature like "copy table_x from 'file_y.txt'
> (using delimiters) IGNORE ON DUPLICATES"?

I think the canonical answer is "when somebody implements it".  _If_
she happens to convince the committers that it is a good idea to do
it her way.

If you desperately need that feature, you could code it yourself of
convince some hacker to do it for you (possibly paying but maybe not).

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Tiene valor aquel que admite que es un cobarde" (Fernandel)

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: row-level deadlock problem
Next
From: Fabien Fournier
Date:
Subject: Boolean error