On 26 June 2012 10:59, Christoph Zwerschke <c...@online.de> wrote: > Our developers like the dblink modules, so I have installed it into the > template1 database. They also like to import old database dumps after > creating new databases with dbcreate. But then they get irritated by the > error messages saying that the dblink functions already exist, because these > functions are in the old dumps, but dbcreate already copied them from the > template1 database. Also, some scripts which copy databases break or create > unnecessary error messages because of that. Are there any best practices > when using dblink to avoid these issues?
I usually create a new template database containing such functions and use that template in the CREATE DATABASE statements. -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
