Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
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 ROLEAnd now, I can't get it to insert correctly again, there always seems to be some backslashes stuck in there:prod_candidate=# alter user postgres set search_path to '';ALTER ROLEprod_candidate=# select usename, useconfig from pg_user; usename | useconfig ----------------+-------------------------------------------- postgres | {"search_path=\"\""} user2 | {"search_path=public, schema1, schema2, schema3"} user3 | {"search_path=public, schema1, schema2, schema3"}(3 rows)prod_candidate=# alter user postgres set search_path to 'operator, gameplay, common'; ALTER ROLEprod_candidate=# select usename, useconfig from pg_user; usename | useconfig ----------------+------------------------------------------------ postgres | {"search_path=\"public, schema1, schema2, schema3\""} user2 | {"search_path=public, schema1, schema2, schema3"} user3 | {"search_path=public, schema1, schema2, schema3"}(3 rows)Regards,Colin
В списке pgsql-admin по дате отправления: