From: ZongtianHou <zongtianhou@icloud.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Can I add a column in catalog table as a superuser
Date: Wed, 24 Oct 2018 17:54:41 +0800
Message-ID: <7F103CFA-4F0C-473D-ABE2-9ACB6CF90FB9@icloud.com> (raw)
In-Reply-To: <19152.1540374229@sss.pgh.pa.us>
References: <4285ADA2-B55B-41A5-A09D-678687A799EF@icloud.com>
<19152.1540374229@sss.pgh.pa.us>
Thank you for the quick reply, I changed the source code, and installed again. But I still can not have the additional column I added after restart, unless initializing the database. But I don’t want to initialize it in product environment which will drop all the data, it there any other method to do it, like some SQL query?
> On 24 Oct 2018, at 5:43 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> ZongtianHou <zongtianhou@icloud.com> writes:
>> I know this is very dangerous, but I do in my private environment, is there a method to add a column in catalog table, like pg_authid?
>
> Not without patching the source code ...
>
> 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: zongtianhou@icloud.com, tgl@sss.pgh.pa.us, pgsql-admin@lists.postgresql.org
Subject: Re: Can I add a column in catalog table as a superuser
In-Reply-To: <7F103CFA-4F0C-473D-ABE2-9ACB6CF90FB9@icloud.com>
* 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