Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwAk2-0005GS-Ot for pgsql-admin@arkaria.postgresql.org; Mon, 08 Jul 2013 12:40:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UwAk2-0003QT-4C for pgsql-admin@arkaria.postgresql.org; Mon, 08 Jul 2013 12:40:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwAk0-0003P5-VC for pgsql-admin@postgresql.org; Mon, 08 Jul 2013 12:40:29 +0000 Received: from dub0-omc1-s25.dub0.hotmail.com ([157.55.0.224]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwAju-0005yW-Mt for pgsql-admin@postgresql.org; Mon, 08 Jul 2013 12:40:28 +0000 Received: from DUB118-W13 ([157.55.0.239]) by dub0-omc1-s25.dub0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Mon, 8 Jul 2013 05:40:20 -0700 X-TMN: [3z49Q9jBp9WkaNHUf5oMCArUO+wzJWSv] X-Originating-Email: [colin_sloss@hotmail.com] Message-ID: Content-Type: multipart/alternative; boundary="_de74f92d-bbac-4a63-a614-4dd6bcf3c54e_" From: Colin S To: "pgsql-admin@postgresql.org" Subject: search_path update weirdness Date: Mon, 8 Jul 2013 12:40:20 +0000 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 08 Jul 2013 12:40:20.0582 (UTC) FILETIME=[4ED16060:01CE7BD8] X-Pg-Spam-Score: -0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_de74f92d-bbac-4a63-a614-4dd6bcf3c54e_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello=2C I made a bad update to search_path=2C which basically had line returns: prod_candidate=3D# alter user postgres set search_path to 'search_path=3Dpu= blic=2C schemprod_candidate'# a1=2C schema2=2C schema3'prod_candidate-# =3B= ALTER ROLE And now=2C I can't get it to insert correctly again=2C there always seems t= o be some backslashes stuck in there: prod_candidate=3D# alter user postgres set search_path to ''=3BALTER ROLEpr= od_candidate=3D# select usename=2C useconfig from pg_user=3B usename = | useconfig ----------------+------------= -------------------------------- postgres | {"search_path=3D\"\""} us= er2 | {"search_path=3Dpublic=2C schema1=2C schema2=2C schema3"} user3 = | {"search_path=3Dpublic=2C schema1=2C schema2=2C schema3"}(3 rows) prod_candidate=3D# alter user postgres set search_path to 'operator=2C game= play=2C common'=3BALTER ROLEprod_candidate=3D# select usename=2C useconfig = from pg_user=3B usename | useconfig = ----------------+------------------------------------------------ post= gres | {"search_path=3D\"public=2C schema1=2C schema2=2C schema3\""} = user2 | {"search_path=3Dpublic=2C schema1=2C schema2=2C schema3"} user3 = | {"search_path=3Dpublic=2C schema1=2C schema2=2C schema3"}(3 rows) Regards=2C Colin = --_de74f92d-bbac-4a63-a614-4dd6bcf3c54e_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello=2C

I made a bad update to search_path=2C which basically had line retur= ns:

prod_candidate=3D# alter user postgres se= t search_path to 'search_path=3Dpublic=2C schem
prod_candidate'# = a1=2C schema2=2C schema3'
prod_candidate-# =3B
ALTER RO= LE


And now=2C I can't get it = to insert correctly again=2C there always seems to be some backslashes stuc= k in there:


prod_candidate=3D#= alter user postgres set search_path to ''=3B
ALTER ROLE
prod_candidate=3D# select usename=2C useconfig from pg_user=3B
=  =3B  =3B usename  =3B  =3B |  =3B  =3B  =3B &n= bsp=3B  =3B  =3B  =3B  =3B useconfig  =3B  =3B &nbs= p=3B  =3B  =3B  =3B  =3B  =3B  =3B
------= ----------+--------------------------------------------
 =3Bp= ostgres  =3B  =3B  =3B | {"search_path=3D\"\""}
 = =3Buser2 | {"search_path=3Dpublic=2C schema1=2C schema2=2C schema3"}
<= div> =3Buser3  =3B  =3B  =3B | {"search_path=3Dpublic=2C sc= hema1=2C schema2=2C schema3"}
(3 rows)

p= rod_candidate=3D# alter user postgres set search_path to 'operator=2C gamep= lay=2C common'=3B
ALTER ROLE
prod_candidate=3D# select = usename=2C useconfig from pg_user=3B
 =3B  =3B usename &n= bsp=3B  =3B |  =3B  =3B  =3B  =3B  =3B  =3B &nb= sp=3B  =3B  =3B useconfig  =3B  =3B  =3B  =3B  = =3B  =3B  =3B  =3B  =3B  =3B
----------------= +------------------------------------------------
 =3Bpostgre= s  =3B  =3B  =3B | {"search_path=3D\"public=2C schema1=2C schem= a2=2C schema3\""}
 =3Buser2 | {"search_path=3Dpublic=2C schem= a1=2C schema2=2C schema3"}
 =3Buser3  =3B  =3B  = =3B | {"search_path=3Dpublic=2C schema1=2C schema2=2C schema3"}
(= 3 rows)

Regards=2C

= Colin
= --_de74f92d-bbac-4a63-a614-4dd6bcf3c54e_--