PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15901
PG Version11.2
OSRed Hat Enterprise Linux Server release 7.3
Opened2019-07-09 09:14:49+00
Reported byIshan Joshi
StatusNew

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

Messages

DateAuthorSubject
2019-07-09 09:14:49+00PG Bug reporting formBUG #15901: Tablespace showing as null in psql and pgadmin
2019-07-09 14:39:55+00Tom LaneRe: BUG #15901: Tablespace showing as null in psql and pgadmin
2019-07-10 05:01:07+00Ishan joshiRe: BUG #15901: Tablespace showing as null in psql and pgadmin
2019-07-10 05:25:03+00Thomas KellererRe: 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+00Ishan joshiRe: BUG #15901: Tablespace showing as null in psql and pgadmin