On Thu, Oct 20, 2005 at 06:04:53PM +0200, Janning Vygen wrote: > By the way: What i really miss is a troubleshooting document in the > docs. I run postgresql for over 4 years now and i have come across > many situations where i really would need something like this. You > can find most solutions by reading the documentation entirely but it > is not very helpful if your production database went wrong and you > are quite a bit in a hurry. That's a great idea. Please post a doc patch with some of the troubleshooting tips you have in mind :) Cheers, D -- David Fetter david@xxxxxxxxxx http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(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