Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help!... Error Deleting Records

Status
Not open for further replies.

pump

Programmer
Jul 4, 2000
10
0
0
MX
Visit site
When I use:
[tt]delete from marcas where marca='GRA';[/tt]

I get the error:
[tt]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. Attemping reset: Failed.[/tt]

Can anyone help me whith this? I don't know where to start.

Thanks in advance.
 
if you're running linux restart the postmaster - there is something (can't see what) in the query or results that is having a go at the postmaster - i've often found it is simpler just to restart it - i've also occasionally noticed that postgres can lock failed transactions and not display an error unitl the postmaster is restarted (whihc is useful!!).

alternatively, if the postmaster is still happy jump out of psql (\q) and back in again ...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top