Re: Bulkloading using COPY - ignore duplicates?

From: Justin Clift <justin(at)postgresql(dot)org>
To: Lee Kindness <lkindness(at)csl(dot)co(dot)uk>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Bulkloading using COPY - ignore duplicates?
Date: 2001-10-01 11:40:41
Message-ID: 3BB85639.DC51F286@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Lee Kindness wrote:
>
<snip>
>
> WITH ON_DUPLICATE = CONTINUE|TERMINATE (or similar)

I would suggest :

WITH ON_DUPLICATE = IGNORE|TERMINATE

Or maybe IGNORE_DUPLICATE

purely for easier understanding, given there is no present standard nor
other databases' syntax to conform to.

:)

Regards and best wishes,

Justin Clift

>
> need to be added to the COPY command (I hope not)?
>
> Thanks,
>
> --
> Lee Kindness, Senior Software Engineer
> Concept Systems Limited.

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stefan Rindeskar 2001-10-01 12:12:29 Re: Moving CVS files around?
Previous Message Haller Christoph 2001-10-01 11:24:11 What executes faster?