[COMMITTERS] pgsql: Fix typo in comment

Fix typo in comment Masahiko Sawada Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/32e33a7979a10e9fcf2c9b32703838cec1daf674 Modified Files -- src/backend/commands/publicationcmds.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via pgsq

[COMMITTERS] pgsql: Use SASLprep to normalize passwords for SCRAM authentication.

Use SASLprep to normalize passwords for SCRAM authentication. An important step of SASLprep normalization, is to convert the string to Unicode normalization form NFKC. Unicode normalization requires a fairly large table of character decompositions, which is generated from data published by the Uni

Re: [COMMITTERS] pgsql: Add infrastructure to support EphemeralNamedRelation references.

On Thu, Apr 6, 2017 at 6:10 PM, Kevin Grittner wrote: > * About JOINs and dropped columns: although the parser never includes an > * already-dropped column in a JOIN RTE's alias var list, it is possible for > * such a list in a stored rule to include references to dropped columns. > * (If the

[COMMITTERS] pgsql: Fix planner error (or assert trap) with nested set operations.

Fix planner error (or assert trap) with nested set operations. As reported by Sean Johnston in bug #14614, since 9.6 the planner can fail due to trying to look up the referent of a Var with varno 0. This happens because we generate such Vars in generate_append_tlist, for lack of any better way to

[COMMITTERS] pgsql: Fix planner error (or assert trap) with nested set operations.

Fix planner error (or assert trap) with nested set operations. As reported by Sean Johnston in bug #14614, since 9.6 the planner can fail due to trying to look up the referent of a Var with varno 0. This happens because we generate such Vars in generate_append_tlist, for lack of any better way to

[COMMITTERS] pgsql: Remove duplicate assignment.

Remove duplicate assignment. Harmless, but clearly wrong. Kyotaro Horiguchi Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/0c732850d22a2dddb8a2ef64aed3c23731488caa Modified Files -- src/backend/utils/mb/Unicode/convutils.pm | 3 +-- 1 file changed, 1 in

[COMMITTERS] pgsql: Ensure that ExecPrepareExprList's result is all in one memory co

Ensure that ExecPrepareExprList's result is all in one memory context. Noted by Amit Langote. Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/dbb2a931478a397a2b655eb77e8be8c1ca136f63

[COMMITTERS] pgsql: Add ProcArrayGroupUpdate wait event.

Add ProcArrayGroupUpdate wait event. Discussion: http://postgr.es/m/ca+tgmobgwhcxdcchx2+bqjdk2dkpvf85zrjfhuyhhqmw8di...@mail.gmail.com Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/d4116a771925379c33cf4c6634ca620ed08b551d Modified Files -- doc/src/sgm

[COMMITTERS] pgsql: Use English, instead of internal names, for translatable message

Use English, instead of internal names, for translatable messages. Discussion: http://postgr.es/m/CA+Tgmobuz2C-YiQ87h8h0gECCV=F+SE=hbnaau75rr5fewt...@mail.gmail.com Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/5c4488478b182983f290a61fc8cf2ec83548622b Modified Fi

[COMMITTERS] pgsql: Fix new BRIN desummarize WAL record

Fix new BRIN desummarize WAL record The WAL-writing piece was forgetting to set the pages-per-range value. Also, fix the declared type of struct member heapBlk, which I mistakenly set as OffsetNumber rather than BlockNumber. Problem was introduced by commit c655899ba9ae (April 1st). Any system t

[COMMITTERS] pgsql: Avoid using a C++ keyword in header file

Avoid using a C++ keyword in header file per cpluspluscheck Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/0cb2e51992a7940f9e577a74da250508aedcecf7 Modified Files -- src/common/unicode/generate-unicode_norm_table.pl | 2 +- src/common/unicode_norm.c

[COMMITTERS] pgsql: Fix compiler warning

Fix compiler warning on MSVC 2010 Author: Michael Paquier Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/28afad5c85b436f19d9f2c0e3197c7db960fef6f Modified Files -- src/backend/catalog/pg_depend.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-

Re: [COMMITTERS] pgsql: Identity columns

On 4/6/17 23:13, David Rowley wrote: > On 7 April 2017 at 00:44, Peter Eisentraut wrote: >> Identity columns >> >> This is the SQL standard-conforming variant of PostgreSQL's serial >> columns. It fixes a few usability issues that serial columns have: >> >> - CREATE TABLE / LIKE copies default bu

[COMMITTERS] pgsql: Improve 64bit atomics support.

Improve 64bit atomics support. When adding atomics back in b64d92f1a, I added 64bit support as optional; there wasn't yet a direct user in sight. That turned out to be a bit short-sighted, it'd already have been useful a number of times. Add a fallback implementation of 64bit atomics, just like

[COMMITTERS] pgsql: Reduce the number of pallocs() in BRIN

Reduce the number of pallocs() in BRIN Instead of allocating memory in brin_deform_tuple and brin_copy_tuple over and over during a scan, allow reuse of previously allocated memory. This is said to make for a measurable performance improvement. Author: Jinyu Zhang, Álvaro Herrera Reviewed by: Tom

[COMMITTERS] pgsql: Fix printf format to use %zd when printing sizes

Fix printf format to use %zd when printing sizes Using %ld as we were doing raises compiler warnings on 32 bit platforms. Reported by Andres Freund. Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- http://git.postgresql.org/

[COMMITTERS] pgsql: doc: Add SPFLAGS to osx calls

doc: Add SPFLAGS to osx calls This enables the same OpenSP warnings on osx calls that we get from onsgmls (make check) and formerly from openjade. Older tool chains apparently have some of these warnings on by default (see comment at SPFLAGS assignment). So users of such tool chains would compla

[COMMITTERS] pgsql: doc: Add missing closing tag

doc: Add missing closing tag Author: Erik Rijkers Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/234811c21de4246e347e8369328bcaf706a35281 Modified Files -- doc/src/sgml/monitoring.sgml | 1 + 1 file changed, 1 insertion(+) -- Sent via pgsql-committer

Re: [COMMITTERS] pgsql: Improve 64bit atomics support.

On Sat, Apr 8, 2017 at 12:50 AM, Andres Freund wrote: > Additionally optimize reads/writes to 64bit on a number of platforms > where aligned writes of that size are atomic. This can now be tested > with PG_HAVE_8BYTE_SINGLE_COPY_ATOMICITY. > BTW, PG_HAVE_8BYTE_SINGLE_COPY_ATOMICITY is never used

[COMMITTERS] pgsql: Fix issues in e8fdbd58fe.

Fix issues in e8fdbd58fe. When the 64bit atomics simulation is in use, we can't necessarily guarantee the correct alignment of the atomics due to lack of compiler support for doing so- that's fine from a safety perspective, because everything is protected by a lock, but we asserted the alignment i

Re: [COMMITTERS] pgsql: Improve 64bit atomics support.

On 2017-04-08 02:16:34 +0300, Alexander Korotkov wrote: > On Sat, Apr 8, 2017 at 12:50 AM, Andres Freund wrote: > > > Additionally optimize reads/writes to 64bit on a number of platforms > > where aligned writes of that size are atomic. This can now be tested > > with PG_HAVE_8BYTE_SINGLE_COPY_AT

Re: [COMMITTERS] pgsql: Use SASLprep to normalize passwords for SCRAM authentication.

Heikki Linnakangas writes: > Use SASLprep to normalize passwords for SCRAM authentication. The test script that this adds appears to fail unless the environment selects a UTF8-based locale. On my RHEL6 machine, I see: LANG=C make check fail LANG=en_US.iso88591 make check

Re: [COMMITTERS] pgsql: Add infrastructure to support EphemeralNamedRelation references.

2017-04-07 13:06 GMT-03:00 Kevin Grittner : > ERROR: cannot drop table t1 column t1id because other objects depend on it > DETAIL: view v1 depends on table t1 column t1id > HINT: Use DROP ... CASCADE to drop the dependent objects too. > > Is that comment wrong? > Sort of. If you consider ALTER

Re: [COMMITTERS] pgsql: Add infrastructure to support EphemeralNamedRelation references.

On Fri, Apr 7, 2017 at 8:26 PM, Euler Taveira wrote: > 2017-04-07 13:06 GMT-03:00 Kevin Grittner : >> >> ERROR: cannot drop table t1 column t1id because other objects depend on >> it >> DETAIL: view v1 depends on table t1 column t1id >> HINT: Use DROP ... CASCADE to drop the dependent objects t

[COMMITTERS] pgsql: Optimize joins when the inner relation can be proven unique.

Optimize joins when the inner relation can be proven unique. If there can certainly be no more than one matching inner row for a given outer row, then the executor can move on to the next outer row as soon as it's found one match; there's no need to continue scanning the inner relation for this ou

[COMMITTERS] pgsql: Add GUCs for predicate lock promotion thresholds.

Add GUCs for predicate lock promotion thresholds. Defaults match the fixed behavior of prior releases, but now DBAs have better options to tune serializable workloads. It might be nice to be able to set this per relation, but that part will need to wait for another release. Author: Dagfinn Ilmar

[COMMITTERS] pgsql: doc: Add some markup

doc: Add some markup Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/f0e44021dfbdd37cb72aea71e3b3cf8b0397f9c5 Modified Files -- doc/src/sgml/ref/alter_domain.sgml| 16 doc/src/sgml/ref/alter_role.sgml | 4 ++-- doc/src/sgm