[ADMIN] search_path update weirdness

2013-07-08 Thread Colin S
Hello, I made a bad update to search_path, which basically had line returns: prod_candidate=# alter user postgres set search_path to 'search_path=public, schemprod_candidate'# a1, schema2, schema3'prod_candidate-# ;ALTER ROLE And now, I can't get it to insert correctly again, there always seems

Re: [ADMIN] search_path update weirdness

2013-07-08 Thread Szymon Guz
On 8 July 2013 14:40, Colin S colin_sl...@hotmail.com wrote: Hello, I made a bad update to search_path, which basically had line returns: prod_candidate=# alter user postgres set search_path to 'search_path=public, schem prod_candidate'# a1, schema2, schema3' prod_candidate-# ; ALTER

Re: [ADMIN] search_path update weirdness

2013-07-08 Thread Colin S
Date: Mon, 8 Jul 2013 14:46:29 +0200 Subject: Re: [ADMIN] search_path update weirdness From: mabew...@gmail.com To: colin_sl...@hotmail.com CC: pgsql-admin@postgresql.org Hi szymon, My mistake. I chock it up to another manic monday. Thanks! Colin On 8 July 2013 14:40, Colin S colin_sl