Christoph Zwerschke 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? In version 9.0 and below you pretty much have to live with that. >From 9.1 on, you install dblink with CREATE EXTENSION, and things should get better. You can create the extension in the template database and should not get any more errors when you restore a dump that already contains the extension. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
