BUG #14274: Missing tablespace info in pg_tables
The following bug has been logged on the website:
Bug reference: 14274
Logged by: Eduardo Santana
Email address: eduardo_santana@iol.pt
PostgreSQL version: 9.6beta3
Operating system: CentOS Linux release 7.0.1406 (Core)
Description:
The tablespace info in pg_tables catalog table is missing after creating a
table in a non default tablespace.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
eduardo_santana@iol.pt writes:
The tablespace info in pg_tables catalog table is missing after creating a
table in a non default tablespace.
This bug report's not of much use without a concrete example.
But please note that pg_tables.tablespace is supposed to read as null
for a table that's in the database's default tablespace. Whether that
is "pg_default" is not relevant.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Hi Tom,
I'm new in PostgreSQL.
Now I realize that you are
completely right...The behavior is similar to Informix... I'm sorry for
the inconvenient.
Best regards,
Eduardo Santana
Em 2016-08-02
16:07, Tom Lane escreveu:
eduardo_santana@iol.ptwrites:
The
tablespace info in pg_tables catalog table is missing after creating a
table in a non default tablespace.
This bug report's not of much
use without a concrete example.
But please note that
pg_tables.tablespace is supposed to read as null
for a table that's in
the database's default tablespace. Whether that
is "pg_default" is not
relevant.
Show quoted text
regards, tom lane