Re: Delete w/ regexp - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Delete w/ regexp
Date
Msg-id Pine.BSF.4.21.0104191423070.88236-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Delete w/ regexp  ("Steve Wolfe" <steve@iboats.com>)
List pgsql-general
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?


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Authentication Question
Next
From: Konstantinos Agouros
Date:
Subject: Re: Authentication Question