Re: [Csync2] csync_check_del broken under PostgreSQL

2017-10-31 Thread Lars Ellenberg
On Fri, Oct 27, 2017 at 11:00:14PM +0100, James Le Cuirot wrote: > On Mon, 23 Oct 2017 13:23:51 +0200 > Lars Ellenberg wrote: > > My locale and collation is entirely en_GB.UTF-8. > > afaik, = < > compare "collate character units", while LIKE, appart from > >

Re: [Csync2] csync_check_del broken under PostgreSQL

2017-10-27 Thread James Le Cuirot
On Mon, 23 Oct 2017 13:23:51 +0200 Lars Ellenberg wrote: > On Sun, Oct 22, 2017 at 11:33:55AM +0100, James Le Cuirot wrote: > > When checking for deleted files recursively, csync2 issues a SQL > > statement like this. > > > > => SELECT filename from file where

Re: [Csync2] csync_check_del broken under PostgreSQL

2017-10-23 Thread Lars Ellenberg
On Sun, Oct 22, 2017 at 11:33:55AM +0100, James Le Cuirot wrote: > When checking for deleted files recursively, csync2 issues a SQL > statement like this. > > => SELECT filename from file where filename > > '/mnt/csync2/portage/app-editors/ng/' and filename < >