From: wenjing <wjzeng2012@gmail.com>
To: pgsql-bugs@lists.postgresql.org
Cc: tushar <tushar.ahuja@enterprisedb.com>
Subject: [bug] Table not have typarray when created by single user mode
Date: Mon, 13 Apr 2020 16:25:02 +0800
Message-ID: <761F1389-C6A8-4C15-80CE-950C961F5341@gmail.com> (raw)
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?
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-bugs@postgresql.org
Cc: wjzeng2012@gmail.com, pgsql-bugs@lists.postgresql.org, tushar.ahuja@enterprisedb.com
Subject: Re: [bug] Table not have typarray when created by single user mode
In-Reply-To: <761F1389-C6A8-4C15-80CE-950C961F5341@gmail.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