On Fri, Sep 16, 2005 at 04:34:46PM -0700, Marc Munro wrote: > On Fri, 2005-09-16 at 17:10 -0600, Michael Fuhr wrote: > > Can you reproduce the problem with a reload? A stop and start will > > terminate client connections, but a reload shouldn't. > > This is not currently seen as a priority (the work-around of "don't do > that" is seen as sufficient). I'm simply hoping to get someone to say > for sure that the client app should not be able to tell that a reload > has happened. At that point I may be able to raise the priority of this > issue.
As far as I know clients shouldn't notice a reload (which is effected via a SIGHUP); I just did some tests and didn't see any problems. However, I don't know much about the inner workings of PostgreSQL so I can't say for sure. Maybe one of the developers will comment. -- Michael Fuhr ---------------------------(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