Weird error updating table

From: Brendan Duddridge <brendan(at)clickspace(dot)com>
To: PostgreSQL-general General <pgsql-general(at)postgresql(dot)org>
Subject: Weird error updating table
Date: 2006-04-18 17:32:39
Message-ID: 20F96513-B128-400F-827B-7FEEEF6F4138@clickspace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)clickspace(dot)com

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

http://www.clickspace.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Munro 2006-04-18 18:15:43 Re: Thoughts on a Isolation/Security problem
Previous Message Tom Lane 2006-04-18 15:54:54 Re: Using pg_dump and pg_restore