From f21599311e50a43c90a3d33ef4f60193a774321a Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 6 May 2020 12:23:43 -0400 Subject: [PATCH] Doc: further fooling-about with rendering of tables in PDF output. I concluded that we really just ought to force all tables in PDF output to default to "left" alignment (instead of "justify"); that is what the HTML toolchain does and that's what most people have been designing the tables to look good with. There are few if any places where "justify" produces better-looking output, and there are many where it looks horrible. So change stylesheet-fo.xsl to make that true. Also tweak column widths in a few more tables to make them look better and avoid "exceed the available area" warnings. This commit fixes basically everything that can be fixed through that approach. The remaining tables that give warnings either are scheduled for redesign as per recent discussions, or need a fundamental rethink because they Just Don't Work in a narrow view. --- doc/src/sgml/brin.sgml | 8 ++ doc/src/sgml/config.sgml | 8 +- doc/src/sgml/datatype.sgml | 67 +++++++-- doc/src/sgml/ddl.sgml | 7 + doc/src/sgml/event-trigger.sgml | 232 ++++++++++++++++---------------- doc/src/sgml/extend.sgml | 3 + doc/src/sgml/json.sgml | 7 + doc/src/sgml/libpq.sgml | 4 + doc/src/sgml/monitoring.sgml | 13 ++ doc/src/sgml/mvcc.sgml | 7 +- doc/src/sgml/plpgsql.sgml | 6 + doc/src/sgml/runtime.sgml | 3 + doc/src/sgml/stylesheet-fo.xsl | 5 + doc/src/sgml/syntax.sgml | 3 + doc/src/sgml/textsearch.sgml | 3 + doc/src/sgml/user-manag.sgml | 2 + doc/src/sgml/xfunc.sgml | 3 + doc/src/sgml/xindex.sgml | 16 +++ 18 files changed, 269 insertions(+), 128 deletions(-) diff --git a/doc/src/sgml/brin.sgml b/doc/src/sgml/brin.sgml index 176f1cfbd06..46a7d07bf8b 100644 --- a/doc/src/sgml/brin.sgml +++ b/doc/src/sgml/brin.sgml @@ -121,6 +121,9 @@ LOG: request for BRIN range summarization for index "brin_wi_idx" page 128 was Built-in <acronym>BRIN</acronym> Operator Classes + + + Name @@ -587,6 +590,8 @@ typedef struct BrinOpcInfo
Function and Support Numbers for Minmax Operator Classes + + Operator class member @@ -648,6 +653,9 @@ typedef struct BrinOpcInfo
Function and Support Numbers for Inclusion Operator Classes + + + Operator class member diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 48d1c8d6414..3aea1763b48 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -6258,6 +6258,10 @@ local0.* /var/log/postgresql
Message Severity Levels + + + + Severity @@ -6269,7 +6273,7 @@ local0.* /var/log/postgresql - DEBUG1..DEBUG5 + DEBUG1 .. DEBUG5 Provides successively-more-detailed information for use by developers. DEBUG @@ -10288,6 +10292,8 @@ LOG: CleanUpLock: deleting: lock(0xb7acd844) id(24688,24696,0,0,0,1)
Short Option Key + + Short Option diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 22eda0f4e9e..a8d07803879 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -31,6 +31,9 @@
Data Types + + + Name @@ -349,6 +352,10 @@
Numeric Types + + + + Name @@ -965,6 +972,10 @@ ALTER SEQUENCE tablename_ Monetary Types + + + + Name @@ -1299,6 +1310,9 @@ SELECT b, char_length(b) FROM test2;
Binary Data Types + + + Name @@ -1415,6 +1429,11 @@ SELECT '\xDEADBEEF';
<type>bytea</type> Literal Escaped Octets + + + + + Decimal Octet Value @@ -1430,7 +1449,7 @@ SELECT '\xDEADBEEF'; 0 zero octet '\000' - SELECT '\000'::bytea; + '\000'::bytea \x00 @@ -1438,7 +1457,7 @@ SELECT '\xDEADBEEF'; 39single quote'''' or '\047' - SELECT ''''::bytea; + ''''::bytea\x27 @@ -1446,7 +1465,7 @@ SELECT '\xDEADBEEF'; 92backslash'\\' or '\134' - SELECT '\\'::bytea; + '\\'::bytea\x5c @@ -1454,7 +1473,7 @@ SELECT '\xDEADBEEF'; 0 to 31 and 127 to 255non-printable octets'\xxx' (octal value) - SELECT '\001'::bytea; + '\001'::bytea\x01 @@ -1514,6 +1533,11 @@ SELECT 'abc \153\154\155 \052\251\124'::bytea;
<type>bytea</type> Output Escaped Octets + + + + + Decimal Octet Value @@ -1530,7 +1554,7 @@ SELECT 'abc \153\154\155 \052\251\124'::bytea; 92 backslash \\ - SELECT '\134'::bytea; + '\134'::bytea \\ @@ -1538,7 +1562,7 @@ SELECT 'abc \153\154\155 \052\251\124'::bytea; 0 to 31 and 127 to 255non-printable octets\xxx (octal value) - SELECT '\001'::bytea; + '\001'::bytea\001 @@ -1546,7 +1570,7 @@ SELECT 'abc \153\154\155 \052\251\124'::bytea; 32 to 126printable octetsclient character set representation - SELECT '\176'::bytea; + '\176'::bytea~ @@ -1789,6 +1813,8 @@ MINUTE TO SECOND
Date Input + + Example @@ -1910,6 +1936,8 @@ MINUTE TO SECOND
Time Input + + Example @@ -2252,6 +2280,9 @@ January 8 04:05:06 1999 PST
Date/Time Output Styles + + + Style Specification @@ -2306,6 +2337,9 @@ January 8 04:05:06 1999 PST
Date Order Conventions + + + datestyle Setting @@ -2721,23 +2755,23 @@ P years-months- - 1-2 + 1-2 SQL standard format: 1 year 2 months - 3 4:05:06 + 3 4:05:06 SQL standard format: 3 days 4 hours 5 minutes 6 seconds - 1 year 2 months 3 days 4 hours 5 minutes 6 seconds + 1 year 2 months 3 days 4 hours 5 minutes 6 seconds Traditional Postgres format: 1 year 2 months 3 days 4 hours 5 minutes 6 seconds - P1Y2M3DT4H5M6S + P1Y2M3DT4H5M6S ISO 8601 format with designators: same meaning as above - P0001-02-03T04:05:06 + P0001-02-03T04:05:06 ISO 8601 alternative format: same meaning as above @@ -3159,6 +3193,10 @@ SELECT person.name, holidays.num_weeks FROM person, holidays
Geometric Types + + + + Name @@ -3485,6 +3523,9 @@ SELECT person.name, holidays.num_weeks FROM person, holidays
Network Address Types + + + Name @@ -4897,6 +4938,8 @@ SELECT * FROM pg_attribute
Pseudo-Types + + Name diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index 2a478c4f731..aae5d320309 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -1882,6 +1882,9 @@ REVOKE ALL ON accounts FROM PUBLIC;
ACL Privilege Abbreviations + + + Privilege @@ -1987,6 +1990,10 @@ REVOKE ALL ON accounts FROM PUBLIC;
Summary of Access Privileges + + + + Object Type diff --git a/doc/src/sgml/event-trigger.sgml b/doc/src/sgml/event-trigger.sgml index 130f6cd886a..60366a950ec 100644 --- a/doc/src/sgml/event-trigger.sgml +++ b/doc/src/sgml/event-trigger.sgml @@ -132,13 +132,19 @@
Event Trigger Support by Command Tag + + + + + + Command Tag - ddl_command_start - ddl_command_end - sql_drop - table_rewrite + ddl_&zwsp;command_&zwsp;start + ddl_&zwsp;command_&zwsp;end + sql_&zwsp;drop + table_&zwsp;rewrite Notes @@ -149,7 +155,7 @@ X-- - + ALTER COLLATION @@ -157,7 +163,7 @@ X - - - + ALTER CONVERSION @@ -165,7 +171,7 @@ X - - - + ALTER DOMAIN @@ -173,7 +179,7 @@ X - - - + ALTER DEFAULT PRIVILEGES @@ -181,7 +187,7 @@ X - - - + ALTER EXTENSION @@ -189,7 +195,7 @@ X - - - + ALTER FOREIGN DATA WRAPPER @@ -197,7 +203,7 @@ X - - - + ALTER FOREIGN TABLE @@ -205,7 +211,7 @@ X X - - + ALTER FUNCTION @@ -213,7 +219,7 @@ X - - - + ALTER LANGUAGE @@ -221,7 +227,7 @@ X - - - + ALTER LARGE OBJECT @@ -229,7 +235,7 @@ X - - - + ALTER MATERIALIZED VIEW @@ -237,7 +243,7 @@ X - - - + ALTER OPERATOR @@ -245,7 +251,7 @@ X - - - + ALTER OPERATOR CLASS @@ -253,7 +259,7 @@ X - - - + ALTER OPERATOR FAMILY @@ -261,7 +267,7 @@ X - - - + ALTER POLICY @@ -269,7 +275,7 @@ X - - - + ALTER PROCEDURE @@ -277,7 +283,7 @@ X - - - + ALTER PUBLICATION @@ -285,7 +291,7 @@ X - - - + ALTER SCHEMA @@ -293,7 +299,7 @@ X - - - + ALTER SEQUENCE @@ -301,7 +307,7 @@ X - - - + ALTER SERVER @@ -309,7 +315,7 @@ X - - - + ALTER STATISTICS @@ -317,7 +323,7 @@ X - - - + ALTER SUBSCRIPTION @@ -325,7 +331,7 @@ X - - - + ALTER TABLE @@ -333,7 +339,7 @@ X X X - + ALTER TEXT SEARCH CONFIGURATION @@ -341,7 +347,7 @@ X - - - + ALTER TEXT SEARCH DICTIONARY @@ -349,7 +355,7 @@ X - - - + ALTER TEXT SEARCH PARSER @@ -357,7 +363,7 @@ X - - - + ALTER TEXT SEARCH TEMPLATE @@ -365,7 +371,7 @@ X - - - + ALTER TRIGGER @@ -373,7 +379,7 @@ X - - - + ALTER TYPE @@ -381,7 +387,7 @@ X - X - + ALTER USER MAPPING @@ -389,7 +395,7 @@ X - - - + ALTER VIEW @@ -397,7 +403,7 @@ X - - - + COMMENT @@ -405,7 +411,7 @@ X - - - Only for local objects + Only for local objects CREATE ACCESS METHOD @@ -413,7 +419,7 @@ X - - - + CREATE AGGREGATE @@ -421,7 +427,7 @@ X - - - + CREATE CAST @@ -429,7 +435,7 @@ X - - - + CREATE COLLATION @@ -437,7 +443,7 @@ X - - - + CREATE CONVERSION @@ -445,7 +451,7 @@ X - - - + CREATE DOMAIN @@ -453,7 +459,7 @@ X - - - + CREATE EXTENSION @@ -461,7 +467,7 @@ X - - - + CREATE FOREIGN DATA WRAPPER @@ -469,7 +475,7 @@ X - - - + CREATE FOREIGN TABLE @@ -477,7 +483,7 @@ X - - - + CREATE FUNCTION @@ -485,7 +491,7 @@ X - - - + CREATE INDEX @@ -493,7 +499,7 @@ X - - - + CREATE LANGUAGE @@ -501,7 +507,7 @@ X - - - + CREATE MATERIALIZED VIEW @@ -509,7 +515,7 @@ X - - - + CREATE OPERATOR @@ -517,7 +523,7 @@ X - - - + CREATE OPERATOR CLASS @@ -525,7 +531,7 @@ X - - - + CREATE OPERATOR FAMILY @@ -533,7 +539,7 @@ X - - - + CREATE POLICY @@ -541,7 +547,7 @@ X - - - + CREATE PROCEDURE @@ -549,7 +555,7 @@ X - - - + CREATE PUBLICATION @@ -557,7 +563,7 @@ X - - - + CREATE RULE @@ -565,7 +571,7 @@ X - - - + CREATE SCHEMA @@ -573,7 +579,7 @@ X - - - + CREATE SEQUENCE @@ -581,7 +587,7 @@ X - - - + CREATE SERVER @@ -589,7 +595,7 @@ X - - - + CREATE STATISTICS @@ -597,7 +603,7 @@ X - - - + CREATE SUBSCRIPTION @@ -605,7 +611,7 @@ X - - - + CREATE TABLE @@ -613,7 +619,7 @@ X - - - + CREATE TABLE AS @@ -621,7 +627,7 @@ X - - - + CREATE TEXT SEARCH CONFIGURATION @@ -629,7 +635,7 @@ X - - - + CREATE TEXT SEARCH DICTIONARY @@ -637,7 +643,7 @@ X - - - + CREATE TEXT SEARCH PARSER @@ -645,7 +651,7 @@ X - - - + CREATE TEXT SEARCH TEMPLATE @@ -653,7 +659,7 @@ X - - - + CREATE TRIGGER @@ -661,7 +667,7 @@ X - - - + CREATE TYPE @@ -669,7 +675,7 @@ X - - - + CREATE USER MAPPING @@ -677,7 +683,7 @@ X - - - + CREATE VIEW @@ -685,7 +691,7 @@ X - - - + DROP ACCESS METHOD @@ -693,7 +699,7 @@ X X - - + DROP AGGREGATE @@ -701,7 +707,7 @@ X X - - + DROP CAST @@ -709,7 +715,7 @@ X X - - + DROP COLLATION @@ -717,7 +723,7 @@ X X - - + DROP CONVERSION @@ -725,7 +731,7 @@ X X - - + DROP DOMAIN @@ -733,7 +739,7 @@ X X - - + DROP EXTENSION @@ -741,7 +747,7 @@ X X - - + DROP FOREIGN DATA WRAPPER @@ -749,7 +755,7 @@ X X - - + DROP FOREIGN TABLE @@ -757,7 +763,7 @@ X X - - + DROP FUNCTION @@ -765,7 +771,7 @@ X X - - + DROP INDEX @@ -773,7 +779,7 @@ X X - - + DROP LANGUAGE @@ -781,7 +787,7 @@ X X - - + DROP MATERIALIZED VIEW @@ -789,7 +795,7 @@ X X - - + DROP OPERATOR @@ -797,7 +803,7 @@ X X - - + DROP OPERATOR CLASS @@ -805,7 +811,7 @@ X X - - + DROP OPERATOR FAMILY @@ -813,7 +819,7 @@ X X - - + DROP OWNED @@ -821,7 +827,7 @@ X X - - + DROP POLICY @@ -829,7 +835,7 @@ X X - - + DROP PROCEDURE @@ -837,7 +843,7 @@ X X - - + DROP PUBLICATION @@ -845,7 +851,7 @@ X X - - + DROP RULE @@ -853,7 +859,7 @@ X X - - + DROP SCHEMA @@ -861,7 +867,7 @@ X X - - + DROP SEQUENCE @@ -869,7 +875,7 @@ X X - - + DROP SERVER @@ -877,7 +883,7 @@ X X - - + DROP STATISTICS @@ -885,7 +891,7 @@ X X - - + DROP SUBSCRIPTION @@ -893,7 +899,7 @@ X X - - + DROP TABLE @@ -901,7 +907,7 @@ X X - - + DROP TEXT SEARCH CONFIGURATION @@ -909,7 +915,7 @@ X X - - + DROP TEXT SEARCH DICTIONARY @@ -917,7 +923,7 @@ X X - - + DROP TEXT SEARCH PARSER @@ -925,7 +931,7 @@ X X - - + DROP TEXT SEARCH TEMPLATE @@ -933,7 +939,7 @@ X X - - + DROP TRIGGER @@ -941,7 +947,7 @@ X X - - + DROP TYPE @@ -949,7 +955,7 @@ X X - - + DROP USER MAPPING @@ -957,7 +963,7 @@ X X - - + DROP VIEW @@ -965,7 +971,7 @@ X X - - + GRANT @@ -973,7 +979,7 @@ X - - - Only for local objects + Only for local objects IMPORT FOREIGN SCHEMA @@ -981,7 +987,7 @@ X - - - + REFRESH MATERIALIZED VIEW @@ -989,7 +995,7 @@ X - - - + REVOKE @@ -997,7 +1003,7 @@ X - - - Only for local objects + Only for local objects SECURITY LABEL @@ -1005,7 +1011,7 @@ X - - - Only for local objects + Only for local objects SELECT INTO @@ -1013,7 +1019,7 @@ X - - - + diff --git a/doc/src/sgml/extend.sgml b/doc/src/sgml/extend.sgml index 930aeb767c3..c1ffb145710 100644 --- a/doc/src/sgml/extend.sgml +++ b/doc/src/sgml/extend.sgml @@ -242,6 +242,9 @@
Polymorphic Types + + + Name diff --git a/doc/src/sgml/json.sgml b/doc/src/sgml/json.sgml index 05ecb99c5dd..c0a6554d4d7 100644 --- a/doc/src/sgml/json.sgml +++ b/doc/src/sgml/json.sgml @@ -132,6 +132,9 @@
JSON Primitive Types and Corresponding <productname>PostgreSQL</productname> Types + + + JSON primitive type @@ -742,6 +745,8 @@ SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @> '{"tags": ["qu
<type>jsonpath</type> Variables + + Variable @@ -777,6 +782,8 @@ SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @> '{"tags": ["qu
<type>jsonpath</type> Accessors + + Accessor Operator diff --git a/doc/src/sgml/libpq.sgml b/doc/src/sgml/libpq.sgml index 5ddb4c28bde..5892367c61c 100644 --- a/doc/src/sgml/libpq.sgml +++ b/doc/src/sgml/libpq.sgml @@ -7763,6 +7763,10 @@ ldap://ldap.acme.com/cn=dbserver,cn=hosts?pgconnectinfo?base?(objectclass=*)
SSL Mode Descriptions + + + + sslmode diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 252300db14b..842e553e1ec 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -3784,6 +3784,8 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS pid,
ANALYZE phases + + Phase @@ -3988,6 +3990,8 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS pid,
CREATE INDEX Phases + + Phase @@ -4217,6 +4221,8 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS pid,
VACUUM Phases + + Phase @@ -4411,6 +4417,8 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS pid,
CLUSTER and VACUUM FULL Phases + + Phase @@ -4559,6 +4567,8 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS pid,
Base backup phases + + Phase @@ -4686,6 +4696,9 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS pid,
Built-in DTrace Probes + + + Name diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml index ecff9474c8e..3f6c2316112 100644 --- a/doc/src/sgml/mvcc.sgml +++ b/doc/src/sgml/mvcc.sgml @@ -1289,8 +1289,11 @@ ERROR: could not serialize access due to read/write dependencies among transact
Conflicting Row-Level Locks - - + + + + + diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index cc99acad31f..05d2705604b 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -1493,6 +1493,9 @@ GET DIAGNOSTICS integer_var = ROW_COUNT;
Available Diagnostics Items + + + Name @@ -2820,6 +2823,9 @@ GET STACKED DIAGNOSTICS variable { = | := } Error Diagnostics Items + + + Name diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index a34d31d297a..a8bb85e6f5a 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -709,6 +709,9 @@ psql: could not connect to server: No such file or directory <systemitem class="osname">System V</systemitem> <acronym>IPC</acronym> Parameters + + + Name diff --git a/doc/src/sgml/stylesheet-fo.xsl b/doc/src/sgml/stylesheet-fo.xsl index fe2a06a26a1..5a2734649e9 100644 --- a/doc/src/sgml/stylesheet-fo.xsl +++ b/doc/src/sgml/stylesheet-fo.xsl @@ -32,6 +32,11 @@ center + + + left + + diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index e1348777982..f5ce6f0149f 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -1004,6 +1004,9 @@ SELECT (5 !) - 6; Operator Precedence (highest to lowest) + + + Operator/Element diff --git a/doc/src/sgml/textsearch.sgml b/doc/src/sgml/textsearch.sgml index 187ff22f3ea..e3b70df6ebc 100644 --- a/doc/src/sgml/textsearch.sgml +++ b/doc/src/sgml/textsearch.sgml @@ -2074,6 +2074,9 @@ LIMIT 10;
Default Parser's Token Types + + + Alias diff --git a/doc/src/sgml/user-manag.sgml b/doc/src/sgml/user-manag.sgml index 66f162703dd..829decd8839 100644 --- a/doc/src/sgml/user-manag.sgml +++ b/doc/src/sgml/user-manag.sgml @@ -508,6 +508,8 @@ DROP ROLE doomed_role;
Default Roles + + Role diff --git a/doc/src/sgml/xfunc.sgml b/doc/src/sgml/xfunc.sgml index 0bec854d04b..6de464c6545 100644 --- a/doc/src/sgml/xfunc.sgml +++ b/doc/src/sgml/xfunc.sgml @@ -2084,6 +2084,9 @@ memcpy(destination->data, buffer, 40);
Equivalent C Types for Built-in SQL Types + + + diff --git a/doc/src/sgml/xindex.sgml b/doc/src/sgml/xindex.sgml index 2e06ad01bf5..14c1701c9b5 100644 --- a/doc/src/sgml/xindex.sgml +++ b/doc/src/sgml/xindex.sgml @@ -412,6 +412,8 @@
B-Tree Support Functions + + Function @@ -461,6 +463,8 @@
Hash Support Functions + + Function @@ -494,6 +498,9 @@
GiST Support Functions + + + Function @@ -566,6 +573,9 @@
SP-GiST Support Functions + + + Function @@ -614,6 +624,9 @@
GIN Support Functions + + + Function @@ -681,6 +694,9 @@
BRIN Support Functions + + + Function -- 2.39.5