On Fri, Aug 24, 2007 at 10:06:56AM -0400, Feng Chen wrote: > VERSION = PostgreSQL 8.1.2
You know that the project doesn't put out maintenance releases for the fun of it, right? The latest is 8.1.9 in that series. You need to upgrade. A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack. --Scott Morris ---------------------------(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