Re: regexp incompatibilites 7.3 and 7.4

Oleg Bartunov <oleg@sai.msu.su> writes:
> seems for regexp which works in 7.3 is failing in 7.4.
> Is't possible to configure pgsql to be compatible with 7.3 regexp ?

SET regex_flavor TO extended;

> www=# select 'problem' ~ '^\\p';
> ERROR:  invalid regular expression: invalid escape \ sequence

I think, though, that this is telling you about a bug in your
application.  You do realize that under extended regex rules there's
no difference between that pattern and '^p' ?  Is that *really* what
you want?
        regards, tom lane