Re: [COMMITTERS] pgsql: Fix support of digits in email/hostnames.

2016-04-29 Thread Bruce Momjian
On Fri, Apr 29, 2016 at 06:43:04AM -0400, Bruce Momjian wrote: > On Fri, Apr 29, 2016 at 01:20:35PM +0300, Teodor Sigaev wrote: > > >Doesn't this invalidate tsvector indexes upgraded by pg_upgrade? Should > > >they be marked as invalid? > > Directly, it affects on functional indexes i.e. over to_t

Re: [COMMITTERS] pgsql: Fix support of digits in email/hostnames.

2016-04-29 Thread Bruce Momjian
On Fri, Apr 29, 2016 at 01:20:35PM +0300, Teodor Sigaev wrote: > >Doesn't this invalidate tsvector indexes upgraded by pg_upgrade? Should > >they be marked as invalid? > Directly, it affects on functional indexes i.e. over to_tsvector(). But it > affects tsvector column, it should be recreated if

Re: [COMMITTERS] pgsql: Fix support of digits in email/hostnames.

2016-04-29 Thread Teodor Sigaev
Doesn't this invalidate tsvector indexes upgraded by pg_upgrade? Should they be marked as invalid? Directly, it affects on functional indexes i.e. over to_tsvector(). But it affects tsvector column, it should be recreated if it was generated by ts_vector() function. Can you also fix the oth

Re: [COMMITTERS] pgsql: Fix support of digits in email/hostnames.

2016-04-28 Thread Bruce Momjian
On Tue, Mar 29, 2016 at 03:29:20PM +, Teodor Sigaev wrote: > Fix support of digits in email/hostnames. > > When tsearch was implemented I did several mistakes in hostname/email > definition rules: > 1) allow underscore in hostname what prohibited by RFC > 2) forget to allow leading digits sepa