On one of our tables, this works fine:
select * from images where path ~* 'packages/site_system';
  However, this:
delete from images where path ~* 'packages/site_system';
  will make it work for a second or two, then give:
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
   This is with Postgres 7.0.2.  Any ideas what's going on?
steve