[BUGS] BUG #14274: Missing tablespace info in pg_tables

[eduardo...@iol.pt]

The following bug has been logged on the website:

Bug reference: 14274
Logged by: Eduardo Santana
Email address: eduardo...@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...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[Tom Lane]

eduardo...@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

[eduardo...@iol.pt]

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...@iol.ptwrites: