Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jXqJH-0006K0-5J for pgsql-hackers@arkaria.postgresql.org; Sun, 10 May 2020 18:04:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jXqIk-0004NQ-4U for pgsql-hackers@arkaria.postgresql.org; Sun, 10 May 2020 18:03:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jXqIj-0004NF-AO; Sun, 10 May 2020 18:03:45 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jXqId-0002jS-Ob; Sun, 10 May 2020 18:03:44 +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:From:References:Cc:To:Subject:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=b+9UtvMV65nZHXK9IIBDwEZmMBKyMqEf5h76dSd3Qlg=; b=LWmkM8EWjwmTui4mOiFFr+VHC3 1VAHreNNOtWJOrW0GgCFq29YjIvTvsVJY7896z69N/m340XLY5PFhD+v2rqlU+0jRArts6LEqYHik fkeKl2FlN+kNkeP8oTWTLl9ZDKVl3dGbKxvudcIXQ2/UwB80jG1Kv7qWdhRk2Ks96Xt8pzg0FiNNm ATJ6gxogvMR+3F6WbTc8fXOtmGtcQLixCRBa7R1Z5nYkhDk6gmaqj5tdtPXBT+yAJOy1U4cT4fWcP wMxcnobmjiCxzeFHBYPgoPoebUHAuWPfFuNkweYqg7ZlT14ugaSqSSwi9SkQdWAFdiYyALT2a0A7S s3JjEu9Q==; Received: from pool-173-56-10-231.nycmny.fios.verizon.net ([173.56.10.231] helo=Ph33rHippo.local) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jXqIZ-0006RD-Vu; Sun, 10 May 2020 18:03:38 +0000 Subject: Re: Another modest proposal for docs formatting: catalog descriptions To: Tom Lane Cc: Fabien COELHO , Alvaro Herrera , pgsql-docs@lists.postgresql.org, PostgreSQL Developers References: <20200506213810.GA29168@alvherre.pgsql> <14800.1588805800@sss.pgh.pa.us> <23610.1588978416@sss.pgh.pa.us> <4521.1589038464@sss.pgh.pa.us> <3357.1589047741@sss.pgh.pa.us> <14810.1589128043@sss.pgh.pa.us> From: "Jonathan S. Katz" 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: <8cfed3a2-0850-6aca-8771-3c50dfb651b4@postgresql.org> Date: Sun, 10 May 2020 14:03:32 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:68.0) Gecko/20100101 Thunderbird/68.8.0 MIME-Version: 1.0 In-Reply-To: <14810.1589128043@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="f4GKqZ3XFLhIVOsOWmYUZ1vtOksbc2sEJ" 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) --f4GKqZ3XFLhIVOsOWmYUZ1vtOksbc2sEJ Content-Type: multipart/mixed; boundary="wxUGvmjCvzmIdQmY74gz5KDtGMm1L8Sbr" --wxUGvmjCvzmIdQmY74gz5KDtGMm1L8Sbr Content-Type: text/plain; charset=windows-1252 Content-Language: en-US Content-Transfer-Encoding: quoted-printable On 5/10/20 12:27 PM, Tom Lane wrote: > Just FTR, here's a complete patch for this.=20 Cool. I'll play around with it tonight once I clear out release work. Per upthread reference, I believe you've become a CSS maven yourself. > I successfully regenerated > the column names, types, and ordering from the system catalogs, and > plugged the descriptions back into that by dint of parsing them out of > the XML. The "references" data was based on findoidjoins' results plus= > hand additions to cover all the cases we are calling out now (there are= > a lot of "references" links for attnums and a few other non-OID columns= , > plus references links for views which findoidjoins doesn't consider). > So I have pretty high confidence that this info is OK. I'd be too > embarrassed to show anybody the code though ;-) ... it was just a brute= > force hack. If it works it works ;) Jonathan --wxUGvmjCvzmIdQmY74gz5KDtGMm1L8Sbr-- --f4GKqZ3XFLhIVOsOWmYUZ1vtOksbc2sEJ Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAl64QfQACgkQ8QSccp8c ZSddJA//W3TUeuS+l278DgX983bRdIBw1nV+w1M7sGsa0G6UtSKsluZqE8iOYUgJ VHZd2TCvXtpZbyc+COzR2BptMGNfiKNJq+QokPuiiBsiE8UUair8+SQpdyKqW/os izrTLWX3xKzdRWlNqCyix+/v75ot2C3eAH5qAj2Ptzh/w/yQ7jyFgi3UAeJA3fE/ a1eGx+kRs1swxq9OozVKm+/h+he9V7PsTFlCrVD+0aev9UXSUPohE6THBx/y7YoI Rt2272Btgx+yU6zIHkwLSX4S7eo5yBo4CpJGB8TY09m0trH+cYZI2OZLSQL/bxBx cjq2+G927PBHbxgu2726aATRkvJ1vuoHHqCffa6+ylkxkPxtwvAy7IXcfaDkm6a5 0ruQERf91v/2hJKKlIlKXaQJVteWU00oakjPwdsNqPbg+ysQkrkug1GExzUTENrn Yr/C3tg9zxyitnb90BqtNpP5amCxqWbnuX7m4Nzl90slRwW7Mp4nOqaFWxvvcW81 0j9Bhbl77a6/yJ/jaC7GYTFuFEl6EK1kkavqGsQI1meRXdatOnnOzyyxFXigTFke wkVxcT2WAoC+CdHtPSacMotp/t6qhWl3uHvFmMtCObcEzGJdnp3j/7JAlNEGbWuE vpIq2RUdfYAdXvQrfmL0w2PG8ifMHaYh97f4/Y/+5sUsAeFSAsQ= =HbyD -----END PGP SIGNATURE----- --f4GKqZ3XFLhIVOsOWmYUZ1vtOksbc2sEJ--