Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hJmNn-0000OK-0l for pgsql-docs@arkaria.postgresql.org; Thu, 25 Apr 2019 21:58:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hJmNl-00064c-R5 for pgsql-docs@arkaria.postgresql.org; Thu, 25 Apr 2019 21:58:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hJmNl-0005z5-5K for pgsql-docs@lists.postgresql.org; Thu, 25 Apr 2019 21:58:17 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hJmNi-0006Ty-6d for pgsql-docs@lists.postgresql.org; Thu, 25 Apr 2019 21:58:15 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:MIME-Version:Date: Message-ID:References:Cc:To:From:Subject:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=KpumfGV6zxvWfUwAIffNJm2JaJlnDY27V3aSR6REmwY=; b=R10lQvTyr3xuetywGyqwUCU1ha tShsyG11uw56G3HGjPHqmWj2tBhyj3uoLiksW/zM07xf2/FcbxvrbbIiF7EHlFBjlUdPkLtRp5mcB KWjA8+8KcJXHKUCfsun/8KUtzBFridcGQ3LFquw8kzNqg8HQMsuQP4IU5av+KoP/tWzvORGMaDuCu X3bmm42r2KvhF/zGwEmST2xgLAk2EELjuFZqgoWGrXqJ6v3/p7FPq6694O2Hzdy0nuOYdiCfRX4Qr gnUEuXiNeL153812opFYVQLuKKKu2CVxKM4PtU/NrMAHFoNXfxIzJtoQ/Upf9YkujJ0hNV0lvditP RTxQuC6w==; Received: from pool-96-250-83-19.nycmny.fios.verizon.net ([96.250.83.19] helo=Ph33r-Retina.home) by meldrar.postgresql.org with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hJmNd-0001tO-Lm; Thu, 25 Apr 2019 21:58:12 +0000 Subject: Re: SET ROLE documentation not entirely correct From: "Jonathan S. Katz" To: Joe Conway , Stephen Frost , Tom Lane Cc: Steven Winfield , "pgsql-docs@lists.postgresql.org" , "Jonathan S. Katz" References: <155603476764.1372.10888362840885095061@wrigleys.postgresql.org> <03796ce5-8366-cd32-0436-9981ffbeb993@joeconway.com> <67c97dbc-9caf-aa7e-622a-e20b28b7e597@joeconway.com> <02e17cb3-f8a9-234f-f3ce-2b80bc49031d@joeconway.com> <26109.1556217198@sss.pgh.pa.us> <20190425190626.GY6197@tamriel.snowman.net> <97c6e8d5-7e51-5cd2-4fc2-652ad02659d9@joeconway.com> <6bd15afe-69ea-33b7-379a-f71fda68b427@postgresql.org> Openpgp: preference=signencrypt Autocrypt: addr=jkatz@postgresql.org; keydata= mQINBFtShwABEAC7PNHDUOTYuifpUCk23KqfxdQQkn4nkoxOXRK0+rAj36FiwqGB4TJFuOVZ sDFAEiSlC8Jt4y5Cs7B5tetT8JNd2cs6zp/udMJJDz9d65O9PDpdlMgAmIiTzpLlSdx8FG56 DTksaDv1d8j3cTJPSE4/fWSxqzA7o3Y9UuL7atZPrzfImgpRKs0of7elIHwOa8GucjyhYqcR h60wFBJc2KXqQdDYRTZy43DSnY/0VNc0omiH355fustvpm+m5HjD3w7qZyfN3fpKJpnX1LCF f3MnPHaDGITIYGRCBXvf0UqUtD6OEVWPv2C2gyqWMIpWmZTOgDufltKyIByKBoS9x0PlFkij 04X3KODCngt+N8Ssc9OICc6QSxhjoP48PYPdmiTmkrGuf0LX084wj1xeo1NX7XxZK39F6dTJ DhsIiW0sNS0xMxQHLHG9VLbPjx3SANQBh6BuryPz5ZupW9/TIDmkvprtU/oXfKgtfYm3fxmk EctxbWrEPsFTFPyuMqQu6l+xyQv0s1VLZfjNWaua6H1/gGoIt6kRnn5qMXDVVpijuWkHbv7G ngaQMd258UrrOEHnnjzhQ7jxMWV9D+emxbAtlIxnYvCWlV4IwAQhEHfvudqYaIY3hNWrvQ6H GB2KXoTZYN9g5djm14/5nj1IU5zOcovkjJnKhoo9iStnpFF2cwARAQABtCdKb25hdGhhbiBT LiBLYXR6IDxqa2F0ekBwb3N0Z3Jlc3FsLm9yZz6JAlQEEwEIAD4CGwMFCQeGH4AFCwkIBwIG FQoJCAsCBBYCAwECHgECF4AWIQT6hLaVryv3miBkP/HxBJxynxxlJwUCW1KJJQAKCRDxBJxy nxxlJwjrD/kBgqsW4QpNpTFw7ifRokZV08CCX4huPBJQ91rrv+UEWlEcotFBHVkYyHnpzARl tcZxhJ9CbFxjniH9cOTty5T/O1yolbOHtZSW8Z8aWV6BVEbjMb+BFxSSLm7RnvJdzQbGCZq2 ZZvfVpB6z3EHYph4KDdVKvMFjoLskxmdS1DE0tE3zTxvoQsi24Q+HOS07kUjs6fsu/WICMfz mgO++AWG9Y0CvN0mm4TkujESzyKM9E5irD+leEMIcddl51Aa2c/VMfBXQbRmpHIgUFTmuHQD CnQih+9i3OJAksDg66SP8a7yiXv5mwvyDi1EfTGVKYR2j+pwyjwnC3oIbvDMmB3uTn2JIjnT iZKPVtAcAylXjubFltihQgNyuShdP4W+kBwZizhUFqUVL8Anx+KoytYmJPfMRFLGuK4obXKq a2ZS3k9KB+H+isOx2nFJOsc7V360Zp1DVaNmuiK10TT6QndShSPaqkJqFtCb6r92rZ9sZM/L 3vtCI4Rrl3Pt1MgtENXupS8gZpJnAYS0j5A1PAZ09r6ANoaeMHspF+5J5fOHeEvqphXr36mm a83Vl1t4orPb0+QmmijmlpseDU63M88Aw5p3c4qj7t8Qr2EZ5zrn7/sFn5wOfbs8Nymxafif QCnlV2vg9p0m7vSk/yLJ4PFZvs52FgqAGRCdRn0s2EC99bkCDQRbUocAARAAv8ho/toQ9DG3 j4f9h9n1aRHr2FlviN2Utpy6L8+dfDggO0geilmkGQOolZ2E60gGfye/kUtF9W3NByO4hxDR 9u6qbOXcdqnuA+cc68EfqlWFJrVtYFxt0h4ElWYOYnIezKthriWch/FY70FGrxs3z8UHOHq5 0wBW433eTvZm90WixBiXEt2v1DgW4Vr3ymfO7Aap/IYyPuE4JzgudAuAl0HKPyNEHWHG1dAb jX1RiCw9gknIDWQOF0B4UAaJctWGVcnZ3A2ULwNGMa1P9ZJlBWf1vcj01aiHMU0yQ7JjJiSp vfm9eM0uSLwRdDrJjyl5ZZqVumjdv2SMNQ8GvYRbEMys3GGDSt9zXgfCSUnPnJfYxjzBHRI6 x44Wfsx8S6hWxepOogCJJ/g67Bk9mY8YV4klWIXDJVOL5jnBC09DbsZG81JaE2QxB8Y7W36Z Mroi9XMxg3s805hQAQUvdG/poU8hN8BWdrnTm/+4eQQp7gDY1ePDmGM6bJC+OHOSnFtR/f+7 0zpKJ10cc7cBygGnl1yR3KjhFyAWUFvP4ZGziKCcpMwXZfe9PGuyA/YOubMphxIn3YsK2wrd faKZYX2GMZCZhMMcvx9IpQrxIJgU+VlwXu/O+Lk10VIPcxPJJwmpdI6HzcS8ZgG6IMcC444X XTuLaP8j2mgcMvYak3ScCykAEQEAAYkCPAQYAQgAJhYhBPqEtpWvK/eaIGQ/8fEEnHKfHGUn BQJbUocAAhsMBQkHhh+AAAoJEPEEnHKfHGUnReMP/RA2UhGQj+G4uBshkRLjpRysabdPqgQB dEBk6wYbio88Wg/2/hgY7UzmDDEwX3sZfQDcrI6+vIobI8uqstZID+WgAAa1JLfChMyVQnSy 0zfWMOABXscc5tGuvFRZvJklTissMFjXUwaREEKp4ZikTvJ/62MCjSdtrUhnPLvoTsHTKRKD ichE+b5A54alwsubTijw12O6N22r5IjZiiSZV0u7dsShyKw+7wCSax9fuBoE43NMYf+dnjMK nerAQYUcZWYMnk+EC8RaqYAxv6XZ2tKx1AkGGktwkQIBwrz9IlDSvJ3LWJ2UIIuLRTdngNgg GIL4zzuUa2F56FqskQIuYMaNETk6LYfalBDQ6TVLAcgCPQxp4k4i/PRsZ3lZ2ZhRHRYciOvm kp+I6EfHwllQpYrWs1thluBGqlJSVJgKl0IOFvKLsQ6KKfqzAwh6FxrO5qajp4viNIgtWoFw O5Bp0jgFTbH2OrMWIRfUdUCH1Djbuo65svhNj7FNsQVYzHDI+Nd1I/LOBoPc3UorRMF2M4JV kUR7skOHWUbPTSNUr7qc14NSMY3PKjGeVGAsBVHBPvmRx/Ss2tW/TpJWpxg4pmquFQSXuaYh Yf4FN8Sxy320pcr+FqN8AhZkYJcNY82OTtR5VEKRC/mYcyq61qXIKqngydn79bJjGxHipxyF FmEC Message-ID: <627584c3-d4fe-7a04-feb5-210b08642284@postgresql.org> Date: Thu, 25 Apr 2019 17:58:04 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 In-Reply-To: <6bd15afe-69ea-33b7-379a-f71fda68b427@postgresql.org> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="sW4hKGc9EicYhjXg8lofQz5s7NY70jCyA" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --sW4hKGc9EicYhjXg8lofQz5s7NY70jCyA Content-Type: multipart/mixed; boundary="Ig5bhfmfl0w6LRVLT4f23rn9GgZDTdtKv"; protected-headers="v1" From: "Jonathan S. Katz" To: Joe Conway , Stephen Frost , Tom Lane Cc: Steven Winfield , "pgsql-docs@lists.postgresql.org" , "Jonathan S. Katz" Message-ID: <627584c3-d4fe-7a04-feb5-210b08642284@postgresql.org> Subject: Re: SET ROLE documentation not entirely correct References: <155603476764.1372.10888362840885095061@wrigleys.postgresql.org> <03796ce5-8366-cd32-0436-9981ffbeb993@joeconway.com> <67c97dbc-9caf-aa7e-622a-e20b28b7e597@joeconway.com> <02e17cb3-f8a9-234f-f3ce-2b80bc49031d@joeconway.com> <26109.1556217198@sss.pgh.pa.us> <20190425190626.GY6197@tamriel.snowman.net> <97c6e8d5-7e51-5cd2-4fc2-652ad02659d9@joeconway.com> <6bd15afe-69ea-33b7-379a-f71fda68b427@postgresql.org> In-Reply-To: <6bd15afe-69ea-33b7-379a-f71fda68b427@postgresql.org> --Ig5bhfmfl0w6LRVLT4f23rn9GgZDTdtKv Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable On 4/25/19 5:22 PM, Jonathan S. Katz wrote: > On 4/25/19 4:52 PM, Jonathan S. Katz wrote: >> On 4/25/19 3:20 PM, Joe Conway wrote: >>> On 4/25/19 3:06 PM, Stephen Frost wrote: >>>> Greetings, >>>> >>>> * Tom Lane (tgl@sss.pgh.pa.us) wrote: >>>>> Joe Conway writes: >>>>>> On 4/25/19 1:08 PM, Joe Conway wrote: >>>>>>> There is one image which can be used as an example though: >>>>>>> https://git.postgresql.org/gitweb/?p=3Dpostgresql.git;a=3Dblob;f=3D= doc/src/sgml/storage.sgml;hb=3DHEAD >>>>> >>>>>> Here is a more precise URL: >>>>>> https://git.postgresql.org/gitweb/?p=3Dpostgresql.git;a=3Dblob;f=3D= doc/src/sgml/storage.sgml;hb=3DHEAD#l934 >>>>> >>>>> Comparing that to what I see at >>>>> >>>>> https://www.postgresql.org/docs/devel/storage-page-layout.html >>>>> >>>>> does not lead to a warm feeling about our images-in-docs stuff >>>>> really being ready for prime time. It works OK in some browsers >>>>> but others (at least Safari) cut off the image. >>>> >>>> Yeah, I'm seeing it cut off in Chrome too, initially, and then it se= ems >>>> to fix itself if I resize the window down from 4k (and stay fixed ev= en >>>> if I then go back to the original, much larger, size). That seems l= ike >>>> a CSS or layout issue though, not an issue with the image itself..? >>> >>> >>> Yeah, I see the same thing in Chrome -- maybe Jonathan has an idea wh= at >>> is going on and how to best fix it? >> >> See[1] - I'm not sure if the final piece is committed -- if when it is= I >> can finish fixing the pgweb part > OK, so I took a quick look at the existing SVGs with my patched version= > of pgweb. >=20 > The short answer is that it's better: the SVGs are not responsive, but > they are displaying. There still needs to be work on the SVGs as > indicated in that thread to make them responsive[1]. >=20 > With that said, the pgweb patch does fix their current display at least= > in full view, so I pushed the current patch to pgweb to do that. The fi= x > will take effect the next time the nightly docload runs, or if someone > on pginfra forces it to occur more quickly. Good news - I did test against an older snapshot. With a newer snapshot, the SVG on the GIN implementation page[1] is responsive but not the one on the storage page layout[2], which is what the proposed fix in the other thread handles. Jonathan [1] https://www.postgresql.org/docs/devel/gin-implementation.html [2] https://www.postgresql.org/docs/devel/storage-page-layout.html --Ig5bhfmfl0w6LRVLT4f23rn9GgZDTdtKv-- --sW4hKGc9EicYhjXg8lofQz5s7NY70jCyA Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAlzCLWwACgkQ8QSccp8c ZSeqXxAAi97HCAe2jCjfHSLrmXr0In5ga8HEVO3TIIQSlrOa4MquNTWt8jLedew4 Cksbd4IUXQZYVumiUIAcUAy5IAMW6icaPd+/1PI2n4fEs0M3AwtxbxVsro/SpQ+E ewfVgwxjN/DDy2UWteWOvR3tFg6Yyq82oSBjQfzNKFLT+fvf2ZxjzfNeKFkKk194 jE7VMc07PoywbiGaQEvHXhdqodh5Cj1OiWtvz4ZbGD+MIgyzgQq9vo8aieL59BET t5Kh6G/+gurgYhClNPSMy7tSAHCjHBjMQKb5b/TCp+L70cBOMj1jqk7HFVvFm2jN yV7FGYPRuuyoNTCC9OM/dQM++/ztNPjhqe3GVR8mO6k59YmgIrByTsuNeJpz5odE lbl2UYJIw+5TJSUq82AwX5aGCHXXR+mzagXTr2OCTDtO81RHYILOfWDnw+FKAB2X xUPfejMHVaDMXhj2EvdS4QcOakvnl1BG9hUBv7kt4wnq8kzsWS7cCbSQ6dShHd9l rPDPQpYzGDfTleGCxQbOkRrk6/RiG6T5/92HCrImKnvUDvLoQ33s7iM6qsl+1z8o ABLj1D5vAzUTTlL8lhQG7fJf43BmTLWjexBvoqqL1dRi/gdk91hy0JA9JGnCEbf5 IDj36VZckRVdFsDTpF/325euSp+kIF98x3IXYRRrF9CAT+HXI04= =xFU7 -----END PGP SIGNATURE----- --sW4hKGc9EicYhjXg8lofQz5s7NY70jCyA--