Re: Query on exception handling in PL/pgSQL

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Query on exception handling in PL/pgSQL
Дата
Msg-id 20041127162716.GC21842@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: Query on exception handling in PL/pgSQL  (Victor Ciurus <vikcious@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: row-level deadlock problem
Следующее
От: Fabien Fournier
Дата:
Сообщение: Boolean error