BUG #14274: Missing tablespace info in pg_tables

Started by Nonameover 9 years ago3 messagesbugs
Jump to latest
#1Noname
eduardo_santana@iol.pt

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: BUG #14274: Missing tablespace info in pg_tables

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

#3Noname
eduardo_santana@iol.pt
In reply to: Tom Lane (#2)
Re: BUG #14274: Missing tablespace info in pg_tables

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