[COMMITTERS] pgsql: Doc: add example of transition table use in a trigger.

2017-09-16 Thread Tom Lane
Doc: add example of transition table use in a trigger. I noticed that there were exactly no complete examples of use of a transition table in a trigger function, and no clear description of just how you'd do it either. Improve that. Branch -- REL_10_STABLE Details --- https://git.postgr

[COMMITTERS] pgsql: Doc: add example of transition table use in a trigger.

2017-09-16 Thread Tom Lane
Doc: add example of transition table use in a trigger. I noticed that there were exactly no complete examples of use of a transition table in a trigger function, and no clear description of just how you'd do it either. Improve that. Branch -- master Details --- https://git.postgresql.or

[COMMITTERS] pgsql: Fix SQL-spec incompatibilities in new transition table feature.

2017-09-16 Thread Tom Lane
Fix SQL-spec incompatibilities in new transition table feature. The standard says that all changes of the same kind (insert, update, or delete) caused in one table by a single SQL statement should be reported in a single transition table; and by that, they mean to include foreign key enforcement a

[COMMITTERS] pgsql: Fix SQL-spec incompatibilities in new transition table feature.

2017-09-16 Thread Tom Lane
Fix SQL-spec incompatibilities in new transition table feature. The standard says that all changes of the same kind (insert, update, or delete) caused in one table by a single SQL statement should be reported in a single transition table; and by that, they mean to include foreign key enforcement a

[COMMITTERS] pgsql: docs: clarify pg_upgrade docs regarding standbys and rsync

2017-09-16 Thread Bruce Momjian
docs: clarify pg_upgrade docs regarding standbys and rsync Document that rsync is an _optional_ way to upgrade standbys, suggest rsync option --dry-run, and mention a way of upgrading one standby from another using rsync. Also clarify some instructions by specifying if they operate on the old or

[COMMITTERS] pgsql: docs: clarify pg_upgrade docs regarding standbys and rsync

2017-09-16 Thread Bruce Momjian
docs: clarify pg_upgrade docs regarding standbys and rsync Document that rsync is an _optional_ way to upgrade standbys, suggest rsync option --dry-run, and mention a way of upgrading one standby from another using rsync. Also clarify some instructions by specifying if they operate on the old or

[COMMITTERS] pgsql: docs: clarify pg_upgrade docs regarding standbys and rsync

2017-09-16 Thread Bruce Momjian
docs: clarify pg_upgrade docs regarding standbys and rsync Document that rsync is an _optional_ way to upgrade standbys, suggest rsync option --dry-run, and mention a way of upgrading one standby from another using rsync. Also clarify some instructions by specifying if they operate on the old or

[COMMITTERS] pgsql: docs: clarify pg_upgrade docs regarding standbys and rsync

2017-09-16 Thread Bruce Momjian
docs: clarify pg_upgrade docs regarding standbys and rsync Document that rsync is an _optional_ way to upgrade standbys, suggest rsync option --dry-run, and mention a way of upgrading one standby from another using rsync. Also clarify some instructions by specifying if they operate on the old or

Re: [COMMITTERS] pgsql: Expand partitioned table RTEs level by level, without flattening

2017-09-16 Thread Andreas Seltenreich
Robert Haas writes: > Expand partitioned table RTEs level by level, without flattening. testing with sqlsmith shows that the following assertion in this commit doesn't hold: TRAP: FailedAssertion("!(((brel)->reloptkind == RELOPT_BASEREL || (brel)->reloptkind == RELOPT_OTHER_MEMBER_REL))", File: