Horton

Re: [bug] Table not have typarray when created by single user mode

shawn wang <shawn.wang.pg@gmail.com>

View thread View on postgr.es
From: shawn wang <shawn.wang.pg@gmail.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Alvaro Herrera <alvherre@2ndquadrant.com>, wenjing <wjzeng2012@gmail.com>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>, tushar <tushar.ahuja@enterprisedb.com>
Date: 2020-05-25T03:37:42Z
Lists: pgsql-bugs, pgsql-hackers 
Amit Kapila <amit.kapila16@gmail.com> 于2020年5月21日周四 下午7:37写道：

> On Wed, May 20, 2020 at 1:45 PM shawn wang <shawn.wang.pg@gmail.com>
> wrote:


Thank you for your reply.

>
>
It seems to be indicated in the docs [1] (see the paragraph starting
> with "The postgres command can also be called in single-user mode
> ...") that it is used for debugging or disaster recovery.
>
> [1] - https://www.postgresql.org/docs/devel/app-postgres.html


The description here is what users should do, and my suggestion is to
clearly indicate what users cannot do.

Regards,
--
Shawn Wang

Commits

  1. Don't create pg_type entries for sequences or toast tables.

  2. Create composite array types for initdb-created relations.