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