Hi, 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. Can I do pg_upgrade (or pg_restore) with the indexes? What is the best practice? In documentation is: Users can then refer to these additional objects by qualifying the names with a schema name, or they can put the additional schemas into their search path, as they choose. thank you marian -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
