| From: | Glen Eustace <geustace(at)godzone(dot)net(dot)nz> |
|---|---|
| To: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Functions not dropped. |
| Date: | 2004-11-01 19:00:02 |
| Message-ID: | 1099335602.23365.20.camel@it026591.massey.ac.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Net Virtual Mailing Lists | 2004-11-01 19:07:30 | Re: [DEFAULT] Daily digest v1.4774 (21 messages) |
| Previous Message | Vinko Vrsalovic | 2004-11-01 18:42:29 | Re: Daylight Savings Time handling on persistent connections |