"Sim Zacks" <sim@xxxxxxxxxxxxxx> writes: > select version() > "PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc (GCC) 3.3.5 (Gentoo Linux 3.3.5-r1, ssp-3.3.2-3, pie-8.7.7.1)" Several of the bugs listed in the 13 bug-fix releases which follow this one relate to tuple visibility bugs and data corruption bugs. I would suggest you first update to the latest bug-fix release for this version before even trying to debug anything further. I'm not sure any of them are necessarily causing this problem but even if they're not it's only a matter of time before they do something bad to your data. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
