From: | Rueegg Alexander <ALR(at)bdal(dot)de> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Dblink upgrade from 8.4 to 9.1 |
Date: | 2011-09-19 09:40:44 |
Message-ID: | 59BC4792497BB345A9349A2B463CDAB20DB43388@HBMAILBOX20.bdal.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sorry, but I have to correct my first description of the failure. Indeed the "uuid-ossp" module was not migrated automatically. For some reasons when restoring the database I've chosen to clean before restore. And in this scenario the migration took place. Starting from a clean new db the backup is restored as excpected. But when trying to "install" the "dblink" extensions with "create extension dblink from unpackaged" I get the following error:
ERROR: function dblink_get_notify() does not exist SQL Status:42883
Thanks for your help in advance
Alex
--
Alexander Rueegg
Software Development
BioCompass
Bruker Daltonik GmbH (Bremen)
Phone: +49 421 2205 446
Fax: +49 421 2205 305
E-Mail: alr(at)bdal(dot)de
-----------------------------
Bruker Daltonik GmbH
Fahrenheitstrasse 4 Gesch?ftsf?hrer Sitz der Gesellschaft
28359 Bremen Frank Laukien, Ph. D. Bremen
Germany Gerd H?lso
Sebastian Meyer-Plath Handelsregister
Permoserstrasse 15 Stefan Ruge Amtsgericht Bremen
04318 Leipzig Ian Sanders, Ph. D. HRB 8150
Germany Dr. Michael Schubert www.bdal.de
Haftungsausschluss: Die Bruker Daltonik GmbH ist nicht verantwortlich f?r die ordnungsgem??e, vollst?ndige und verz?gerungsfreie ?bertragung der Nachricht. Der Inhalt der E-Mail ist nur rechtsverbindlich, wenn er unsererseits durch einen Brief oder ein Fax entsprechend best?tigt wird.
Exclusion from liability: Any liability of Bruker Daltonik GmbH referring to the correct, complete and immediate transmission of the message shall be excluded. The content of the e-mail including its attachments is only legally binding if confirmed by Bruker Daltonik GmbH by letter or fax.
-----------------------------
________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Koen Van Impe | 2011-09-19 10:01:57 | Grouping by timestamp, how to return 0 when there's no record |
Previous Message | Rueegg Alexander | 2011-09-19 08:44:32 | Dblink upgrade from 8.4 to 9.1 |