Re: PostgreSQL 8.2beta1 w/ VALUES

From: "Luke Lonergan" <LLonergan(at)greenplum(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.2beta1 w/ VALUES
Date: 2006-09-24 04:11:03
Message-ID: 3E37B936B592014B978C4415F90D662D0476E89B@MI8NYCMAIL06.Mi8.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh,

> > Anyhow, don't know if there's really a good solution but
> it'd be nice
> > to only get one warning, or one of a given type, or
> something, and
> > to
>
> Except that one warning would not be accurate, because the
> warning is per tuple. How is postgresql going to know that
> the warning applies to the same set of data but just a
> different tuple?

If it's going to roll back the entire load after that one warning, it
should terminate there.

This is a common problem with OLAP and based on the observation here,
this needs to be fixed. Not being able to cancel out at this point is
even worse, can you imagine the frustration of trying to load 10GB of
data and having to wait until the end after seeing these warnings, while
knowing that you're just going to have to try again anyway?

Eventually we'll implement single row error handling, but even then
there should be a selectable behavior to terminate the load on the first
warning/error.

- Luke

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2006-09-24 04:26:55 Re: ReadBuffer(P_NEW) versus valid buffers
Previous Message Joshua D. Drake 2006-09-24 03:34:32 Re: PostgreSQL 8.2beta1 Now Available