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