From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: pg_authid has duplicated rows
Date: Tue, 24 Jul 2018 09:57:28 -0400
Message-ID: <1602.1532440648@sss.pgh.pa.us> (raw)
In-Reply-To: <CA+t6e1=BngUk6xPzZX2-LcYRiFSGKYUfqkgX8PPdxtZNNJX7fg@mail.gmail.com>
References: <20180723203311.7isul7yxziiw7wbx@alvherre.pgsql>
<CA916A7F-0469-45B5-9AC3-1AC0F5CCB859@anarazel.de>
<CA+t6e1=BngUk6xPzZX2-LcYRiFSGKYUfqkgX8PPdxtZNNJX7fg@mail.gmail.com>
Mariel Cherkassky <mariel.cherkassky@gmail.com> writes:
> I checked it also in version 9.6, and in this version I can edit the
> pg_authid table. I'm suppose to get an error that the table is a system
> catalog or am I wrong ?
No, the "system catalog modification" restriction only applies to DDL
on the system catalogs --- for instance, adding/removing a column, which
our C code couldn't cope with. You're free to change their contents by
hand if you're a superuser. (And if you break something that way, you
get to keep both pieces. But sometimes it's necessary.)
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, mariel.cherkassky@gmail.com, andres@anarazel.de, alvherre@2ndquadrant.com, pgsql-admin@lists.postgresql.org
Subject: Re: pg_authid has duplicated rows
In-Reply-To: <1602.1532440648@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox