Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwB0M-0006T8-Sl for pgsql-admin@arkaria.postgresql.org; Mon, 08 Jul 2013 12:57:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UwB0M-00043I-9v for pgsql-admin@arkaria.postgresql.org; Mon, 08 Jul 2013 12:57:22 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwB0L-00042B-4U for pgsql-admin@postgresql.org; Mon, 08 Jul 2013 12:57:21 +0000 Received: from dub0-omc2-s3.dub0.hotmail.com ([157.55.1.142]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwB0I-0004nB-BJ for pgsql-admin@postgresql.org; Mon, 08 Jul 2013 12:57:20 +0000 Received: from DUB118-W16 ([157.55.1.137]) by dub0-omc2-s3.dub0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Mon, 8 Jul 2013 05:57:16 -0700 X-TMN: [J6Fz8VcGeeAIPKgrfdbQCMzz5ag/gYOg] X-Originating-Email: [colin_sloss@hotmail.com] Message-ID: Content-Type: multipart/alternative; boundary="_cdd8ffe1-3cc2-40f9-b0f9-4d2c4762976a_" From: Colin S To: Szymon Guz CC: "pgsql-admin@postgresql.org" Subject: Re: search_path update weirdness Date: Mon, 8 Jul 2013 12:57:16 +0000 Importance: Normal In-Reply-To: References: , MIME-Version: 1.0 X-OriginalArrivalTime: 08 Jul 2013 12:57:16.0518 (UTC) FILETIME=[AC5CE860:01CE7BDA] X-Pg-Spam-Score: 0.5 (/) 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 --_cdd8ffe1-3cc2-40f9-b0f9-4d2c4762976a_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Date: Mon=2C 8 Jul 2013 14:46:29 +0200 Subject: Re: [ADMIN] search_path update weirdness From: mabewlun@gmail.com To: colin_sloss@hotmail.com CC: pgsql-admin@postgresql.org Hi szymon=2C My mistake. I chock it up to another manic monday. Thanks! Colin On 8 July 2013 14:40=2C Colin S wrote: =0A= =0A= =0A= =0A= 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 schem=0A= prod_candidate'# a1=2C schema2=2C schema3'prod_candidate-# =3BALTER 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:=0A= 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 =0A= ----------------+-------------------------------------------- postgres = | {"search_path=3D\"\""} user2 | {"search_path=3Dpublic=2C schema1=2C sch= ema2=2C schema3"}=0A= 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'=3B=0A= ALTER ROLEprod_candidate=3D# select usename=2C useconfig from pg_user=3B = usename | useconfig -------------= ---+------------------------------------------------=0A= postgres | {"search_path=3D\"public=2C schema1=2C schema2=2C schema3= \""} user2 | {"search_path=3Dpublic=2C schema1=2C schema2=2C schema3"} user= 3 | {"search_path=3Dpublic=2C schema1=2C schema2=2C schema3"}=0A= (3 rows) Regards=2C Colin =0A= Hi Colin=2Cyou should rather set the path with: alter user postgres set search_path =3D public=2C schema1=2C schema2=2C sch= ema3=3B =0A= szymon = --_cdd8ffe1-3cc2-40f9-b0f9-4d2c4762976a_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable


Date: Mon=2C 8 Jul 2013 14:46:29 +0200
Subject: Re: [ADMIN] search_= path update weirdness
From: mabewlun@gmail.com
To: colin_sloss@hotmai= l.com
CC: pgsql-admin@postgresql.org


Hi szymon=2C

=
My mistake. I chock it up to another ma= nic monday.

Thanks!

Colin

On 8 July 20= 13 14:40=2C Colin S <=3Bcolin_sloss@hotmail.com>=3B wrot= e:
=0A=
=0A= =0A= =0A=
Hello=2C

I made a bad u= pdate to search_path=2C which basically had line returns:

prod_candidate=3D# alter user postgres set search_path to 'sea= rch_path=3Dpublic=2C schem
=0A=
prod_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 to be= some backslashes stuck in there:
=0A=


prod_candidate=3D# alter user postg= res 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  =3B  = =3B  =3B  =3B  =3B useconfig  =3B  =3B  =3B  = =3B  =3B  =3B  =3B  =3B  =3B
=0A=
----------------+--------------------------------------------
 =3Bpostgres  =3B  =3B  =3B | {"search_path=3D\"\""}
 =3Buser2 | {"search_path=3Dpublic=2C schema1=2C schema2=2C schem= a3"}
=0A=  =3Buser3  =3B  =3B  =3B | {"search_path=3Dpublic=2C schema= 1=2C schema2=2C schema3"}
(3 rows)

prod_= candidate=3D# alter user postgres set search_path to 'operator=2C gameplay= =2C common'=3B
=0A= ALTER ROLE
prod_candidate=3D# select usename=2C useconfig from pg= _user=3B
 =3B  =3B usename  =3B  =3B |  =3B &= nbsp=3B  =3B  =3B  =3B  =3B  =3B  =3B  =3B usec= onfig  =3B  =3B  =3B  =3B  =3B  =3B  =3B  = =3B  =3B  =3B
----------------+--------------------------= ----------------------
=0A=
 =3Bpostgres  =3B  =3B  =3B | {"search_path=3D\"public= =2C schema1=2C schema2=2C schema3\""}
 =3Buser2 | {"search_pa= th=3Dpublic=2C schema1=2C schema2=2C schema3"}
 =3Buser3 &nbs= p=3B  =3B  =3B | {"search_path=3Dpublic=2C schema1=2C schema2=2C sc= hema3"}
=0A=
(3 rows)

Regards=2C

Colin
=0A=

Hi Colin=2C
you should rather set the path with:

alter u= ser postgres set search_path =3D public=2C schema1=2C schema2=2C schema3=3B=
=0A=


szymon
=
= --_cdd8ffe1-3cc2-40f9-b0f9-4d2c4762976a_--