Re: 7.0.3 - Backend crash on simple SELECT query

Ivan Baldo <ivan@pilasnet.com> writes:
>         Simple SELECT query with simple REGEXP comparison with simple
> ORDER
> and WITHOUT JOINS CRASHES BACKEND (seems to die in an infinite loop that
> consumes CPU and uses the hard disk).

Evidently it's data-specific, since I see no problem if I just create an
empty table per your CREATE and then try the query.

>         Dumping the database, then dropping it, then creating it and
> re-importing the dumped data has no effect.

Could you send me the table dump?  Or at least a backtrace from the
crashed backend?

			regards, tom lane