Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gFFsR-0002EY-8s for pgsql-admin@arkaria.postgresql.org; Wed, 24 Oct 2018 09:54:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gFFsO-0006tG-S8 for pgsql-admin@arkaria.postgresql.org; Wed, 24 Oct 2018 09:54:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gFFsM-0006ZX-Qs for pgsql-admin@lists.postgresql.org; Wed, 24 Oct 2018 09:54:54 +0000 Received: from pv33p00im-asmtp003.me.com ([17.142.194.252]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gFFsJ-0001Yz-9b for pgsql-admin@lists.postgresql.org; Wed, 24 Oct 2018 09:54:52 +0000 Received: from process-dkim-sign-daemon.pv33p00im-asmtp003.me.com by pv33p00im-asmtp003.me.com (Oracle Communications Messaging Server 8.0.2.2.20180531 64bit (built May 31 2018)) id <0PH300D00KLFGP00@pv33p00im-asmtp003.me.com> for pgsql-admin@lists.postgresql.org; Wed, 24 Oct 2018 09:54:50 +0000 (GMT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=icloud.com; s=04042017; t=1540374890; bh=aSZpMj1GXFeNHaeV8IViMuLuMvX/zY7LI0sr8iz24OE=; h=Content-type:MIME-version:Subject:From:Date:Message-id:To; b=fRw0UzdoNV0gaDiIHnILAxT0gEMDDTnvnjvNS0KS24KnXzfn05+x97WTShX5oJ2no eHQHAftXNsQO6Mr6V3xzi4B4pIlOKNIHIZ8XOWGV3B1fgz+qevIYEYJGPP1+0QS25W SvMorVNF5n2gc5TFP479eT80Ma/v/BqtAM9QesIWBtaWBkqx1rUpXibW+7jySpQdqs KP0HBmyfp6SPnaofR7wh0Ny8LcAfYp/oetl9M0xgkJN8IYeMHUhq8uCf95lWSSEI4m rDpvTl6PVVNslzqbeCj30uq0g0KWqCick28Zwb/oJ9oNup6KnlDSniqXTxaiptYGGk UrFcRQXQrw+Tw== Received: from icloud.com ([127.0.0.1]) by pv33p00im-asmtp003.me.com (Oracle Communications Messaging Server 8.0.2.2.20180531 64bit (built May 31 2018)) with ESMTPSA id <0PH300D99KV6S040@pv33p00im-asmtp003.me.com>; Wed, 24 Oct 2018 09:54:47 +0000 (GMT) X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 suspectscore=0 malwarescore=0 phishscore=0 bulkscore=0 spamscore=0 clxscore=1011 mlxscore=0 mlxlogscore=824 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1807170000 definitions=main-1810240089 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:,, definitions=2018-10-24_04:,, signatures=0 Content-type: text/plain; charset=utf-8 MIME-version: 1.0 (Mac OS X Mail 10.3 \(3273\)) Subject: Re: Can I add a column in catalog table as a superuser From: ZongtianHou In-reply-to: <19152.1540374229@sss.pgh.pa.us> Date: Wed, 24 Oct 2018 17:54:41 +0800 Cc: pgsql-admin@lists.postgresql.org Content-transfer-encoding: quoted-printable Message-id: <7F103CFA-4F0C-473D-ABE2-9ACB6CF90FB9@icloud.com> References: <4285ADA2-B55B-41A5-A09D-678687A799EF@icloud.com> <19152.1540374229@sss.pgh.pa.us> To: Tom Lane X-Mailer: Apple Mail (2.3273) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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=E2=80=99t 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: >=20 > 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? >=20 > Not without patching the source code ... >=20 > regards, tom lane