st
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] PostgreSQL 8.2beta1 w/ VALUES
Stephen Frost <[EMAIL PROTECTED]> writes:
> When loading a rather large data set I started getting errors along
> these lines:
> psql:/home/sfrost/school/cs750/reality/dump-anonymi
Stephen Frost <[EMAIL PROTECTED]> writes:
> When loading a rather large data set I started getting errors along
> these lines:
> psql:/home/sfrost/school/cs750/reality/dump-anonymized.postgres.sql:262:
> WARNING: nonstandard use of escape in a string literal
> LINE 1: ...XX ,9:9:99
"Luke Lonergan" <[EMAIL PROTECTED]> writes:
> If it's going to roll back the entire load after that one warning, it
> should terminate there.
This was a warning, not an error.
regards, tom lane
---(end of broadcast)---
TIP 1
Hi, Luke,
Luke Lonergan wrote:
> If it's going to roll back the entire load after that one warning, it
> should terminate there.
AFAIK, a warning is no reason for PostgreSQL to roll back anything.
That's the difference between a warning and an error.
HTH,
Markus
--
Markus Schaber | Logical T
Luke, et al,
* Luke Lonergan ([EMAIL PROTECTED]) wrote:
> > 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?
I didn't say it'd be easy. :)
>
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
>
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 sam