Re: Can I add a column in catalog table as a superuser

From: ZongtianHou <zongtianhou(at)icloud(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Can I add a column in catalog table as a superuser
Date: 2018-10-24 09:54:41
Message-ID: 7F103CFA-4F0C-473D-ABE2-9ACB6CF90FB9@icloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> ZongtianHou <zongtianhou(at)icloud(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jorge Torralba 2018-10-24 18:56:53 Is there a work around for partition key needed for constraint
Previous Message Tom Lane 2018-10-24 09:43:49 Re: Can I add a column in catalog table as a superuser