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

FAQ