PostgreSQL 8.2beta1 w/ VALUES

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: PostgreSQL 8.2beta1 w/ VALUES
Date: 2006-09-24 01:44:09
Message-ID: 20060924014409.GF24675@kenobi.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greetings,

Was just playing with 8.2beta1 and importing some data from MySQL and
found something rather annoying. Not *100%* sure the best way to deal
with this, if there even is a way, but...

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: ...XXXXXXXXXX 9999,9:9:999'),(99999,'000000000000',0,'XXXXX XXX...
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
psql:/home/sfrost/school/cs750/reality/dump-anonymized.postgres.sql:262:
WARNING: nonstandard use of escape in a string literal
LINE 1: ...9999999999',0,',9:9:999'),(99999,'000000000000',0,'XXXX XXXX...
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
INSERT 0 20795
cs750=#

Which, by themselves, aren't really an issue *except* for the fact
that I got an *insane* number of them. I don't think it was quite one
for every row (of which there were 20,795, you'll note) but it was
more than enough to drive me insane. Additionally, cancel requests
were ignored. It's possible this was because of network lag and the
server had already processed the request but I'm not sure that was the
only reason. I know I held down ctrl-c for quite a while during the
spew of messages...

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
respond to cancel requests (if there was an issue there). Sorry this
is more from a user's perspective, I havn't got time atm to go digging
through the code. I'd be curious about implementing a possible
error-aggregation system for reporting on large sets like this but
that might be overkill anyway.

Thanks,

Stephen

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-09-24 02:00:36 Re: ReadBuffer(P_NEW) versus valid buffers
Previous Message Bruce Momjian 2006-09-24 01:23:01 Re: PostgreSQL 8.2beta1 Now Available