On Mon, Jan 17, 2005 at 11:41:34PM -0500, Tom Lane wrote: > > You forgot that ALTER DATABASE has this same option. It might be that > ALTER USER is just as convenient, or even more so, for Madison's problem > ... but it *can* be set at the database scope if needed. Drat, thanks for the reminder. And yep, there it is, right at the top of the ALTER DATABASE documentation...that's what I get for not checking. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match