how can I exclude stuff from template in my dumps?

hello,

on restoring dumps I get errors about languages and functions not
getting restored:

pg_restore: [Archivierer (DB)] Fehler in Inhaltsverzeichniseintrag 135; 1255 164
39 FUNCTION pldbg_step_over(integer) postgres
pg_restore: [Archivierer (DB)] could not execute query: FEHLER:  Funktion »pldb
g_step_over« existiert bereits mit den selben Argumenttypen
    Command was: CREATE FUNCTION pldbg_step_over(session integer) RETURNS breakp
oint
    AS '$libdir/pldbgapi', 'pldbg_step_over'
    LANGUAG...

of course ... pldbpg_step_over is allready present, as it is installed
by the setup of the template database and thatfore it is on every
database.

Same with procedural language pl/pgsql and pg_buffercache etc...

Result: pg_restore ignores 29 errors, which is harmless, as those
functions are allready present.

BUT: it would be nicer, to not have these errors, as they can
overshaddow REAL error messages within the output.

Is there a clever way to exclude them from dumps or restores?

Harald


--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
EuroPython 2009 will take place in Birmingham - Stay tuned!