From: | ritchie turner <ritchie(at)ipowerhouse(dot)com> |
---|---|
To: | Kris Jurka <books(at)ejurka(dot)com> |
Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: COPY support |
Date: | 2003-11-19 10:13:51 |
Message-ID: | 200311190513.52157.ritchie@ipowerhouse.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Thanks for the info Kris, I suspected that may be the case.
Cheers
Ritchie
On Monday 17 November 2003 23:25, Kris Jurka wrote:
> On Mon, 17 Nov 2003, ritchie turner wrote:
> > I'm trying to optimise some sql inserts I have by using the COPY command
> > instead. I'm connecting from Java using 7.4 beta 3. It works at the
> > command line, but I can't get it to work from Java. I'm doing an
> > executeUpdate() on the COPY string below in the hope it works, but ....
>
> COPY requires special protocol level support so this won't work.
>
> > I see there was some traffic on this list regard special copy support in
> > the driver, did it make it in? Can't see it.
>
> In February of last year Michael Adler made a patch to support copy, but
> it was rejected because the copy protocol was broken and a bad copy would
> completely hose your Connection. With the new V3 protocol in 7.4 it makes
> copy errors recoverable so it can be implemented safely. It's on my todo
> list to update his patch for the current driver, but I haven't gotten to
> it.
>
> Kris Jurka
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | Anderson dos Santos | 2003-11-19 12:41:48 | postgreSql anderson |
Previous Message | Kris Jurka | 2003-11-19 00:45:37 | Re: Build problems for PostgreSQL v7.4 on FreeBSD v4.1 |