Re: Functions not dropped.

On 1 Nov 2004 at 20:45, Glen Eustace wrote:

> When I tried to reload the production database dump, I got a series of
> errors relating to functions. I repeated the exercise but this time did
> a \df prior to trying to load the database. In the public schema for the
> newly created admin database where all the functions from the old one.
> It seems that the drop database doesn't drop all of the functions. Is it
> supposed to ? I am using 7.4.2 on FC2.
>
> If it isn't is there a way to clean them all out before the load ?
>

It's more likely that the functions are defined in the template1 database
and so get copied to every new database. You should remove them
from there if you don't want this behaviour.

Cheers,
Gary.