Re:

On Tue, 2002-09-10 at 00:50, Philip Warner wrote:

> ALTERNATIVELY, define the language in template1, then just edit dump1.lis 
> to remove the line for the language definition, and run pg_restore -L 
> dump1.lis.

That doesn't work for a dump and reload, because 7.3's pg_dumpall writes
a script to create the databases from template0 rather than template1.

The 7.3 documentation for pg_dump says:
   Notes      If your installation has any local additions to the template1   database, be careful to restore the
outputof pg_dump into a truly   empty database; otherwise you are likely to get errors due to   duplicate definitions
ofthe added objects. To make an empty   database without any local additions, copy from template0 not   template1, for
example:         CREATE DATABASE foo WITH TEMPLATE = template0;   
 
but this seems to be out of date.  pg_dumpall actually uses template0
itself.

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                            
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
========================================   "Draw near to God and he will draw near to you.       Cleanse your hands,
yousinners; and purify your       hearts, you double minded."       James 4:8