Re: COPY enhancements - Mailing list pgsql-hackers

From Tom Lane
Subject Re: COPY enhancements
Date
Msg-id 9615.1252622076@sss.pgh.pa.us
Whole thread Raw
In response to Re: COPY enhancements  (Josh Berkus <josh@agliodbs.com>)
Responses Re: COPY enhancements
Re: COPY enhancements
Re: COPY enhancements
Re: COPY enhancements
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> Yes, and GUCs allow users to retrofit this approach onto existing
> infrastructure without changing their COPY commands.  So there's
> advantages and disadvantages.  My question was really for the -hackers
> at large: is this the design we want?  Or, more directly, is the GUC
> approach anathema to anyone?

Half a dozen interrelated GUCs to control a single command fairly
screams "bad design" to me; especially the ones that specifically bear
on the command semantics, rather than being performance settings that
you could reasonably have system-wide defaults for.  Could we please
look at doing it via COPY options instead?

It might be time to switch COPY over to a more easily extensible
option syntax, such as we just adopted for EXPLAIN.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: COPY enhancements
Next
From: David Fetter
Date:
Subject: Re: COPY enhancements