Re: pg_restore direct to database is broken for --insert dumps

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgreSQL.org
Date: 2012-01-04T23:59:17Z
Lists: pgsql-hackers

On 01/04/2012 06:20 PM, Tom Lane wrote:
> But we'd have to deal with
> standard-conforming strings some way.  The idea I had about that, since
> we have an open database connection at hand, is to check the connected
> backend's standard_conforming_strings state via PQparameterStatus.  If
> it doesn't have the right setting then things are going to fail anyway.
>

Do we care what it is? Or can we just issue a SET to make it what it 
needs to be?

cheers

andrew