Re: COPY enhancements

Robert,

Here is the new version of the patch that applies to CVS HEAD as of this
morning.

Emmanuel

> On Fri, Sep 18, 2009 at 12:14 AM, Emmanuel Cecchet <manu(at)asterdata(dot)com> wrote:
>
>> Here is a new version of error logging and autopartitioning in COPY based on
>> the latest COPY patch that provides the new syntax for copy options (this
>> patch also includes the COPY option patch).
>>
>> New features compared to previous version:
>> - removed the GUC variables for error logging and use copy options instead
>> (renamed options as suggested by Josh)
>> - added documentation and examples (see copy.sgml)
>> - partitioning also activated by copy option rather than GUC variable
>> (renamed as well)
>> - added a new ERROR_LOGGING_MAX_ERRORS option that allows to abort the COPY
>> operation if a certain number of bad rows has been encountered.
>> - updated unit tests
>>
>> I also tried to update the wiki pages but it's late and the doc is probably
>> better for now.
>>
>> This addresses most of the comments so far except for the format of the
>> error table (lack of natural key) and a possible pg_error_table as a default
>> name.
>>
>> Emmanuel
>>
>> Emmanuel Cecchet wrote:
>>
>>> Hi all,
>>>
>>> Finally the error logging and autopartitioning patches for COPY that I
>>> presented at PGCon are here!
>>> Error logging is described here:
>>> http://wiki.postgresql.org/wiki/Error_logging_in_COPY
>>> Autopartitioning is described here:
>>> http://wiki.postgresql.org/wiki/Auto-partitioning_in_COPY
>>>
>>> The attached patch contains both contribs as well as unit tests. I will
>>> submit shortly the new patch at commitfest.postgresql.org.
>>>
>>> Thanks in advance for your feedback,
>>> Emmanuel
>>>
>
> This no longer applies.
>
> ...Robert
>

--
Emmanuel Cecchet
Aster Data Systems
Web: http://www.asterdata.com