Re: [HACKERS] PostgreSQL 8.2beta1 w/ VALUES

2006-09-30 Thread Tom Lane
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

Re: [HACKERS] PostgreSQL 8.2beta1 w/ VALUES

2006-09-30 Thread Luke Lonergan
: 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-anonymized.postgres.sql:262: WARNING

Re: [HACKERS] PostgreSQL 8.2beta1 w/ VALUES

2006-09-24 Thread Stephen Frost
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. :) If it's

Re: [HACKERS] PostgreSQL 8.2beta1 w/ VALUES

2006-09-24 Thread Markus Schaber
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

Re: [HACKERS] PostgreSQL 8.2beta1 w/ VALUES

2006-09-24 Thread Tom Lane
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: if

[HACKERS] PostgreSQL 8.2beta1 w/ VALUES

2006-09-23 Thread Stephen Frost
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:

Re: [HACKERS] PostgreSQL 8.2beta1 w/ VALUES

2006-09-23 Thread Joshua D. Drake
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

Re: [HACKERS] PostgreSQL 8.2beta1 w/ VALUES

2006-09-23 Thread Luke Lonergan
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