Rod,

> I think what we want is a clean template without all of the extras that
> template1 has.

We have this, it's called Template0.

Actually, KL, that would solve a lot of these duplicate object problems.  What 
if pg_restore used Template0 and not Template1?    It wouldn't fix the "drop 
public schema" issue but it would solve the others.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to