From: | "Godfrin, Philippe E" <philippe(dot)godfrin(at)nov(dot)com> |
---|---|
To: | <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Cc: | <sudheer(dot)sangunni(at)nov(dot)com> |
Subject: | CREATE SERVER makes 2 entries in the dictionary |
Date: | 2021-06-01 12:47:19 |
Message-ID: | SA0PR15MB39330CC7335F0C723860F837823E9@SA0PR15MB3933.namprd15.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I’ve connected to a test database, executed the create server syntax successfully. While connected to the test database, I see results in the pg_foreign_server table. Changing to the postgres database, I see the same results in the postgres database, but with a different OID. Furthermore, alterations can be made independently to each server based on which db one is connected to.
Seems to me this is a bug:
Pg
postgres(at)tsthpx01:~/work/tsdb=> psql -dtsdb
Pager usage is off.
psql (13.3 (Ubuntu 13.3-1.pgdg18.04+1))
Type "help" for help.
[tsdb(at)] # select * from pg_foreign_server;
oid | srvname | srvowner | srvfdw | srvtype | srvversion | srvacl | srvoptions
-------+---------+----------+--------+---------+------------+---------------------------------------------------------+--------------------------------------------------------------------------------------------------------------
16586 | shard01 | 10 | 16391 | (null) | (null) | {postgres=U/postgres,tsdb=U/postgres,tsdbrw=U/postgres} | {dbname=tsdb,use_remote_estimate=true,fetch_size=100000,"port=5432,6432","host=172.31.68.147,172.31.68.147"}
(1 row)
Time: 0.812 ms
[tsdb(at)] # \c postgres
You are now connected to database "postgres" as user "postgres".
[postgres(at)] # select * from pg_foreign_server;
oid | srvname | srvowner | srvfdw | srvtype | srvversion | srvacl | srvoptions
-------+---------+----------+--------+---------+------------+---------------------------------------------------------+----------------------------------------------------------------------------------------------------------------
16521 | shard01 | 10 | 16399 | (null) | (null) | {postgres=U/postgres,tsdb=U/postgres,tsdbrw=U/postgres} | {host=172.31.68.147,dbname=tsdb,use_remote_estimate=true,fetch_size=100000,target_session_attrs=any,port=6432}
(1 row)
Time: 0.702 ms
[postgres(at)] # select version();
version
---------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 13.3 (Ubuntu 13.3-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit
(1 row)
Time: 0.400 ms
[postgres(at)] #
Phil Godfrin | Database Administrator
NOV
NOV US | Engineering Data
9720 Beechnut St | Houston, Texas 77036
M 281.825.2311
E Philippe(dot)Godfrin(at)nov(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2021-06-01 13:24:05 | Re: CREATE SERVER makes 2 entries in the dictionary |
Previous Message | Eugene Pazhitnov | 2021-06-01 12:18:49 | Re: jsonb merge with update ... on conflict do |