MIME-Version: 1.0
References: 
 <CAHut+PvSOmRrQX+VrFYHtFipV9hM=p99FeOwYCzkuU2BOaLu7Q@mail.gmail.com>
 <5420ddcb-7b55-4a73-b8c5-3602abfac78b@uni-muenster.de>
In-Reply-To: <5420ddcb-7b55-4a73-b8c5-3602abfac78b@uni-muenster.de>
From: Peter Smith <smithpb2250@gmail.com>
Date: Tue, 19 May 2026 17:08:27 +1000
Message-ID: 
 <CAHut+Pturr_EY3WgVMT5+rrcKLm9HcRCk5X0WH8zvwtD2K2ixA@mail.gmail.com>
Subject: Re: PSQL - prevent describe listing tables that are already in listed
 schemas
To: Jim Jones <jim.jones@uni-muenster.de>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="0000000000001e41520652265ac2"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHut%2BPturr_EY3WgVMT5%2BrrcKLm9HcRCk5X0WH8zvwtD2K2ixA%40mail.gmail.com>
Precedence: bulk

--0000000000001e41520652265ac2
Content-Type: text/plain; charset="UTF-8"

Hi Jim.

Thanks for reviewing and testing my patch. PSA v2 with that missing \n restored.

======
Kind Regards,
Peter Smith.
Fujitsu Australia

--0000000000001e41520652265ac2
Content-Type: application/octet-stream;
	name="v2-0001-Fix-psql-publication-describe-for-tables-in-schem.patch"
Content-Disposition: attachment;
	filename="v2-0001-Fix-psql-publication-describe-for-tables-in-schem.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mpcajsca0>
X-Attachment-Id: f_mpcajsca0

RnJvbSBhNTcwOWRjMzZjOTBlZmI1ODUyNDBkMWZlNmIyZDZiZTNlMzMxOWJiIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBTbWl0aCA8cGV0ZXIuYi5zbWl0aEBmdWppdHN1LmNv
bT4KRGF0ZTogVHVlLCAxOSBNYXkgMjAyNiAxNzowNDo0OSArMTAwMApTdWJqZWN0OiBbUEFUQ0gg
djJdIEZpeCBwc3FsIHB1YmxpY2F0aW9uIGRlc2NyaWJlIGZvciB0YWJsZXMgaW4gc2NoZW1hCgot
LS0KIHNyYy9iaW4vcHNxbC9kZXNjcmliZS5jICAgICAgICAgICAgICAgICAgIHwgNyArKysrKyst
CiBzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3B1YmxpY2F0aW9uLm91dCB8IDYgLS0tLS0tCiAy
IGZpbGVzIGNoYW5nZWQsIDYgaW5zZXJ0aW9ucygrKSwgNyBkZWxldGlvbnMoLSkKCmRpZmYgLS1n
aXQgYS9zcmMvYmluL3BzcWwvZGVzY3JpYmUuYyBiL3NyYy9iaW4vcHNxbC9kZXNjcmliZS5jCmlu
ZGV4IGUxNDQ5NjU0Zjk2Li5mNTU1MTg5NjU5OCAxMDA2NDQKLS0tIGEvc3JjL2Jpbi9wc3FsL2Rl
c2NyaWJlLmMKKysrIGIvc3JjL2Jpbi9wc3FsL2Rlc2NyaWJlLmMKQEAgLTcwMTUsNyArNzAxNSwx
MiBAQCBkZXNjcmliZVB1YmxpY2F0aW9ucyhjb25zdCBjaGFyICpwYXR0ZXJuKQogCQkJCQkJCSAg
IiAgICAgcGdfY2F0YWxvZy5wZ19wdWJsaWNhdGlvbl9yZWwgcHJcbiIKIAkJCQkJCQkgICJXSEVS
RSBjLnJlbG5hbWVzcGFjZSA9IG4ub2lkXG4iCiAJCQkJCQkJICAiICBBTkQgYy5vaWQgPSBwci5w
cnJlbGlkXG4iCi0JCQkJCQkJICAiICBBTkQgcHIucHJwdWJpZCA9ICclcydcbiIsIHB1YmlkKTsK
KwkJCQkJCQkgICIgIEFORCBwci5wcnB1YmlkID0gJyVzJ1xuIgorCQkJCQkJCSAgIiAgQU5EIG4u
b2lkIE5PVCBJTiAoXG4iCisJCQkJCQkJICAiICAgICBTRUxFQ1QgcG4ucG5uc3BpZFxuIgorCQkJ
CQkJCSAgIiAgICAgRlJPTSBwZ19jYXRhbG9nLnBnX3B1YmxpY2F0aW9uX25hbWVzcGFjZSBwblxu
IgorCQkJCQkJCSAgIiAgICAgV0hFUkUgcG4ucG5wdWJpZCA9ICclcydcbikiLAorCQkJCQkJCSAg
cHViaWQsIHB1YmlkKTsKIAogCQkJaWYgKHBzZXQuc3ZlcnNpb24gPj0gMTkwMDAwKQogCQkJCWFw
cGVuZFBRRXhwQnVmZmVyU3RyKCZidWYsICIgIEFORCBOT1QgcHIucHJleGNlcHRcbiIpOwpkaWZm
IC0tZ2l0IGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wdWJsaWNhdGlvbi5vdXQgYi9zcmMv
dGVzdC9yZWdyZXNzL2V4cGVjdGVkL3B1YmxpY2F0aW9uLm91dAppbmRleCAyOWU1NGIyMTRhMC4u
YjI5YjZiNTMxMTkgMTAwNjQ0Ci0tLSBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcHVibGlj
YXRpb24ub3V0CisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcHVibGljYXRpb24ub3V0
CkBAIC0xNDYsOCArMTQ2LDYgQEAgUkVTRVQgY2xpZW50X21pbl9tZXNzYWdlczsKICAgICAgICAg
ICBPd25lciAgICAgICAgICAgfCBBbGwgdGFibGVzIHwgQWxsIHNlcXVlbmNlcyB8IEluc2VydHMg
fCBVcGRhdGVzIHwgRGVsZXRlcyB8IFRydW5jYXRlcyB8IEdlbmVyYXRlZCBjb2x1bW5zIHwgVmlh
IHJvb3QgfCBEZXNjcmlwdGlvbiAKIC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0t
LS0tLSstLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0t
LS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0KICByZWdy
ZXNzX3B1YmxpY2F0aW9uX3VzZXIgfCBmICAgICAgICAgIHwgZiAgICAgICAgICAgICB8IHQgICAg
ICAgfCB0ICAgICAgIHwgdCAgICAgICB8IHQgICAgICAgICB8IG5vbmUgICAgICAgICAgICAgIHwg
ZiAgICAgICAgfCAKLVRhYmxlczoKLSAgICAicHViX3Rlc3QudGVzdHB1Yl9ub3BrIgogVGFibGVz
IGZyb20gc2NoZW1hczoKICAgICAicHViX3Rlc3QiCiAKQEAgLTE2Nyw4ICsxNjUsNiBAQCBBTFRF
UiBQVUJMSUNBVElPTiB0ZXN0cHViX2ZvcnNjaGVtYSBBREQgVEFCTEUgcHViX3Rlc3QudGVzdHB1
Yl9ub3BrOwogICAgICAgICAgIE93bmVyICAgICAgICAgICB8IEFsbCB0YWJsZXMgfCBBbGwgc2Vx
dWVuY2VzIHwgSW5zZXJ0cyB8IFVwZGF0ZXMgfCBEZWxldGVzIHwgVHJ1bmNhdGVzIHwgR2VuZXJh
dGVkIGNvbHVtbnMgfCBWaWEgcm9vdCB8IERlc2NyaXB0aW9uIAogLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0t
Ky0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0t
LS0tLS0tLS0tLQogIHJlZ3Jlc3NfcHVibGljYXRpb25fdXNlciB8IGYgICAgICAgICAgfCBmICAg
ICAgICAgICAgIHwgdCAgICAgICB8IHQgICAgICAgfCB0ICAgICAgIHwgdCAgICAgICAgIHwgbm9u
ZSAgICAgICAgICAgICAgfCBmICAgICAgICB8IAotVGFibGVzOgotICAgICJwdWJfdGVzdC50ZXN0
cHViX25vcGsiCiBUYWJsZXMgZnJvbSBzY2hlbWFzOgogICAgICJwdWJfdGVzdCIKIApAQCAtODMy
LDggKzgyOCw2IEBAIFJFU0VUIGNsaWVudF9taW5fbWVzc2FnZXM7CiAgICAgICAgICAgT3duZXIg
ICAgICAgICAgIHwgQWxsIHRhYmxlcyB8IEFsbCBzZXF1ZW5jZXMgfCBJbnNlcnRzIHwgVXBkYXRl
cyB8IERlbGV0ZXMgfCBUcnVuY2F0ZXMgfCBHZW5lcmF0ZWQgY29sdW1ucyB8IFZpYSByb290IHwg
RGVzY3JpcHRpb24gCiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0t
LS0tLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0t
LS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tCiAgcmVncmVzc19wdWJs
aWNhdGlvbl91c2VyIHwgZiAgICAgICAgICB8IGYgICAgICAgICAgICAgfCB0ICAgICAgIHwgdCAg
ICAgICB8IHQgICAgICAgfCB0ICAgICAgICAgfCBub25lICAgICAgICAgICAgICB8IGYgICAgICAg
IHwgCi1UYWJsZXM6Ci0gICAgInRlc3RwdWJfcmZfc2NoZW1hMi50ZXN0cHViX3JmX3RibDYiIFdI
RVJFIChpIDwgOTkpCiBUYWJsZXMgZnJvbSBzY2hlbWFzOgogICAgICJ0ZXN0cHViX3JmX3NjaGVt
YTIiCiAKLS0gCjIuNDcuMwoK
--0000000000001e41520652265ac2--