BUG #14311: ERROR: must be owner of extension plpgsql

From: fabien(dot)combernous(at)adullact(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14311: ERROR: must be owner of extension plpgsql
Date: 2016-09-05 12:11:42
Message-ID: 20160905121142.1404.83483@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14311
Logged by: Fabien C
Email address: fabien(dot)combernous(at)adullact(dot)org
PostgreSQL version: 9.1.23
Operating system: Linux

CREATE DATABASE foo; pg_dump foo |psql fails if you're not a superuser

the problem here is that changing the comment of an extension not owned by
you causes an error, unless you're superuser.

but the user never added the comment; the system did via pg_dump.

This means :
1) writing a dump file first and editing it, or
2) not being able to use -v ON_ERROR_STOP=1

Browse pgsql-bugs by date

  From Date Subject
Next Message hernan.bazan 2016-09-05 14:51:43 BUG #14312: Hardcoded dbname on test_postmaster_connection
Previous Message iurii.i.popov 2016-09-05 09:30:26 BUG #14310: Triggers do not fire