From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: 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: Sat, 3 Nov 2018 10:00:31 +0100
Message-ID: <4295c1b0-610e-45d7-59ca-d48196f23b8c@2ndquadrant.com> (raw)
In-Reply-To: <7F103CFA-4F0C-473D-ABE2-9ACB6CF90FB9@icloud.com>
References: <4285ADA2-B55B-41A5-A09D-678687A799EF@icloud.com>
<19152.1540374229@sss.pgh.pa.us>
<7F103CFA-4F0C-473D-ABE2-9ACB6CF90FB9@icloud.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
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: peter.eisentraut@2ndquadrant.com, 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: <4295c1b0-610e-45d7-59ca-d48196f23b8c@2ndquadrant.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