Weird error updating table - Mailing list pgsql-general

From Brendan Duddridge
Subject Weird error updating table
Date
Msg-id 20F96513-B128-400F-827B-7FEEEF6F4138@clickspace.com
Whole thread Raw
Responses Re: Weird error updating table
List pgsql-general
Hi,

Today we received a very odd error from our PostgreSQL database:

"update category_product set product_is_active = p.is_active, product_status_code = p.status_code from product p where category_product.product_id = p.product_id  and category_id = 1001415;">:
    Next exception:SQL State:XX000 -- error code: 0 -- msg: ERROR: could not read from hash-join temporary file: Unknown error: 0

Any one know what that could mean? I've only seen it once so far. Hopefully it's not a sign of some sort of impending database doom.

Thanks,


____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 |  brendan@clickspace.com

ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB  T2G 0V9

http://www.clickspace.com 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using pg_dump and pg_restore
Next
From: Marc Munro
Date:
Subject: Re: Thoughts on a Isolation/Security problem