[Postgres-xl-general] Passing Through Error Messages On COPY

Nikhil Sontakke nikhils at translattice.com
Thu Oct 16 05:43:02 PDT 2014


FYI Aaron,

I have committed a fix for this COPY issue today.

Regards,
Nikhils


On Fri, Jul 25, 2014 at 1:58 AM, Mason Sharp <msharp at translattice.com>
wrote:

>
>
>
> On Thu, Jul 24, 2014 at 1:32 PM, Aaron Jackson <ajackson at revionics.com>
> wrote:
>
>>    Would it be possible to get errors to be passed through on COPY
>> routines.  I ran a COPY today to populate a table and it failed with the
>> message "Error while running COPY".  So I scanned through the datanode logs
>> to see if there was a better message and there was.  It was a foreign key
>> constraint violation.
>> *Aaron*
>>
> Yes, that is a bit inconvenient. :-)
>
> We had previously filed a bug for this:
>
> http://sourceforge.net/p/postgres-xl/tickets/4/
>
> IIRC, if we allow a detailed error message, there was a side effect for
> potential resource leakage, where we need to do some additional cleanup
> first.
>
> Perhaps we can bump up the priority on this one.
>
>
>
> --
> Mason Sharp
>
> TransLattice - http://www.translattice.com
> Distributed and Clustered Database Solutions
>
>
>
>
> ------------------------------------------------------------------------------
> Want fast and easy access to all the code in your enterprise? Index and
> search up to 200,000 lines of code with a free copy of Black Duck
> Code Sight - the same software that powers the world's largest code
> search on Ohloh, the Black Duck Open Hub! Try it now.
> http://p.sf.net/sfu/bds
> _______________________________________________
> Postgres-xl-general mailing list
> Postgres-xl-general at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/postgres-xl-general
>
>


-- 
TransLattice - http://www.translattice.com
Distributed and Clustered Database Solutions
Postgres-XL Support
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20141016/a8a616d0/attachment.htm>


More information about the postgres-xl-general mailing list