Re: Allow COPY from STDIN to absorb all input before throwing an error

From: Neil Conway <neilc(at)samurai(dot)com>
To: Decibel! <decibel(at)decibel(dot)org>
Cc: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Allow COPY from STDIN to absorb all input before throwing an error
Date: 2008-04-08 20:50:20
Message-ID: 1207687820.6942.13.camel@goldbach
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 2008-04-08 at 15:26 -0500, Decibel! wrote:
> My idea to avoid this situation is to add an option to COPY that
> tells it not to throw an error until it runs out of input data.

An alternative would be to have the client continue reading (and
discarding) COPY input until the end-of-COPY-input sequence is reached,
and then switch back into normal input processing mode.

-Neil

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-04-08 21:10:56 Concurrent psql API
Previous Message Andrew Chernow 2008-04-08 20:49:52 Re: [PATCHES] libpq type system 0.9a