Re: Delete w/ regexp

Do you have any triggers or fk constraints that reference
the table?

On Thu, 19 Apr 2001, Steve Wolfe wrote:

>
> 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?