Ivan Baldo <ivan(at)pilasnet(dot)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