Tom Lane wrote: > Bruce Momjian <br...@momjian.us> writes: > > Brad Nicholson wrote: > >> At the very least, a mention in the documentation of incompatible > >> contrib module(s) would be nice. Even better would be a sanity check > >> added to prevent this. > > > OK, I am looking to the hackers group for recommentations on this. > > One thing I was going to suggest is that pg_migrator check that all the > .so's in the old installation also exist in the new one. However that > could be overkill since you don't know for sure if the old .so is > referenced anywhere in the database.
Or in this case that the new *.so has the same functions. > As for the specific problem at hand, it might've been a mistake to > replace dblink_current_query() with a SQL function instead of changing > the internal implementation of the C function. We could still fix that. I am afraid /contrib is going to be a mine field for this type of problem so I am going to recommend uninstaling the /contrib module if possible and retry the migration. That should work in this case. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers