Re: Bulkloading using COPY - ignore duplicates?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Jim Buttafuoco <jim(at)buttafuoco(dot)net>
Cc: Lee Kindness <lkindness(at)csl(dot)co(dot)uk>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bulkloading using COPY - ignore duplicates?
Date: 2001-12-16 22:24:04
Message-ID: Pine.LNX.4.30.0112161731350.641-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jim Buttafuoco writes:

> I agree with Lee, I also like Oracle's options for a discard file, so
> you can look at what was rejected, fix your problem and reload if
> necessary just the rejects.

How do you know which one is the duplicate and which one is the good one?
More likely you will have to fix the entire thing. Anything else would
undermine the general data model except in specific use cases.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message mlw 2001-12-16 22:37:13 Re: Explicit config patch 7.2B4
Previous Message Peter Eisentraut 2001-12-16 22:23:56 Re: [PATCHES] system catalog relation of a table and a