Can I add a column in catalog table as a superuser
Can I add a column in catalog table as a superuser
От:
ZongtianHou <zongtianhou@icloud.com>
Дата:
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?
Re: Can I add a column in catalog table as a superuser
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
ZongtianHou 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
Re: Can I add a column in catalog table as a superuser
От:
ZongtianHou <zongtianhou@icloud.com>
Дата:
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 wrote: > > ZongtianHou 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
Re: Can I add a column in catalog table as a superuser
От:
Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Дата:
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