Обсуждение: BUG #14274: Missing tablespace info in pg_tables

Поиск
Список
Период
Сортировка

BUG #14274: Missing tablespace info in pg_tables

От
eduardo_santana@iol.pt
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDI3NApMb2dnZWQgYnk6ICAg
ICAgICAgIEVkdWFyZG8gU2FudGFuYQpFbWFpbCBhZGRyZXNzOiAgICAgIGVk
dWFyZG9fc2FudGFuYUBpb2wucHQKUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjZi
ZXRhMwpPcGVyYXRpbmcgc3lzdGVtOiAgIENlbnRPUyBMaW51eCByZWxlYXNl
IDcuMC4xNDA2IChDb3JlKQpEZXNjcmlwdGlvbjogICAgICAgIAoKVGhlIHRh
Ymxlc3BhY2UgaW5mbyBpbiBwZ190YWJsZXMgY2F0YWxvZyB0YWJsZSBpcyBt
aXNzaW5nIGFmdGVyIGNyZWF0aW5nIGEKdGFibGUgaW4gYSBub24gZGVmYXVs
dCB0YWJsZXNwYWNlLgoK

Re: BUG #14274: Missing tablespace info in pg_tables

От
Tom Lane
Дата:
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

Re: BUG #14274: Missing tablespace info inpg_tables

От
eduardo_santana@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_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.
		regards, tom lane