[bug] Table not have typarray when created by single user mode - Mailing list pgsql-bugs

From wenjing
Subject [bug] Table not have typarray when created by single user mode
Date
Msg-id 761F1389-C6A8-4C15-80CE-950C961F5341@gmail.com
Whole thread Raw
Responses Re: [bug] Table not have typarray when created by single user mode
List pgsql-bugs
Hi 

I found an exception using the latest master branch of PGSQL and wanted to check if it was a bug

Please refer this below scenario
1)initdb  ./initdb -k -D data
2)Connect to server using single user mode ( ./postgres --single -D data postgres) and create a  table
 ./postgres --single -D data Postgres

PostgreSQL stand-alone backend 13devel
backend>create table t_create_by_standalone(n int);

--Press Ctl+D to exit

3) use pg_ctl start database
pg_ctl -D data -c start

4) use psql connect database, and create a table
create table t_create_by_psql(n int);

5) check the pg_type info
postgres=# select oid,relname,reltype from pg_class where relname like 't_create%';
  oid  |        relname         | reltype 
-------+------------------------+---------
 13581 | t_create_by_standalone |   13582
 16384 | t_create_by_psql       |   16386
(2 rows)

postgres=# SELECT oid,typname, typarray FROM pg_catalog.pg_type WHERE oid in (13582,16386);
  oid  |        typname         | typarray 
-------+------------------------+----------
 13582 | t_create_by_standalone |        0
 16386 | t_create_by_psql       |    16385
(2 rows)

Use single user mode (t_create_by_standalone) typarray = 0, but use psql t_create_by_psql typarray has oid.

Is there something wrong to have different catalog information with the same sql?

pgsql-bugs by date:

Previous
From: kjonca@fastmail.com (Kamil Jońca)
Date:
Subject: backend crash
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: BUG #16337: Finnish Ispell dictionary cannot be created