Am Freitag, 4. Januar 2008 10:03 schrieb Steve Atkins: > On Jan 4, 2008, at 12:44 AM, mljv@xxxxxxxxxxxx wrote: > > I just want to ask if there is something else > > besideds > > hardware failure which could force a signall 4 (ILL)? > > Software bugs can on rare occasions (by overwriting return stack data > and heading off into the weeds, say), but there's no way they'd do > that in > multiple processes simultaneously > > It's conceivable it was just a transient problem ("a cosmic ray" - > they really do > happen occasionally) but it's much more likely you have bad hardware. > Probably either RAM, disk or disk controller. thanks a lot for clarifying this so quickly. kind regards, Janning ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match