From 6ef24487967692604b07a4a54e71821a60fb729a Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Sun, 7 Aug 2011 10:49:45 +0300 Subject: Fix a whitespace issue with the man pages There is what may actually be a mistake in our markup. The problem is in a situation like FOO is ... there is strictly speaking a line break before "FOO". In the HTML output, this does not appear to be a problem, but in the man page output, this shows up, so you get double blank lines at odd places. So far, we have attempted to work around this with an XSL hack, but that causes other problems, such as creating run-ins in places like SQL COPY So fix the problem properly by removing the extra whitespace. I only fixed the problems that affect the man page output, not all the places. --- doc/src/sgml/dblink.sgml | 6 ++-- doc/src/sgml/ref/abort.sgml | 3 +- doc/src/sgml/ref/alter_aggregate.sgml | 3 +- doc/src/sgml/ref/alter_collation.sgml | 3 +- doc/src/sgml/ref/alter_conversion.sgml | 3 +- doc/src/sgml/ref/alter_database.sgml | 3 +- doc/src/sgml/ref/alter_default_privileges.sgml | 3 +- doc/src/sgml/ref/alter_domain.sgml | 3 +- doc/src/sgml/ref/alter_extension.sgml | 3 +- doc/src/sgml/ref/alter_foreign_data_wrapper.sgml | 3 +- doc/src/sgml/ref/alter_foreign_table.sgml | 3 +- doc/src/sgml/ref/alter_function.sgml | 3 +- doc/src/sgml/ref/alter_group.sgml | 4 +-- doc/src/sgml/ref/alter_index.sgml | 3 +- doc/src/sgml/ref/alter_operator.sgml | 3 +- doc/src/sgml/ref/alter_role.sgml | 3 +- doc/src/sgml/ref/alter_sequence.sgml | 3 +- doc/src/sgml/ref/alter_server.sgml | 3 +- doc/src/sgml/ref/alter_table.sgml | 3 +- doc/src/sgml/ref/alter_tablespace.sgml | 3 +- doc/src/sgml/ref/alter_trigger.sgml | 3 +- doc/src/sgml/ref/alter_type.sgml | 3 +- doc/src/sgml/ref/alter_user_mapping.sgml | 3 +- doc/src/sgml/ref/alter_view.sgml | 3 +- doc/src/sgml/ref/begin.sgml | 3 +- doc/src/sgml/ref/close.sgml | 3 +- doc/src/sgml/ref/cluster.sgml | 3 +- doc/src/sgml/ref/clusterdb.sgml | 3 +- doc/src/sgml/ref/comment.sgml | 3 +- doc/src/sgml/ref/commit.sgml | 3 +- doc/src/sgml/ref/commit_prepared.sgml | 3 +- doc/src/sgml/ref/copy.sgml | 9 ++---- doc/src/sgml/ref/create_conversion.sgml | 6 ++-- doc/src/sgml/ref/create_domain.sgml | 6 ++-- doc/src/sgml/ref/create_extension.sgml | 3 +- doc/src/sgml/ref/create_foreign_data_wrapper.sgml | 9 ++---- doc/src/sgml/ref/create_foreign_table.sgml | 3 +- doc/src/sgml/ref/create_function.sgml | 24 +++++--------- doc/src/sgml/ref/create_index.sgml | 3 +- doc/src/sgml/ref/create_language.sgml | 15 +++------ doc/src/sgml/ref/create_operator.sgml | 9 ++---- doc/src/sgml/ref/create_role.sgml | 6 ++-- doc/src/sgml/ref/create_rule.sgml | 6 ++-- doc/src/sgml/ref/create_schema.sgml | 3 +- doc/src/sgml/ref/create_sequence.sgml | 6 ++-- doc/src/sgml/ref/create_server.sgml | 3 +- doc/src/sgml/ref/create_table.sgml | 19 +++-------- doc/src/sgml/ref/create_table_as.sgml | 12 +++---- doc/src/sgml/ref/create_tablespace.sgml | 3 +- doc/src/sgml/ref/create_trigger.sgml | 9 ++---- doc/src/sgml/ref/create_user_mapping.sgml | 3 +- doc/src/sgml/ref/createdb.sgml | 3 +- doc/src/sgml/ref/declare.sgml | 6 ++-- doc/src/sgml/ref/delete.sgml | 3 +- doc/src/sgml/ref/discard.sgml | 3 +- doc/src/sgml/ref/do.sgml | 4 +-- doc/src/sgml/ref/drop_aggregate.sgml | 3 +- doc/src/sgml/ref/drop_cast.sgml | 3 +- doc/src/sgml/ref/drop_collation.sgml | 3 +- doc/src/sgml/ref/drop_conversion.sgml | 3 +- doc/src/sgml/ref/drop_domain.sgml | 3 +- doc/src/sgml/ref/drop_foreign_data_wrapper.sgml | 3 +- doc/src/sgml/ref/drop_foreign_table.sgml | 3 +- doc/src/sgml/ref/drop_function.sgml | 3 +- doc/src/sgml/ref/drop_index.sgml | 3 +- doc/src/sgml/ref/drop_language.sgml | 3 +- doc/src/sgml/ref/drop_operator.sgml | 3 +- doc/src/sgml/ref/drop_role.sgml | 3 +- doc/src/sgml/ref/drop_rule.sgml | 3 +- doc/src/sgml/ref/drop_schema.sgml | 3 +- doc/src/sgml/ref/drop_sequence.sgml | 3 +- doc/src/sgml/ref/drop_server.sgml | 3 +- doc/src/sgml/ref/drop_table.sgml | 3 +- doc/src/sgml/ref/drop_tablespace.sgml | 3 +- doc/src/sgml/ref/drop_trigger.sgml | 3 +- doc/src/sgml/ref/drop_type.sgml | 3 +- doc/src/sgml/ref/drop_user_mapping.sgml | 3 +- doc/src/sgml/ref/drop_view.sgml | 3 +- doc/src/sgml/ref/dropdb.sgml | 3 +- doc/src/sgml/ref/droplang.sgml | 3 +- doc/src/sgml/ref/dropuser.sgml | 3 +- doc/src/sgml/ref/ecpg-ref.sgml | 6 ++-- doc/src/sgml/ref/end.sgml | 3 +- doc/src/sgml/ref/fetch.sgml | 12 +++---- doc/src/sgml/ref/grant.sgml | 3 +- doc/src/sgml/ref/insert.sgml | 3 +- doc/src/sgml/ref/listen.sgml | 3 +- doc/src/sgml/ref/lock.sgml | 3 +- doc/src/sgml/ref/notify.sgml | 3 +- doc/src/sgml/ref/pg_basebackup.sgml | 3 +- doc/src/sgml/ref/pg_ctl-ref.sgml | 9 ++---- doc/src/sgml/ref/pg_dump.sgml | 8 ++--- doc/src/sgml/ref/pg_restore.sgml | 12 +++---- doc/src/sgml/ref/prepare_transaction.sgml | 3 +- doc/src/sgml/ref/psql-ref.sgml | 39 ++++++++--------------- doc/src/sgml/ref/reindex.sgml | 6 ++-- doc/src/sgml/ref/reindexdb.sgml | 3 +- doc/src/sgml/ref/reset.sgml | 3 +- doc/src/sgml/ref/revoke.sgml | 3 +- doc/src/sgml/ref/rollback.sgml | 3 +- doc/src/sgml/ref/rollback_prepared.sgml | 3 +- doc/src/sgml/ref/rollback_to.sgml | 3 +- doc/src/sgml/ref/security_label.sgml | 3 +- doc/src/sgml/ref/select.sgml | 33 +++++++------------ doc/src/sgml/ref/select_into.sgml | 3 +- doc/src/sgml/ref/set.sgml | 15 +++------ doc/src/sgml/ref/show.sgml | 6 ++-- doc/src/sgml/ref/truncate.sgml | 3 +- doc/src/sgml/ref/unlisten.sgml | 3 +- doc/src/sgml/ref/update.sgml | 3 +- doc/src/sgml/ref/vacuum.sgml | 3 +- doc/src/sgml/ref/vacuumdb.sgml | 3 +- doc/src/sgml/ref/values.sgml | 6 ++-- doc/src/sgml/spi.sgml | 31 +++++------------- doc/src/sgml/stylesheet-man.xsl | 13 -------- 115 files changed, 194 insertions(+), 413 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/dblink.sgml b/doc/src/sgml/dblink.sgml index 22551402e3d..9f4445b2c4c 100644 --- a/doc/src/sgml/dblink.sgml +++ b/doc/src/sgml/dblink.sgml @@ -76,8 +76,7 @@ dblink_connect(text connname, text connstr) returns text connstr - - libpq-style connection info string, for example + libpq-style connection info string, for example hostaddr=127.0.0.1 port=5432 dbname=mydb user=postgres password=mypasswd. For details see PQconnectdb in @@ -447,8 +446,7 @@ CREATE VIEW myremote_pg_proc AS AS t1(proname name, prosrc text); SELECT * FROM myremote_pg_proc WHERE proname LIKE 'bytea%'; - - + diff --git a/doc/src/sgml/ref/abort.sgml b/doc/src/sgml/ref/abort.sgml index 2bfc724be50..246e8f81268 100644 --- a/doc/src/sgml/ref/abort.sgml +++ b/doc/src/sgml/ref/abort.sgml @@ -75,8 +75,7 @@ ABORT [ WORK | TRANSACTION ] To abort all changes: ABORT; - - + diff --git a/doc/src/sgml/ref/alter_aggregate.sgml b/doc/src/sgml/ref/alter_aggregate.sgml index 618c432a794..26c5dc01756 100644 --- a/doc/src/sgml/ref/alter_aggregate.sgml +++ b/doc/src/sgml/ref/alter_aggregate.sgml @@ -125,8 +125,7 @@ ALTER AGGREGATE myavg(integer) OWNER TO joe; integer into schema myschema: ALTER AGGREGATE myavg(integer) SET SCHEMA myschema; - - + diff --git a/doc/src/sgml/ref/alter_collation.sgml b/doc/src/sgml/ref/alter_collation.sgml index 3aef656a0e9..ebb30b88607 100644 --- a/doc/src/sgml/ref/alter_collation.sgml +++ b/doc/src/sgml/ref/alter_collation.sgml @@ -104,8 +104,7 @@ ALTER COLLATION "de_DE" RENAME TO german; joe: ALTER COLLATION "en_US" OWNER TO joe; - - + diff --git a/doc/src/sgml/ref/alter_conversion.sgml b/doc/src/sgml/ref/alter_conversion.sgml index 4f2269b8499..4cc335b18e0 100644 --- a/doc/src/sgml/ref/alter_conversion.sgml +++ b/doc/src/sgml/ref/alter_conversion.sgml @@ -104,8 +104,7 @@ ALTER CONVERSION iso_8859_1_to_utf8 RENAME TO latin1_to_unicode; joe: ALTER CONVERSION iso_8859_1_to_utf8 OWNER TO joe; - - + diff --git a/doc/src/sgml/ref/alter_database.sgml b/doc/src/sgml/ref/alter_database.sgml index 5a975adf5c1..360732fd358 100644 --- a/doc/src/sgml/ref/alter_database.sgml +++ b/doc/src/sgml/ref/alter_database.sgml @@ -190,8 +190,7 @@ ALTER DATABASE name RESET ALL ALTER DATABASE test SET enable_indexscan TO off; - - + diff --git a/doc/src/sgml/ref/alter_default_privileges.sgml b/doc/src/sgml/ref/alter_default_privileges.sgml index cc4f3636a25..f7b52ef9d1a 100644 --- a/doc/src/sgml/ref/alter_default_privileges.sgml +++ b/doc/src/sgml/ref/alter_default_privileges.sgml @@ -187,8 +187,7 @@ ALTER DEFAULT PRIVILEGES IN SCHEMA myschema REVOKE INSERT ON TABLES FROM webuser ALTER DEFAULT PRIVILEGES FOR ROLE admin REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC; - - + diff --git a/doc/src/sgml/ref/alter_domain.sgml b/doc/src/sgml/ref/alter_domain.sgml index cf504c3bcc9..4f60fe334c0 100644 --- a/doc/src/sgml/ref/alter_domain.sgml +++ b/doc/src/sgml/ref/alter_domain.sgml @@ -270,8 +270,7 @@ ALTER DOMAIN zipcode DROP CONSTRAINT zipchk; To move the domain into a different schema: ALTER DOMAIN zipcode SET SCHEMA customers; - - + diff --git a/doc/src/sgml/ref/alter_extension.sgml b/doc/src/sgml/ref/alter_extension.sgml index 67e2c3be497..5341f53d06f 100644 --- a/doc/src/sgml/ref/alter_extension.sgml +++ b/doc/src/sgml/ref/alter_extension.sgml @@ -288,8 +288,7 @@ ALTER EXTENSION hstore SET SCHEMA utils; To add an existing function to the hstore extension: ALTER EXTENSION hstore ADD FUNCTION populate_record(anyelement, hstore); - - + diff --git a/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml b/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml index af56ed7561d..59cf9c65e77 100644 --- a/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml +++ b/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml @@ -141,8 +141,7 @@ ALTER FOREIGN DATA WRAPPER dbi OPTIONS (ADD foo '1', DROP 'bar'); to bob.myvalidator: ALTER FOREIGN DATA WRAPPER dbi VALIDATOR bob.myvalidator; - - + diff --git a/doc/src/sgml/ref/alter_foreign_table.sgml b/doc/src/sgml/ref/alter_foreign_table.sgml index a422c88a4f6..5c7a86fe87f 100644 --- a/doc/src/sgml/ref/alter_foreign_table.sgml +++ b/doc/src/sgml/ref/alter_foreign_table.sgml @@ -288,8 +288,7 @@ ALTER FOREIGN TABLE distributors ALTER COLUMN street SET NOT NULL; To change options of a foreign table: ALTER FOREIGN TABLE myschema.distributors OPTIONS (ADD opt1 'value', SET opt2, 'value2', DROP opt3 'value3'); - - + diff --git a/doc/src/sgml/ref/alter_function.sgml b/doc/src/sgml/ref/alter_function.sgml index 22233af4aad..acb3e4fb93f 100644 --- a/doc/src/sgml/ref/alter_function.sgml +++ b/doc/src/sgml/ref/alter_function.sgml @@ -153,8 +153,7 @@ ALTER FUNCTION name ( [ [ name SET SCHEMA serial, at 105: ALTER SEQUENCE serial RESTART WITH 105; - - + diff --git a/doc/src/sgml/ref/alter_server.sgml b/doc/src/sgml/ref/alter_server.sgml index ab4731a4349..c27b4c06a1c 100644 --- a/doc/src/sgml/ref/alter_server.sgml +++ b/doc/src/sgml/ref/alter_server.sgml @@ -100,8 +100,7 @@ ALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb'); change host option: ALTER SERVER foo VERSION '8.4' OPTIONS (SET host 'baz'); - - + diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 4c2a4cd22ec..0b1e0440d10 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1041,8 +1041,7 @@ ALTER TABLE myschema.distributors SET SCHEMA yourschema; CREATE UNIQUE INDEX CONCURRENTLY dist_id_temp_idx ON distributors (dist_id); ALTER TABLE distributors DROP CONSTRAINT distributors_pkey, ADD CONSTRAINT distributors_pkey PRIMARY KEY USING INDEX dist_id_temp_idx; - - + diff --git a/doc/src/sgml/ref/alter_tablespace.sgml b/doc/src/sgml/ref/alter_tablespace.sgml index 0cfc26437de..ed04d8437fb 100644 --- a/doc/src/sgml/ref/alter_tablespace.sgml +++ b/doc/src/sgml/ref/alter_tablespace.sgml @@ -111,8 +111,7 @@ ALTER TABLESPACE index_space RENAME TO fast_raid; Change the owner of tablespace index_space: ALTER TABLESPACE index_space OWNER TO mary; - - + diff --git a/doc/src/sgml/ref/alter_trigger.sgml b/doc/src/sgml/ref/alter_trigger.sgml index 2f943ee9c2a..90c2e3d141f 100644 --- a/doc/src/sgml/ref/alter_trigger.sgml +++ b/doc/src/sgml/ref/alter_trigger.sgml @@ -92,8 +92,7 @@ ALTER TRIGGER name ON ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs; - - + diff --git a/doc/src/sgml/ref/alter_type.sgml b/doc/src/sgml/ref/alter_type.sgml index a417c0d01b3..a81fe6c340c 100644 --- a/doc/src/sgml/ref/alter_type.sgml +++ b/doc/src/sgml/ref/alter_type.sgml @@ -313,8 +313,7 @@ ALTER TYPE compfoo ADD ATTRIBUTE f3 int; To add a new value to an enum type in a particular sort position: ALTER TYPE colors ADD VALUE 'orange' AFTER 'red'; - - + diff --git a/doc/src/sgml/ref/alter_user_mapping.sgml b/doc/src/sgml/ref/alter_user_mapping.sgml index d18fe361999..3245f83e08d 100644 --- a/doc/src/sgml/ref/alter_user_mapping.sgml +++ b/doc/src/sgml/ref/alter_user_mapping.sgml @@ -92,8 +92,7 @@ ALTER USER MAPPING FOR { user_name Change the password for user mapping bob, server foo: ALTER USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'public'); - - + diff --git a/doc/src/sgml/ref/alter_view.sgml b/doc/src/sgml/ref/alter_view.sgml index 0d509319a36..c3839057c07 100644 --- a/doc/src/sgml/ref/alter_view.sgml +++ b/doc/src/sgml/ref/alter_view.sgml @@ -123,8 +123,7 @@ ALTER VIEW name SET SCHEMA bar: ALTER VIEW foo RENAME TO bar; - - + diff --git a/doc/src/sgml/ref/begin.sgml b/doc/src/sgml/ref/begin.sgml index 4c6a2b4a2ce..acd823206a4 100644 --- a/doc/src/sgml/ref/begin.sgml +++ b/doc/src/sgml/ref/begin.sgml @@ -122,8 +122,7 @@ BEGIN [ WORK | TRANSACTION ] [ transaction_mode BEGIN; - - + diff --git a/doc/src/sgml/ref/close.sgml b/doc/src/sgml/ref/close.sgml index 25e3c817ebb..4af6af74922 100644 --- a/doc/src/sgml/ref/close.sgml +++ b/doc/src/sgml/ref/close.sgml @@ -107,8 +107,7 @@ CLOSE { name | ALL } Close the cursor liahona: CLOSE liahona; - - + diff --git a/doc/src/sgml/ref/cluster.sgml b/doc/src/sgml/ref/cluster.sgml index addf6520652..339990fa4d6 100644 --- a/doc/src/sgml/ref/cluster.sgml +++ b/doc/src/sgml/ref/cluster.sgml @@ -197,8 +197,7 @@ CLUSTER employees; Cluster all tables in the database that have previously been clustered: CLUSTER; - - + diff --git a/doc/src/sgml/ref/clusterdb.sgml b/doc/src/sgml/ref/clusterdb.sgml index 081f398706d..c80cbac5173 100644 --- a/doc/src/sgml/ref/clusterdb.sgml +++ b/doc/src/sgml/ref/clusterdb.sgml @@ -293,8 +293,7 @@ PostgreSQL documentation xyzzy: $ clusterdb --table foo xyzzy - - + diff --git a/doc/src/sgml/ref/comment.sgml b/doc/src/sgml/ref/comment.sgml index deda01281b1..1c8b37c8328 100644 --- a/doc/src/sgml/ref/comment.sgml +++ b/doc/src/sgml/ref/comment.sgml @@ -296,8 +296,7 @@ COMMENT ON TEXT SEARCH TEMPLATE snowball IS 'Snowball stemmer'; COMMENT ON TRIGGER my_trigger ON my_table IS 'Used for RI'; COMMENT ON TYPE complex IS 'Complex number data type'; COMMENT ON VIEW my_view IS 'View of departmental costs'; - - + diff --git a/doc/src/sgml/ref/commit.sgml b/doc/src/sgml/ref/commit.sgml index 1a039c2e3ee..40147a54769 100644 --- a/doc/src/sgml/ref/commit.sgml +++ b/doc/src/sgml/ref/commit.sgml @@ -72,8 +72,7 @@ COMMIT [ WORK | TRANSACTION ] To commit the current transaction and make all changes permanent: COMMIT; - - + diff --git a/doc/src/sgml/ref/commit_prepared.sgml b/doc/src/sgml/ref/commit_prepared.sgml index 930435d81a0..2af677fcb06 100644 --- a/doc/src/sgml/ref/commit_prepared.sgml +++ b/doc/src/sgml/ref/commit_prepared.sgml @@ -79,8 +79,7 @@ COMMIT PREPARED transaction_id COMMIT PREPARED 'foobar'; - - + diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 6429a4ef0d7..a73b02276cb 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -703,8 +703,7 @@ only one flag bit is defined, and the rest must be zero: - - + @@ -850,8 +849,7 @@ ZW ZIMBABWE 0000140 \0 002 Z M \0 \0 \0 006 Z A M B I A 377 377 0000160 377 377 \0 003 \0 \0 \0 002 Z W \0 \0 \0 \b Z I 0000200 M B A B W E 377 377 377 377 377 377 - - + @@ -910,7 +908,6 @@ COPY [ BINARY ] table_name [ WITH O TO { 'filename' | STDOUT } [ [USING] DELIMITERS 'delimiter' ] [ WITH NULL AS 'null string' ] - - + diff --git a/doc/src/sgml/ref/create_conversion.sgml b/doc/src/sgml/ref/create_conversion.sgml index 4a371912226..084b60c4c16 100644 --- a/doc/src/sgml/ref/create_conversion.sgml +++ b/doc/src/sgml/ref/create_conversion.sgml @@ -113,8 +113,7 @@ conv_proc( internal, -- destination (fill with a null terminated C string) integer -- source string length ) RETURNS void; - - + @@ -141,8 +140,7 @@ conv_proc( LATIN1 using myfunc: CREATE CONVERSION myconv FOR 'UTF8' TO 'LATIN1' FROM myfunc; - - + diff --git a/doc/src/sgml/ref/create_domain.sgml b/doc/src/sgml/ref/create_domain.sgml index 8db90f911f6..2c8b1f4e748 100644 --- a/doc/src/sgml/ref/create_domain.sgml +++ b/doc/src/sgml/ref/create_domain.sgml @@ -162,8 +162,7 @@ CREATE DOMAIN name [ AS ] CHECK (expression) - - CHECK clauses specify integrity constraints or tests + CHECK clauses specify integrity constraints or tests which values of the domain must satisfy. Each constraint must be an expression producing a Boolean result. It should use the key word VALUE @@ -202,8 +201,7 @@ CREATE TABLE us_snail_addy ( city TEXT NOT NULL, postal us_postal_code NOT NULL ); - - + diff --git a/doc/src/sgml/ref/create_extension.sgml b/doc/src/sgml/ref/create_extension.sgml index 7670d76f894..9ec0fa2fe16 100644 --- a/doc/src/sgml/ref/create_extension.sgml +++ b/doc/src/sgml/ref/create_extension.sgml @@ -111,8 +111,7 @@ CREATE EXTENSION [ IF NOT EXISTS ] extension_name old_version - - FROM old_version + FROM old_version must be specified when, and only when, you are attempting to install an extension that replaces an old style module that is just a collection of objects not packaged into an extension. This option diff --git a/doc/src/sgml/ref/create_foreign_data_wrapper.sgml b/doc/src/sgml/ref/create_foreign_data_wrapper.sgml index 3093ebcb4ac..804fb47c68f 100644 --- a/doc/src/sgml/ref/create_foreign_data_wrapper.sgml +++ b/doc/src/sgml/ref/create_foreign_data_wrapper.sgml @@ -62,8 +62,7 @@ CREATE FOREIGN DATA WRAPPER name HANDLER handler_function - - handler_function is the + handler_function is the name of a previously registered function that will be called to retrieve the execution functions for foreign tables. The handler function must take no arguments, and @@ -81,8 +80,7 @@ CREATE FOREIGN DATA WRAPPER name VALIDATOR validator_function - - validator_function is the + validator_function is the name of a previously registered function that will be called to check the generic options given to the foreign-data wrapper, as well as options for foreign servers and user mappings using the @@ -157,8 +155,7 @@ CREATE FOREIGN DATA WRAPPER file HANDLER file_fdw_handler; CREATE FOREIGN DATA WRAPPER mywrapper OPTIONS (debug 'true'); - - + diff --git a/doc/src/sgml/ref/create_foreign_table.sgml b/doc/src/sgml/ref/create_foreign_table.sgml index 5e58fb8c5eb..7f1cc4264db 100644 --- a/doc/src/sgml/ref/create_foreign_table.sgml +++ b/doc/src/sgml/ref/create_foreign_table.sgml @@ -169,8 +169,7 @@ CREATE FOREIGN TABLE films ( len interval hour to minute ) SERVER film_server; - - + diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index cd6ac69eb63..a617f965427 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -259,8 +259,7 @@ CREATE [ OR REPLACE ] FUNCTION WINDOW - - WINDOW indicates that the function is a + WINDOW indicates that the function is a window function rather than a plain function. This is currently only useful for functions written in C. The WINDOW attribute cannot be changed when @@ -282,8 +281,7 @@ CREATE [ OR REPLACE ] FUNCTION VOLATILE is the default assumption. - - IMMUTABLE indicates that the function + IMMUTABLE indicates that the function cannot modify the database and always returns the same result when given the same argument values; that is, it does not do database lookups or otherwise use information not @@ -292,8 +290,7 @@ CREATE [ OR REPLACE ] FUNCTION immediately replaced with the function value. - - STABLE indicates that the function + STABLE indicates that the function cannot modify the database, and that within a single table scan it will consistently return the same result for the same argument values, but that its @@ -306,8 +303,7 @@ CREATE [ OR REPLACE ] FUNCTION as stable, since their values do not change within a transaction. - - VOLATILE indicates that the function value can + VOLATILE indicates that the function value can change even within a single table scan, so no optimizations can be made. Relatively few database functions are volatile in this sense; some examples are random(), currval(), @@ -329,16 +325,14 @@ CREATE [ OR REPLACE ] FUNCTION STRICT - - CALLED ON NULL INPUT (the default) indicates + CALLED ON NULL INPUT (the default) indicates that the function will be called normally when some of its arguments are null. It is then the function author's responsibility to check for null values if necessary and respond appropriately. - - RETURNS NULL ON NULL INPUT or + RETURNS NULL ON NULL INPUT or STRICT indicates that the function always returns null whenever any of its arguments are null. If this parameter is specified, the function is not executed when there @@ -353,8 +347,7 @@ CREATE [ OR REPLACE ] FUNCTION EXTERNAL SECURITY DEFINER - - SECURITY INVOKER indicates that the function + SECURITY INVOKER indicates that the function is to be executed with the privileges of the user that calls it. That is the default. SECURITY DEFINER specifies that the function is to be executed with the @@ -499,8 +492,7 @@ CREATE [ OR REPLACE ] FUNCTION isCachable - - isCachable is an obsolete equivalent of + isCachable is an obsolete equivalent of IMMUTABLE; it's still accepted for backwards-compatibility reasons. diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index f7f360875c2..1a1e8d60d75 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -598,8 +598,7 @@ SELECT * FROM points To create an index without locking out writes to the table: CREATE INDEX CONCURRENTLY sales_quantity_index ON sales_table (quantity); - - + diff --git a/doc/src/sgml/ref/create_language.sgml b/doc/src/sgml/ref/create_language.sgml index 13c3baf993c..6e72892375b 100644 --- a/doc/src/sgml/ref/create_language.sgml +++ b/doc/src/sgml/ref/create_language.sgml @@ -118,8 +118,7 @@ CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE HANDLER call_handler - - call_handler is + call_handler is the name of a previously registered function that will be called to execute the procedural language's functions. The call handler for a procedural language must be written in a compiled @@ -178,8 +176,7 @@ CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE inline_handler - - inline_handler is the + inline_handler is the name of a previously registered function that will be called to execute an anonymous code block ( command) @@ -199,8 +196,7 @@ CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE valfunction - - valfunction is the + valfunction is the name of a previously registered function that will be called when a new function in the language is created, to validate the new function. @@ -309,8 +305,7 @@ CREATE FUNCTION plsample_call_handler() RETURNS language_handler LANGUAGE C; CREATE LANGUAGE plsample HANDLER plsample_call_handler; - - + diff --git a/doc/src/sgml/ref/create_operator.sgml b/doc/src/sgml/ref/create_operator.sgml index 90da092450f..28b5e7e0da2 100644 --- a/doc/src/sgml/ref/create_operator.sgml +++ b/doc/src/sgml/ref/create_operator.sgml @@ -52,8 +52,7 @@ CREATE OPERATOR name ( There are a few restrictions on your choice of name: - - -- and /* cannot appear anywhere in an operator name, + -- and /* cannot appear anywhere in an operator name, since they will be taken as the start of a comment. @@ -215,8 +214,7 @@ CREATE OPERATOR name ( arguments, use the OPERATOR() syntax, for example: COMMUTATOR = OPERATOR(myschema.===) , - - + @@ -266,8 +264,7 @@ CREATE OPERATOR === ( JOIN = area_join_procedure, HASHES, MERGES ); - - + diff --git a/doc/src/sgml/ref/create_role.sgml b/doc/src/sgml/ref/create_role.sgml index 43bec5d8e13..5a939346e7a 100644 --- a/doc/src/sgml/ref/create_role.sgml +++ b/doc/src/sgml/ref/create_role.sgml @@ -268,8 +268,7 @@ CREATE ROLE name [ [ WITH ] IN GROUP role_name - - IN GROUP is an obsolete spelling of + IN GROUP is an obsolete spelling of IN ROLE. @@ -438,8 +437,7 @@ CREATE ROLE miriam WITH LOGIN PASSWORD 'jw8s0F4' VALID UNTIL '2005-01-01'; Create a role that can create databases and manage roles: CREATE ROLE admin WITH CREATEDB CREATEROLE; - - + diff --git a/doc/src/sgml/ref/create_rule.sgml b/doc/src/sgml/ref/create_rule.sgml index e7c88497d60..8bccf7f1f12 100644 --- a/doc/src/sgml/ref/create_rule.sgml +++ b/doc/src/sgml/ref/create_rule.sgml @@ -149,8 +149,7 @@ CREATE [ OR REPLACE ] RULE name AS - - INSTEAD indicates that the commands should be + INSTEAD indicates that the commands should be executed instead of the original command. @@ -159,8 +158,7 @@ CREATE [ OR REPLACE ] RULE name AS - - ALSO indicates that the commands should be + ALSO indicates that the commands should be executed in addition to the original command. diff --git a/doc/src/sgml/ref/create_schema.sgml b/doc/src/sgml/ref/create_schema.sgml index 89a624eda26..930d876814d 100644 --- a/doc/src/sgml/ref/create_schema.sgml +++ b/doc/src/sgml/ref/create_schema.sgml @@ -147,8 +147,7 @@ CREATE SCHEMA hollywood; CREATE TABLE hollywood.films (title text, release date, awards text[]); CREATE VIEW hollywood.winners AS SELECT title, release FROM hollywood.films WHERE awards IS NOT NULL; - - + diff --git a/doc/src/sgml/ref/create_sequence.sgml b/doc/src/sgml/ref/create_sequence.sgml index f36b616db0e..367f440b6cb 100644 --- a/doc/src/sgml/ref/create_sequence.sgml +++ b/doc/src/sgml/ref/create_sequence.sgml @@ -318,8 +318,7 @@ BEGIN; COPY distributors FROM 'input_file'; SELECT setval('serial', max(id)) FROM distributors; END; - - + @@ -348,8 +347,7 @@ END; extension. - - + diff --git a/doc/src/sgml/ref/create_server.sgml b/doc/src/sgml/ref/create_server.sgml index f923dc84c89..be9be50b69c 100644 --- a/doc/src/sgml/ref/create_server.sgml +++ b/doc/src/sgml/ref/create_server.sgml @@ -136,8 +136,7 @@ CREATE SERVER foo FOREIGN DATA WRAPPER "default"; foreign-data wrapper pgsql: CREATE SERVER myserver FOREIGN DATA WRAPPER pgsql OPTIONS (host 'foo', dbname 'foodb', port '5432'); - - + diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 0fbe1160972..faff45900c4 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -288,8 +288,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI error will be reported. - - CHECK constraints are merged in essentially the same way as + CHECK constraints are merged in essentially the same way as columns: if multiple parent tables and/or the new table definition contain identically-named CHECK constraints, these constraints must all have the same check expression, or an error will be @@ -340,8 +339,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI table, unless the INCLUDING INDEXES clause is specified. - - STORAGE settings for the copied column definitions will only + STORAGE settings for the copied column definitions will only be copied if INCLUDING STORAGE is specified. The default behavior is to exclude STORAGE settings, resulting in the copied columns in the new table having type-specific default @@ -354,8 +352,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI is specified. The default behavior is to exclude comments, resulting in the copied columns and constraints in the new table having no comments. - - INCLUDING ALL is an abbreviated form of + INCLUDING ALL is an abbreviated form of INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES INCLUDING STORAGE INCLUDING COMMENTS. @@ -798,8 +795,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI - - + @@ -1061,9 +1057,7 @@ CREATE TABLE films ( kind varchar(10), len interval hour to minute ); - - CREATE TABLE distributors ( did integer PRIMARY KEY DEFAULT nextval('serial'), name varchar(40) NOT NULL CHECK (name <> '') @@ -1151,9 +1145,7 @@ CREATE TABLE distributors ( name varchar(40), PRIMARY KEY(did) ); - - CREATE TABLE distributors ( did integer PRIMARY KEY, name varchar(40) @@ -1259,8 +1251,7 @@ CREATE TABLE employees OF employee_type ( PRIMARY KEY (name), salary WITH OPTIONS DEFAULT 1000 ); - - + diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml index ff71078d1e2..e4797b65473 100644 --- a/doc/src/sgml/ref/create_table_as.sgml +++ b/doc/src/sgml/ref/create_table_as.sgml @@ -183,8 +183,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE - - + @@ -291,8 +290,7 @@ PREPARE recentfilms(date) AS SELECT * FROM films WHERE date_prod > $1; CREATE TEMP TABLE films_recent WITH (OIDS) ON COMMIT DROP AS EXECUTE recentfilms('2002-01-01'); - - + @@ -319,8 +317,7 @@ CREATE TEMP TABLE films_recent WITH (OIDS) ON COMMIT DROP AS - - PostgreSQL handles temporary tables in a way + PostgreSQL handles temporary tables in a way rather different from the standard; see for details. @@ -341,8 +338,7 @@ CREATE TEMP TABLE films_recent WITH (OIDS) ON COMMIT DROP AS is an extension. - - + diff --git a/doc/src/sgml/ref/create_tablespace.sgml b/doc/src/sgml/ref/create_tablespace.sgml index beda4540c81..89c89072aed 100644 --- a/doc/src/sgml/ref/create_tablespace.sgml +++ b/doc/src/sgml/ref/create_tablespace.sgml @@ -118,8 +118,7 @@ CREATE TABLESPACE dbspace LOCATION '/data/dbs'; owned by user genevieve: CREATE TABLESPACE indexspace OWNER genevieve LOCATION '/data/indexes'; - - + diff --git a/doc/src/sgml/ref/create_trigger.sgml b/doc/src/sgml/ref/create_trigger.sgml index 8e502d94e48..a7915cf09f4 100644 --- a/doc/src/sgml/ref/create_trigger.sgml +++ b/doc/src/sgml/ref/create_trigger.sgml @@ -235,8 +235,7 @@ UPDATE OF column_name1 [, column_name2UPDATE command. - - INSTEAD OF UPDATE events do not support lists of columns. + INSTEAD OF UPDATE events do not support lists of columns. @@ -311,8 +310,7 @@ UPDATE OF column_name1 [, column_name2DELETE triggers cannot refer to NEW. - - INSTEAD OF triggers do not support WHEN + INSTEAD OF triggers do not support WHEN conditions. @@ -502,8 +500,7 @@ CREATE TRIGGER view_insert - - PostgreSQL only allows the execution + PostgreSQL only allows the execution of a user-defined function for the triggered action. The standard allows the execution of a number of other SQL commands, such as CREATE TABLE, as the triggered action. This diff --git a/doc/src/sgml/ref/create_user_mapping.sgml b/doc/src/sgml/ref/create_user_mapping.sgml index c9606280fb8..c7cc4ce5746 100644 --- a/doc/src/sgml/ref/create_user_mapping.sgml +++ b/doc/src/sgml/ref/create_user_mapping.sgml @@ -94,8 +94,7 @@ CREATE USER MAPPING FOR { user_name Create a user mapping for user bob, server foo: CREATE USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'secret'); - - + diff --git a/doc/src/sgml/ref/createdb.sgml b/doc/src/sgml/ref/createdb.sgml index 9c8171d0499..3e50173e22a 100644 --- a/doc/src/sgml/ref/createdb.sgml +++ b/doc/src/sgml/ref/createdb.sgml @@ -352,8 +352,7 @@ PostgreSQL documentation $ createdb -p 5000 -h eden -E LATIN1 -e demo CREATE DATABASE demo ENCODING 'LATIN1'; - - + diff --git a/doc/src/sgml/ref/declare.sgml b/doc/src/sgml/ref/declare.sgml index f2b75b7aca5..d500faaa743 100644 --- a/doc/src/sgml/ref/declare.sgml +++ b/doc/src/sgml/ref/declare.sgml @@ -91,8 +91,7 @@ DECLARE name [ BINARY ] [ INSENSITI SCROLL NO SCROLL - - SCROLL specifies that the cursor can be used + SCROLL specifies that the cursor can be used to retrieve rows in a nonsequential fashion (e.g., backward). Depending upon the complexity of the query's execution plan, specifying SCROLL might impose @@ -110,8 +109,7 @@ DECLARE name [ BINARY ] [ INSENSITI WITH HOLD WITHOUT HOLD - - WITH HOLD specifies that the cursor can + WITH HOLD specifies that the cursor can continue to be used after the transaction that created it successfully commits. WITHOUT HOLD specifies that the cursor cannot be used outside of the transaction that diff --git a/doc/src/sgml/ref/delete.sgml b/doc/src/sgml/ref/delete.sgml index 9406f4e3af0..71ebeda880a 100644 --- a/doc/src/sgml/ref/delete.sgml +++ b/doc/src/sgml/ref/delete.sgml @@ -275,8 +275,7 @@ DELETE FROM tasks WHERE status = 'DONE' RETURNING *; c_tasks is currently positioned: DELETE FROM tasks WHERE CURRENT OF c_tasks; - - + diff --git a/doc/src/sgml/ref/discard.sgml b/doc/src/sgml/ref/discard.sgml index 74a2ce3b4ee..65ebbae1385 100644 --- a/doc/src/sgml/ref/discard.sgml +++ b/doc/src/sgml/ref/discard.sgml @@ -83,8 +83,7 @@ UNLISTEN *; SELECT pg_advisory_unlock_all(); DISCARD PLANS; DISCARD TEMP; - - + diff --git a/doc/src/sgml/ref/do.sgml b/doc/src/sgml/ref/do.sgml index 47f144f7954..5f43d1cf52c 100644 --- a/doc/src/sgml/ref/do.sgml +++ b/doc/src/sgml/ref/do.sgml @@ -107,9 +107,9 @@ BEGIN EXECUTE 'GRANT ALL ON ' || quote_ident(r.table_schema) || '.' || quote_ident(r.table_name) || ' TO webuser'; END LOOP; END$$; - - + + Compatibility diff --git a/doc/src/sgml/ref/drop_aggregate.sgml b/doc/src/sgml/ref/drop_aggregate.sgml index 400b4d70eb3..dd8aafa74db 100644 --- a/doc/src/sgml/ref/drop_aggregate.sgml +++ b/doc/src/sgml/ref/drop_aggregate.sgml @@ -99,8 +99,7 @@ DROP AGGREGATE [ IF EXISTS ] name ( integer: DROP AGGREGATE myavg(integer); - - + diff --git a/doc/src/sgml/ref/drop_cast.sgml b/doc/src/sgml/ref/drop_cast.sgml index 139e89dacaf..589c6ac39b3 100644 --- a/doc/src/sgml/ref/drop_cast.sgml +++ b/doc/src/sgml/ref/drop_cast.sgml @@ -92,8 +92,7 @@ DROP CAST [ IF EXISTS ] (source_type AS To drop the cast from type text to type int: DROP CAST (text AS int); - - + diff --git a/doc/src/sgml/ref/drop_collation.sgml b/doc/src/sgml/ref/drop_collation.sgml index 0afcaaf2dee..64a48eec2b0 100644 --- a/doc/src/sgml/ref/drop_collation.sgml +++ b/doc/src/sgml/ref/drop_collation.sgml @@ -84,8 +84,7 @@ DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRIC To drop the collation named german: DROP COLLATION german; - - + diff --git a/doc/src/sgml/ref/drop_conversion.sgml b/doc/src/sgml/ref/drop_conversion.sgml index 79e159dcbd1..6f866438fbb 100644 --- a/doc/src/sgml/ref/drop_conversion.sgml +++ b/doc/src/sgml/ref/drop_conversion.sgml @@ -77,8 +77,7 @@ DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRI To drop the conversion named myname: DROP CONVERSION myname; - - + diff --git a/doc/src/sgml/ref/drop_domain.sgml b/doc/src/sgml/ref/drop_domain.sgml index 689633f6dd6..b7b9a167c11 100644 --- a/doc/src/sgml/ref/drop_domain.sgml +++ b/doc/src/sgml/ref/drop_domain.sgml @@ -87,8 +87,7 @@ DROP DOMAIN [ IF EXISTS ] name [, . DROP DOMAIN box; - - + diff --git a/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml b/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml index 0ac0722f3d5..18fa4fe4a57 100644 --- a/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml +++ b/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml @@ -87,8 +87,7 @@ DROP FOREIGN DATA WRAPPER [ IF EXISTS ] namedbi: DROP FOREIGN DATA WRAPPER dbi; - - + diff --git a/doc/src/sgml/ref/drop_foreign_table.sgml b/doc/src/sgml/ref/drop_foreign_table.sgml index 71f26465bb6..9a9624b1873 100644 --- a/doc/src/sgml/ref/drop_foreign_table.sgml +++ b/doc/src/sgml/ref/drop_foreign_table.sgml @@ -85,8 +85,7 @@ DROP FOREIGN TABLE [ IF EXISTS ] name DROP FOREIGN TABLE films, distributors; - - + diff --git a/doc/src/sgml/ref/drop_function.sgml b/doc/src/sgml/ref/drop_function.sgml index a26b4ff66cf..2d0048be288 100644 --- a/doc/src/sgml/ref/drop_function.sgml +++ b/doc/src/sgml/ref/drop_function.sgml @@ -132,8 +132,7 @@ DROP FUNCTION [ IF EXISTS ] name ( DROP FUNCTION sqrt(integer); - - + diff --git a/doc/src/sgml/ref/drop_index.sgml b/doc/src/sgml/ref/drop_index.sgml index fb4ce2bf9cd..7177ef2d81b 100644 --- a/doc/src/sgml/ref/drop_index.sgml +++ b/doc/src/sgml/ref/drop_index.sgml @@ -87,8 +87,7 @@ DROP INDEX [ IF EXISTS ] name [, .. DROP INDEX title_idx; - - + diff --git a/doc/src/sgml/ref/drop_language.sgml b/doc/src/sgml/ref/drop_language.sgml index 21c9e5aced6..c2cb7045ded 100644 --- a/doc/src/sgml/ref/drop_language.sgml +++ b/doc/src/sgml/ref/drop_language.sgml @@ -100,8 +100,7 @@ DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name DROP LANGUAGE plsample; - - + diff --git a/doc/src/sgml/ref/drop_operator.sgml b/doc/src/sgml/ref/drop_operator.sgml index aa227ab8d87..3091454fdc5 100644 --- a/doc/src/sgml/ref/drop_operator.sgml +++ b/doc/src/sgml/ref/drop_operator.sgml @@ -123,8 +123,7 @@ DROP OPERATOR ~ (none, bit); for type bigint: DROP OPERATOR ! (bigint, none); - - + diff --git a/doc/src/sgml/ref/drop_role.sgml b/doc/src/sgml/ref/drop_role.sgml index a3a999437c2..92c0fb863dd 100644 --- a/doc/src/sgml/ref/drop_role.sgml +++ b/doc/src/sgml/ref/drop_role.sgml @@ -96,8 +96,7 @@ DROP ROLE [ IF EXISTS ] name [, ... To drop a role: DROP ROLE jonathan; - - + diff --git a/doc/src/sgml/ref/drop_rule.sgml b/doc/src/sgml/ref/drop_rule.sgml index fd24c701272..b7ff6e6078e 100644 --- a/doc/src/sgml/ref/drop_rule.sgml +++ b/doc/src/sgml/ref/drop_rule.sgml @@ -96,8 +96,7 @@ DROP RULE [ IF EXISTS ] name ON DROP RULE newrule ON mytable; - - + diff --git a/doc/src/sgml/ref/drop_schema.sgml b/doc/src/sgml/ref/drop_schema.sgml index 50fb09b965d..15dbc40817a 100644 --- a/doc/src/sgml/ref/drop_schema.sgml +++ b/doc/src/sgml/ref/drop_schema.sgml @@ -93,8 +93,7 @@ DROP SCHEMA [ IF EXISTS ] name [, . DROP SCHEMA mystuff CASCADE; - - + diff --git a/doc/src/sgml/ref/drop_sequence.sgml b/doc/src/sgml/ref/drop_sequence.sgml index 84a8ca188b3..f810b5976c1 100644 --- a/doc/src/sgml/ref/drop_sequence.sgml +++ b/doc/src/sgml/ref/drop_sequence.sgml @@ -86,8 +86,7 @@ DROP SEQUENCE [ IF EXISTS ] name [, DROP SEQUENCE serial; - - + diff --git a/doc/src/sgml/ref/drop_server.sgml b/doc/src/sgml/ref/drop_server.sgml index af08655a1d7..6a64e83ebe6 100644 --- a/doc/src/sgml/ref/drop_server.sgml +++ b/doc/src/sgml/ref/drop_server.sgml @@ -87,8 +87,7 @@ DROP SERVER [ IF EXISTS ] server_namefoo if it exists: DROP SERVER IF EXISTS foo; - - + diff --git a/doc/src/sgml/ref/drop_table.sgml b/doc/src/sgml/ref/drop_table.sgml index 7fa7e32ee07..26fe76e1f8d 100644 --- a/doc/src/sgml/ref/drop_table.sgml +++ b/doc/src/sgml/ref/drop_table.sgml @@ -100,8 +100,7 @@ DROP TABLE [ IF EXISTS ] name [, .. DROP TABLE films, distributors; - - + diff --git a/doc/src/sgml/ref/drop_tablespace.sgml b/doc/src/sgml/ref/drop_tablespace.sgml index aa80be3c6f5..107e049c8c6 100644 --- a/doc/src/sgml/ref/drop_tablespace.sgml +++ b/doc/src/sgml/ref/drop_tablespace.sgml @@ -86,8 +86,7 @@ DROP TABLESPACE [ IF EXISTS ] tablespace_namemystuff from the system: DROP TABLESPACE mystuff; - - + diff --git a/doc/src/sgml/ref/drop_trigger.sgml b/doc/src/sgml/ref/drop_trigger.sgml index 444c928d1ec..2fcc690db73 100644 --- a/doc/src/sgml/ref/drop_trigger.sgml +++ b/doc/src/sgml/ref/drop_trigger.sgml @@ -99,8 +99,7 @@ DROP TRIGGER [ IF EXISTS ] name ON DROP TRIGGER if_dist_exists ON films; - - + diff --git a/doc/src/sgml/ref/drop_type.sgml b/doc/src/sgml/ref/drop_type.sgml index 9de13068a7e..c3ddfa5f425 100644 --- a/doc/src/sgml/ref/drop_type.sgml +++ b/doc/src/sgml/ref/drop_type.sgml @@ -86,8 +86,7 @@ DROP TYPE [ IF EXISTS ] name [, ... To remove the data type box: DROP TYPE box; - - + diff --git a/doc/src/sgml/ref/drop_user_mapping.sgml b/doc/src/sgml/ref/drop_user_mapping.sgml index 747d7cbd2e7..de21bfe5d7a 100644 --- a/doc/src/sgml/ref/drop_user_mapping.sgml +++ b/doc/src/sgml/ref/drop_user_mapping.sgml @@ -85,8 +85,7 @@ DROP USER MAPPING [ IF EXISTS ] FOR { user_namebob, server foo if it exists: DROP USER MAPPING IF EXISTS FOR bob SERVER foo; - - + diff --git a/doc/src/sgml/ref/drop_view.sgml b/doc/src/sgml/ref/drop_view.sgml index 5d7e413c0b7..51b82664cb3 100644 --- a/doc/src/sgml/ref/drop_view.sgml +++ b/doc/src/sgml/ref/drop_view.sgml @@ -86,8 +86,7 @@ DROP VIEW [ IF EXISTS ] name [, ... This command will remove the view called kinds: DROP VIEW kinds; - - + diff --git a/doc/src/sgml/ref/dropdb.sgml b/doc/src/sgml/ref/dropdb.sgml index 1aa76cdb57b..e20bcdb53f4 100644 --- a/doc/src/sgml/ref/dropdb.sgml +++ b/doc/src/sgml/ref/dropdb.sgml @@ -253,8 +253,7 @@ PostgreSQL documentation Database "demo" will be permanently deleted. Are you sure? (y/n) y DROP DATABASE demo; - - + diff --git a/doc/src/sgml/ref/droplang.sgml b/doc/src/sgml/ref/droplang.sgml index 0ad640b0b47..04c3a609e5d 100644 --- a/doc/src/sgml/ref/droplang.sgml +++ b/doc/src/sgml/ref/droplang.sgml @@ -271,8 +271,7 @@ PostgreSQL documentation To remove the language pltcl: $ droplang pltcl dbname - - + diff --git a/doc/src/sgml/ref/dropuser.sgml b/doc/src/sgml/ref/dropuser.sgml index 3089a219543..c158103913c 100644 --- a/doc/src/sgml/ref/dropuser.sgml +++ b/doc/src/sgml/ref/dropuser.sgml @@ -254,8 +254,7 @@ PostgreSQL documentation Role "joe" will be permanently removed. Are you sure? (y/n) y DROP ROLE joe; - - + diff --git a/doc/src/sgml/ref/ecpg-ref.sgml b/doc/src/sgml/ref/ecpg-ref.sgml index 2bbd4761585..9c13e93a271 100644 --- a/doc/src/sgml/ref/ecpg-ref.sgml +++ b/doc/src/sgml/ref/ecpg-ref.sgml @@ -166,8 +166,7 @@ PostgreSQL documentation - - + @@ -253,8 +252,7 @@ PostgreSQL documentation ecpg prog1.pgc cc -I/usr/local/pgsql/include -c prog1.c cc -o prog1 prog1.o -L/usr/local/pgsql/lib -lecpg - - + diff --git a/doc/src/sgml/ref/end.sgml b/doc/src/sgml/ref/end.sgml index 85248b4c2f5..b60cb2c48bd 100644 --- a/doc/src/sgml/ref/end.sgml +++ b/doc/src/sgml/ref/end.sgml @@ -74,8 +74,7 @@ END [ WORK | TRANSACTION ] To commit the current transaction and make all changes permanent: END; - - + diff --git a/doc/src/sgml/ref/fetch.sgml b/doc/src/sgml/ref/fetch.sgml index b78fed267b9..cc49b6f0ce6 100644 --- a/doc/src/sgml/ref/fetch.sgml +++ b/doc/src/sgml/ref/fetch.sgml @@ -111,8 +111,7 @@ FETCH [ direction [ FROM | IN ] ] < direction - - direction defines + direction defines the fetch direction and number of rows to fetch. It can be one of the following: @@ -266,16 +265,14 @@ FETCH [ direction [ FROM | IN ] ] < - - + count - - count is a + count is a possibly-signed integer constant, determining the location or number of rows to fetch. For FORWARD and BACKWARD cases, specifying a negative - + diff --git a/doc/src/sgml/ref/grant.sgml b/doc/src/sgml/ref/grant.sgml index 1f5fe1f41fd..1437861441e 100644 --- a/doc/src/sgml/ref/grant.sgml +++ b/doc/src/sgml/ref/grant.sgml @@ -587,8 +587,7 @@ GRANT ALL PRIVILEGES ON kinds TO manuel; GRANT admins TO joe; - - + diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml index a5c0d5a0a68..6aae3396d29 100644 --- a/doc/src/sgml/ref/insert.sgml +++ b/doc/src/sgml/ref/insert.sgml @@ -312,8 +312,7 @@ WITH upd AS ( RETURNING * ) INSERT INTO employees_log SELECT *, current_timestamp FROM upd; - - + diff --git a/doc/src/sgml/ref/listen.sgml b/doc/src/sgml/ref/listen.sgml index 98091c2856a..7287d3fc296 100644 --- a/doc/src/sgml/ref/listen.sgml +++ b/doc/src/sgml/ref/listen.sgml @@ -113,8 +113,7 @@ LISTEN channel LISTEN virtual; NOTIFY virtual; Asynchronous notification "virtual" received from server process with PID 8448. - - + diff --git a/doc/src/sgml/ref/lock.sgml b/doc/src/sgml/ref/lock.sgml index 9b464580aae..53014ed34f5 100644 --- a/doc/src/sgml/ref/lock.sgml +++ b/doc/src/sgml/ref/lock.sgml @@ -222,8 +222,7 @@ DELETE FROM films_user_comments WHERE id IN (SELECT id FROM films WHERE rating < 5); DELETE FROM films WHERE rating < 5; COMMIT WORK; - - + diff --git a/doc/src/sgml/ref/notify.sgml b/doc/src/sgml/ref/notify.sgml index 330b2cd56d2..44807062930 100644 --- a/doc/src/sgml/ref/notify.sgml +++ b/doc/src/sgml/ref/notify.sgml @@ -204,8 +204,7 @@ Asynchronous notification "virtual" with payload "This is the payload" received LISTEN foo; SELECT pg_notify('fo' || 'o', 'pay' || 'load'); Asynchronous notification "foo" with payload "payload" received from server process with PID 14728. - - + diff --git a/doc/src/sgml/ref/pg_basebackup.sgml b/doc/src/sgml/ref/pg_basebackup.sgml index 47dce43b194..4150f2a4088 100644 --- a/doc/src/sgml/ref/pg_basebackup.sgml +++ b/doc/src/sgml/ref/pg_basebackup.sgml @@ -138,8 +138,7 @@ PostgreSQL documentation - - + diff --git a/doc/src/sgml/ref/pg_ctl-ref.sgml b/doc/src/sgml/ref/pg_ctl-ref.sgml index 10105e25241..07836e718f7 100644 --- a/doc/src/sgml/ref/pg_ctl-ref.sgml +++ b/doc/src/sgml/ref/pg_ctl-ref.sgml @@ -519,8 +519,7 @@ PostgreSQL documentation running without fsync, use: $ pg_ctl -o "-F -p 5433" start - - + @@ -534,8 +533,7 @@ PostgreSQL documentation how the server shuts down: $ pg_ctl stop -m fast - - + @@ -564,8 +562,7 @@ PostgreSQL documentation To restart using port 5433, disabling fsync upon restart: $ pg_ctl -o "-F -p 5433" restart - - + diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index c24cc394d66..f6f33de7e7e 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -268,10 +268,7 @@ PostgreSQL documentation - - - - + @@ -1075,8 +1072,7 @@ CREATE DATABASE foo WITH TEMPLATE template0; $ pg_dump -t '"MixedCaseName"' mydb > mytab.sql - - + diff --git a/doc/src/sgml/ref/pg_restore.sgml b/doc/src/sgml/ref/pg_restore.sgml index be4851b6570..be11d176cd4 100644 --- a/doc/src/sgml/ref/pg_restore.sgml +++ b/doc/src/sgml/ref/pg_restore.sgml @@ -197,8 +197,7 @@ - - + @@ -286,8 +285,7 @@ if filtering switches such as