Обсуждение: BUG #14274: Missing tablespace info in pg_tables
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDI3NApMb2dnZWQgYnk6ICAg ICAgICAgIEVkdWFyZG8gU2FudGFuYQpFbWFpbCBhZGRyZXNzOiAgICAgIGVk dWFyZG9fc2FudGFuYUBpb2wucHQKUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjZi ZXRhMwpPcGVyYXRpbmcgc3lzdGVtOiAgIENlbnRPUyBMaW51eCByZWxlYXNl IDcuMC4xNDA2IChDb3JlKQpEZXNjcmlwdGlvbjogICAgICAgIAoKVGhlIHRh Ymxlc3BhY2UgaW5mbyBpbiBwZ190YWJsZXMgY2F0YWxvZyB0YWJsZSBpcyBt aXNzaW5nIGFmdGVyIGNyZWF0aW5nIGEKdGFibGUgaW4gYSBub24gZGVmYXVs dCB0YWJsZXNwYWNlLgoK
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
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