From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc:
Lee Kindness <lkindness(at)csl(dot)co(dot)uk>, Peter Eisentraut <peter_e(at)gmx(dot)net>,
Jim Buttafuoco <jim(at)buttafuoco(dot)net>,
PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Bulkloading using COPY - ignore duplicates?
Date:
2002-01-03 20:35:31
Message-ID:
15540.1010090131@sss.pgh.pa.us (view raw or flat )
Thread:
2001-12-16 14:12:14 from "Jim Buttafuoco" <jim(at)buttafuoco(dot)net>
2001-12-16 22:24:04 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2001-12-17 12:43:45 from Lee Kindness <lkindness(at)csl(dot)co(dot)uk>
2001-12-17 12:48:30 from Lee Kindness <lkindness(at)csl(dot)co(dot)uk>
2001-12-17 20:59:01 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2001-12-18 10:09:14 from Lee Kindness <lkindness(at)csl(dot)co(dot)uk>
2001-12-18 15:04:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-12-18 15:51:50 from Lee Kindness <lkindness(at)csl(dot)co(dot)uk>
2001-12-18 15:59:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-12-18 16:04:13 from Lee Kindness <lkindness(at)csl(dot)co(dot)uk>
2002-01-02 21:09:36 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-02 21:49:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-02 22:02:26 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-02 22:18:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-02 23:40:20 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-03 00:05:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-03 03:24:26 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-03 18:24:26 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-03 20:35:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-03 20:42:05 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Lists:
pgsql-hackers
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Seems nested transactions are not required if we load each COPY line in
> its own transaction, like we do with INSERT from pg_dump.
I don't think that's an acceptable answer. Consider
BEGIN;
other stuff;
COPY ....;
other stuff;
ROLLBACK;
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Bruce MomjianDate: 2002-01-03 20:42:05Subject : Re: Bulkloading using COPY - ignore duplicates?Previous :From : Adam HaberlachDate : 2002-01-03 20:32:44Subject : Re: SET DATESTYLE to time_t style for client libraries?
