pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan I add a column in catalog table as a superuser
4+ messages / 3 participants
[nested] [flat]
* Can I add a column in catalog table as a superuser
@ 2018-10-24 09:35 ZongtianHou <zongtianhou@icloud.com>
2018-10-24 09:43 ` Re: Can I add a column in catalog table as a superuser Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: ZongtianHou @ 2018-10-24 09:35 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi, everyone
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?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can I add a column in catalog table as a superuser
2018-10-24 09:35 Can I add a column in catalog table as a superuser ZongtianHou <zongtianhou@icloud.com>
@ 2018-10-24 09:43 ` Tom Lane <tgl@sss.pgh.pa.us>
2018-10-24 09:54 ` Re: Can I add a column in catalog table as a superuser ZongtianHou <zongtianhou@icloud.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2018-10-24 09:43 UTC (permalink / raw)
To: ZongtianHou <zongtianhou@icloud.com>; +Cc: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can I add a column in catalog table as a superuser
2018-10-24 09:35 Can I add a column in catalog table as a superuser ZongtianHou <zongtianhou@icloud.com>
2018-10-24 09:43 ` Re: Can I add a column in catalog table as a superuser Tom Lane <tgl@sss.pgh.pa.us>
@ 2018-10-24 09:54 ` ZongtianHou <zongtianhou@icloud.com>
2018-11-03 09:00 ` Re: Can I add a column in catalog table as a superuser Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 1 reply; 4+ messages in thread
From: ZongtianHou @ 2018-10-24 09:54 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can I add a column in catalog table as a superuser
2018-10-24 09:35 Can I add a column in catalog table as a superuser ZongtianHou <zongtianhou@icloud.com>
2018-10-24 09:43 ` Re: Can I add a column in catalog table as a superuser Tom Lane <tgl@sss.pgh.pa.us>
2018-10-24 09:54 ` Re: Can I add a column in catalog table as a superuser ZongtianHou <zongtianhou@icloud.com>
@ 2018-11-03 09:00 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 0 replies; 4+ messages in thread
From: Peter Eisentraut @ 2018-11-03 09:00 UTC (permalink / raw)
To: ZongtianHou <zongtianhou@icloud.com>; Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin@lists.postgresql.org
On 24/10/2018 11:54, ZongtianHou wrote:
> 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?
no
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2018-11-03 09:00 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-10-24 09:35 Can I add a column in catalog table as a superuser ZongtianHou <zongtianhou@icloud.com>
2018-10-24 09:43 ` Tom Lane <tgl@sss.pgh.pa.us>
2018-10-24 09:54 ` ZongtianHou <zongtianhou@icloud.com>
2018-11-03 09:00 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
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