Re: Functions not dropped. - Mailing list pgsql-general

From Glen Eustace
Subject Re: Functions not dropped.
Date
Msg-id 1099335602.23365.20.camel@it026591.massey.ac.nz
Whole thread Raw
In response to Functions not dropped.  (Glen Eustace <geustace@godzone.net.nz>)
List pgsql-general
On Mon, 2004-11-01 at 21:14, Sim Zacks wrote:
> I would check the template1 database to see if you had the functions
> defined there as well.
> Any functions/structures/data... in template1 will be moved to the new
> database. Then when you try to restore the old one it will conflict.

Thanks you.

That is exactly what had happened.  I recall on a previous exercise
loading the database but forgetting to created the admin db first and it
loading the whole lot into template1.  I remember cleaning out all the
tables etc, I must have forgotten the functions.

Time to re-init the installation.



pgsql-general by date:

Previous
From: Vinko Vrsalovic
Date:
Subject: Re: Daylight Savings Time handling on persistent connections
Next
From: "Jim C. Nasby"
Date:
Subject: Age of statistics