Re: COPY enhancements - Mailing list pgsql-hackers

From Emmanuel Cecchet
Subject Re: COPY enhancements
Date
Msg-id 4ABC3253.6010407@asterdata.com
Whole thread Raw
In response to Re: COPY enhancements  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Yes, I have to update the patch following what Tom already integrated of 
the COPY patch.
I will get a new version posted as soon as I can.

Emmanuel

Robert Haas wrote:
> On Fri, Sep 18, 2009 at 12:14 AM, Emmanuel Cecchet <manu@asterdata.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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: COPY enhancements
Next
From: Robert Haas
Date:
Subject: Re: WIP - syslogger infrastructure changes