Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group