Collected from the PG bugs email list.
|OS||Red Hat Enterprise Linux Server release 7.3|
|Reported by||Ishan Joshi|
Body of first available message related to this bug follows.
The following bug has been logged on the website: Bug reference: 15901 Logged by: Ishan Joshi Email address: (redacted) PostgreSQL version: 11.2 Operating system: Red Hat Enterprise Linux Server release 7.3 Description: Hi Team, As I have created separate tablespace (Not using default tablespace pg_default or pg_global) for my new database. I have tried to create tables with and without tablespace parameter and both these tables while checking in pg_table, tablespace column showing as null. I tried to extract from other tables but getting tablespace as null only. Example: -- Create tablespace CREATE TABLESPACE testts OWNER postgres LOCATION '/users/pgtablespaces/testts'; --Create database CREATE DATABASE testdb WITH OWNER = postgres ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'en_US.UTF8' TABLESPACE = testts CONNECTION LIMIT = -1 TEMPLATE = template0; Create table test1c (Id integer, name varchar(10)) tablespace testts; Create table test2c (Id integer, name varchar(10)) ; Output: select schemaname,tablename,tablespace from pg_tables where tablename in('test1c','test2c'); testschema | test1c | public | test2c | public | test1c | It seems to be bug here as I tried to check the same in pgAdmin tool which is also having the same result. Thanks
|2019-07-09 09:14:49+00||PG Bug reporting form||BUG #15901: Tablespace showing as null in psql and pgadmin|
|2019-07-09 14:39:55+00||Tom Lane||Re: BUG #15901: Tablespace showing as null in psql and pgadmin|
|2019-07-10 05:01:07+00||Ishan joshi||Re: BUG #15901: Tablespace showing as null in psql and pgadmin|
|2019-07-10 05:25:03+00||Thomas Kellerer||Re: BUG #15901: Tablespace showing as null in psql and pgadmin|
|2019-07-10 05:39:17+00||"David G(dot) Johnston"||Re: BUG #15901: Tablespace showing as null in psql and pgadmin|
|2019-07-10 06:02:43+00||Ishan joshi||Re: BUG #15901: Tablespace showing as null in psql and pgadmin|