Alvaro Herrera wrote: > Terry Yapt wrote: > >> This is the main error: >> * FATAL: could not reattach to shared memory (key=5432001, addr=01D80000): >> Invalid argument >> >> It is always followed by this another system-app error: >> * LOG: unrecognized win32 error code: 487 > > FWIW, > http://help.netop.com/support/errorcodes/win32_error_codes.htm > > says > 487 Attempt to access invalid address. ERROR_INVALID_ADDRESS > > This problem has been reported before, for example in > > http://bbs.chinaunix.net/thread-973003-1-1.html > (not that I can read it very well) > > and > > http://lists.pgfoundry.org/pipermail/brasil-usuarios/20061127/003150.html > > No resolution seems to have been found. 8.3 will have a new way to deal with shared mem on win32. It's the same underlying tech, but we're no longer trying to squeeze it into an emulation of sysv. With a bit of luck, that'll help :-) //Magnus ---------------------------(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