Re: remove some STATUS_* symbols

2020-01-16 Thread Kyotaro Horiguchi
At Thu, 16 Jan 2020 14:50:01 +0900, Michael Paquier wrote in > On Sat, Jan 11, 2020 at 08:14:17AM +0100, Peter Eisentraut wrote: > > OK, pushed as it was then. > > Thanks, that looks fine. I am still not sure whether the second patch > adding an enum via ProcWaitStatus improves the code readab

empty range

2020-01-16 Thread david . turon
Hello, default constructor for ranges use lower bound closed '[' and upper bound open ')'. This is correct behavior, but when upper bound is same like lower bound then range is empty. Mathematically is correct again - but in database is lost information about range bounds (lower/upper is NULL).

Re: Implementing Incremental View Maintenance

2020-01-16 Thread nuko yokohama
Error occurs when updating user-defined type columns. Create an INCREMENTAL MATERIALIZED VIEW by specifying a query that includes user-defined type columns. After the view is created, an error occurs when inserting into the view source table (including the user-defined type column). ``` ERROR: op

Re: Amcheck: do rightlink verification with lock coupling

2020-01-16 Thread Andrey Borodin
> 14 янв. 2020 г., в 9:47, Andrey Borodin написал(а): > > Page updates may be lost due to bug in backup software with incremental > backups, bug in storage layer of Aurora-style system, bug in page cache, > incorrect > fsync error handling, bug in ssd firmware etc. And our data checksums do

Re: Option to dump foreign data in pg_dump

2020-01-16 Thread vignesh C
On Tue, Jan 14, 2020 at 5:22 PM Luis Carril wrote: > Can you have a look at dump with parallel option. Parallel option will > take a lock on table while invoking lockTableForWorker. May be this is > not required for foreign tables. > Thoughts? > > I tried with -j and found no issue. I guess that

Re: Setting min/max TLS protocol in clientside libpq

2020-01-16 Thread Daniel Gustafsson
> On 16 Jan 2020, at 04:22, Michael Paquier wrote: > > On Wed, Jan 15, 2020 at 02:58:09PM +0900, Michael Paquier wrote: >> On Tue, Jan 14, 2020 at 11:01:00PM +0100, Daniel Gustafsson wrote: >>> Files renamed to match existing naming convention, the rest of the patch >>> left >>> unchanged. >> >

Re: [PATCH v1] pg_ls_tmpdir to show directories

2020-01-16 Thread Fabien COELHO
Hello Justin, I'm trying to think about how to get rid of the strange structure and hacks, and the arbitrary looking size 2 array. Also the recursion is one step, but I'm not sure why, ISTM it could/should go on always? Because tmpfiles only go one level deep. I'm not sure it is a general

<    1   2