Re: [PATCHES] Use of backslash in tsearch2 - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [PATCHES] Use of backslash in tsearch2
Date
Msg-id 200609022204.k82M4o712559@momjian.us
Whole thread Raw
In response to Re: [PATCHES] Use of backslash in tsearch2  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-hackers
Thanks.  Yes, it is need for two reasons.  In 8.2 you can set
standard_conforming_strings to on, meaning \' is really treated as \ and
', and because some encodings now can't support \' for security reasons,
though I don't think tsearch2 supports those multibyte encodings.
Anyway, applied to 8.2 only, not backpatched.  Thanks.

---------------------------------------------------------------------------

Teodor Sigaev wrote:
> > Patch isn't full, simple test (values are took from regression.diffs):
> > and try dump table and restore:
> > ERROR:  syntax error
> > CONTEXT:  COPY tt, line 5, column tq: "'1 ''2'"
> >
>
> Attached cumulative patch fixes problem, but I have some doubts, is it really
> needed?
>
>
> --
> Teodor Sigaev                                   E-mail: teodor@sigaev.ru
>                                                     WWW: http://www.sigaev.ru/

[ application/x-tar is not supported, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Coding style for emacs
Next
From: Bruce Momjian
Date:
Subject: Re: Coding style for emacs