BUG #15072: Unable to get tablespace from pg_tables for new createdtable
От | PG Bug reporting form |
---|---|
Тема | BUG #15072: Unable to get tablespace from pg_tables for new createdtable |
Дата | |
Msg-id | 151894754375.1388.3312596352253421332@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15072: Unable to get tablespace from pg_tables for new created table
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15072 Logged by: rheman pessek Email address: rhemandaddy@googlemail.com PostgreSQL version: 10.2 Operating system: ubuntu server 16.04.3 Description: Hi everyone. I have created tablespace. sudo mkdir /tbs_data sudo chown -R postgres:postgres /tbs_data su - postgres create tablespace tbs_data location ‘/tbs_data’; Then I have create database and tables on that tablespace. create database gescom_bis tablespace tbs_data; \c gescom_bis; SET default_tablespace = 'tbs_data'; create table voiture_bis (num int) tablespace tbs_data; But when I run this the following query I have ans empty (blank result) select tablespace from pg_tables where tablename='voiture_bis'; hence the tablespace name is not displayed. But went I run the following query, everythins seams to work. select oid from pg_database where datname = 'gescom_bis'; select relfilenode from pg_class where relname = 'voiture_bis'; Best ragrd.
В списке pgsql-bugs по дате отправления: