Re: Copy From & Insert UNLESS

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Copy From & Insert UNLESS
Date: 2006-02-05 21:16:15
Message-ID: 43E66B1F.60707@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Folks,

> The subject of this letter is referring to giving INSERT and COPY FROM STDIN
> the ability to alter the destination of rows that violate any constraints named
> in a user specified set.

BTW, just in case anyone thinks that James is not addressing a real and
widespread problem, Joe Conway said in his presentation on Symer's 1.2
TB databases that the single most painful thing they had to deal with in
the implementation is filtering out bad rows before COPY (from OSCON2005
presentation).

--Josh

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message August Zajonc 2006-02-05 21:49:56 Re: New project launched : PostgreSQL GUI Installer for Linux/Unix
Previous Message Josh Berkus 2006-02-05 21:13:31 Re: Copy From & Insert UNLESS