Search Postgresql Archives

Re: Dump/restore indexes and functions in public schema

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



marian krucina <marian.krucina@xxxxxxxxx> writes:
> pg_upgrade failed on own server, because we used functions from public
> schema in index. We install common functions (e.g. postgresql contrib)
> to public schema. Tables and indexes are in another schema, and names
> of functions without a schema name.

Are you sure that has anything to do with schemas, or is it that you
forgot to install the (updated versions of the) same contrib modules
into the new installation?

If not that, please provide a complete description of what you've got
in your old database and the errors you got trying to upgrade.  Also,
exactly what old and new PG versions are you working with?

			regards, tom lane


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux