It'd be nice if the catalog entries that store the DDL constraints
definitions and view definitions with regular expressions strings
would preserved any escape string syntax (i.e.E) for RegExp
backslashes.
For example, PGAdmin uses these catalog entries to produce Create or
Replace scripts to that allow one to alter table or view definitions.
However, when certain regular expressions syntax are added to these
definitions, the resulting scripts will not commit.
The following email illustrates the behavior that is undesirable (to me).
http://www.mail-archive.com/pgadmin-support(at)postgresql(dot)org/msg11482.html
--
Regards,
Richard Broersma Jr.