Re: pg_dump and backslash escapes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump and backslash escapes
Date
Msg-id 19773.1147876284@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump and backslash escapes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: pg_dump and backslash escapes
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> The basic issue is that we need to set standard_conforming_strings to
> 'off' for loading into newer releases, >= 8.2, but that SET command is
> going to generate an error even dumping/loading into the same version of
> PostgreSQL, like 7.3 to 7.3.  I don't think we want that, do we?

Why are you worried?  Have you counted how many SETs there are currently
that will generate errors in older versions of PG?  As long as the older
backend will load the data correctly after rejecting the SET, there's no
functional problem, and I think trying to hide the error is a cosmetic
thing that will likely do more harm than good in the long run.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Return results for PQexec vs PQexecP*
Next
From: "William ZHANG"
Date:
Subject: Re: PL/pgSQL 'i = i + 1' Syntax