buschmann(at)nidsa(dot)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