"Phillip Smith" <phillip.smith@xxxxxxxxxxxxxxxxxxx> writes: > I think I've found my problem: > I don't know how or when those tables were created in template1 - they're > certainly not supposed to be there or needed. Is it safe to just DROP the > tables from template1? Yeah, but what other user-created stuff (functions for instance) might be in there? You might want to drop template1 and recreate it from template0. (There's a blow-by-blow article about doing that on techdocs, IIRC.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend