From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | ishanjoshi(at)live(dot)com |
Subject: | BUG #15901: Tablespace showing as null in psql and pgadmin |
Date: | 2019-07-09 09:14:49 |
Message-ID: | 15901-e5cfe2dd7298a3a4@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15901
Logged by: Ishan Joshi
Email address: ishanjoshi(at)live(dot)com
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
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2019-07-09 11:43:56 | BUG #15902: pgAdmin generates faulty SQL |
Previous Message | Rares Salcudean | 2019-07-09 06:53:26 | Re: PG11 - Multiple Key Range Partition |