Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14844: Failure/Duplicate key value with ALTER DATABASE set search_path - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14844: Failure/Duplicate key value with ALTER DATABASE set search_path
Date
Msg-id 6266.1507301331@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] BUG #14844: Failure/Duplicate key value with ALTER DATABASE setsearch_path  (buschmann@nidsa.net)
List pgsql-bugs
Tree view 
buschmann@nidsa.net writes:
> When trying to change or reset the search path the following error occurs
> (PG 10.0):

> didisdb=# ALTER DATABASE xxxdb SET search_path TO public,xxxo,xxxp;
> ERROR:  duplicate key value violates unique constraint
> "pg_db_role_setting_databaseid_rol_index"
> DETAIL:  Key (setdatabase, setrole)=(19084, 0) already exists.

I tried to reproduce this, but could not.  Can you reconstruct the
exact sequence of commands you issued to get here?
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] Bug in Postgresql 10.0: regexp functions return invalid cach ID: 42
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance