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.
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.
Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-83
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 w
I was a little surprised today when I tried to move a production
database on to my test server. The test server already had a copy of
the database so I did
psql -Uadmin template1
drop database admin;
create database admin;
When I tried to reload the production database dump, I got a series of
er
