Discussion:
[BUGS] BUG #14274: Missing tablespace info in pg_tables
(too old to reply)
e***@iol.pt
2016-08-02 11:21:46 UTC
Permalink
The following bug has been logged on the website:

Bug reference: 14274
Logged by: Eduardo Santana
Email address: ***@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.postg
Tom Lane
2016-08-02 15:07:53 UTC
Permalink
Post by e***@iol.pt
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-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
e***@iol.pt
2016-08-02 15:50:53 UTC
Permalink
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
Post by Tom Lane
The
tablespace info in pg_tables catalog table is missing after creating a
table in a non default tablespace.
Post by Tom Lane
This bug report's not of much
use without a concrete example.
Post by Tom Lane
But please note that
pg_tables.tablespace is supposed to read as null
Post by Tom Lane
for a table that's in
the database's default tablespace. Whether that
Post by Tom Lane
is "pg_default" is not
relevant.
Post by Tom Lane
regards, tom lane
Loading...