On 24 Nov 2006 at 18:59, novnov wrote: > OK, thanks...and I take it that there is nothing about the cube > functions that are inherently needed? I've never touched template1, > this is an out of the box postgres 8.1 windows install.
I'm not aware of the the cube functions - others may know what they are. Windows installer, at some point in the installation, asks you what modules you want included by default, and then loads these into template1; any databases you create thereafter will have them as well. I didn't load any of the contrib modules at installation, and there are no functions whatever in the public schema of template1 on my development machine. --Ray. ---------------------------------------------------------------------- Raymond O'Donnell Director of Music, Galway Cathedral, Galway, Ireland [EMAIL PROTECTED] ---------------------------------------------------------------------- ---------------------------(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