Re: Make procedure OUT parameters work with JDBC

2020-10-27 Thread Peter Eisentraut
On 2020-10-19 13:15, Andrew Dunstan wrote: On 10/19/20 5:19 AM, Peter Eisentraut wrote: A follow-up to the recently added support for OUT parameters for procedures.  The JDBC driver sends OUT parameters with type void. This makes sense when calling a function, so that the parameters are ignored

Question about make coverage-html

2020-10-27 Thread Peter Smith
Hi hackers. The example of test coverage in the documentation [1] works as advertised. But I wanted to generate test coverage results only of some TAP tests in src/test/subscription. The documentation [1] also says "The make commands also work in subdirectories." so I tried running them all in

Re: Add important info about ANALYZE after create Functional Index

2020-10-27 Thread Nikolay Samokhvalov
On Mon, Oct 26, 2020 at 3:08 PM Fabrízio de Royes Mello < fabriziome...@gmail.com> wrote: > Would be nice if add some information about it into our docs but not sure > where. I'm thinking about: > - doc/src/sgml/ref/create_index.sgml > - doc/src/sgml/maintenance.sgml (routine-reindex) >

Re: Online checksums verification in the backend

2020-10-27 Thread Michael Paquier
On Fri, Oct 23, 2020 at 06:06:30PM +0900, Michael Paquier wrote: > On Fri, Oct 23, 2020 at 04:31:56PM +0800, Julien Rouhaud wrote: >> Mmm, is it really an improvement to report warnings during this >> function execution? Note also that PageIsVerified as-is won't report >> a warning if a page is

Re: Internal key management system

2020-10-27 Thread Craig Ringer
On Mon, Oct 26, 2020 at 11:02 PM Stephen Frost wrote: TL;DR: * Important to check that key rotation is possible on a replica, i.e. primary and standby can have different cluster passphrase and KEK encrypting the same WAL and heap keys; * with a HSM we can't read the key out, so a pluggable KEK

Re: Parallel Append can break run-time partition pruning

2020-10-27 Thread Amit Langote
On Sun, Oct 25, 2020 at 10:06 AM David Rowley wrote: > On Fri, 16 Oct 2020 at 03:01, Amit Langote wrote: > > > > Going over the last few emails, it seems that David held off from > > committing the patch, because of the lack of confidence in its > > robustness. With the patch, a

RE: extension patch of CREATE OR REPLACE TRIGGER

2020-10-27 Thread tsunakawa.ta...@fujitsu.com
From: osumi.takami...@fujitsu.com > > > * I don't think that you've fully thought through the implications > > > of replacing a trigger for a table that the current transaction has > > > already modified. Is it really sufficient, or even useful, to do > > > this: > > > > > > +/* > >

<    1   2