Re: pg_upgrade 9.4 -> 9.5 with pg_trgm fails for me
| От | Karsten Hilbert |
|---|---|
| Тема | Re: pg_upgrade 9.4 -> 9.5 with pg_trgm fails for me |
| Дата | |
| Msg-id | 20160108120202.GD22446@hermes.hilbert.loc обсуждение |
| Ответ на | pg_upgrade 9.4 -> 9.5 with pg_trgm fails for me (Karsten Hilbert <Karsten.Hilbert@gmx.net>) |
| Список | pgsql-general |
On Fri, Jan 08, 2016 at 12:45:29PM +0100, Karsten Hilbert wrote:
> pg_restore: erstelle EXTENSION „pg_trgm“
> pg_restore: erstelle COMMENT „EXTENSION "pg_trgm"“
> pg_restore: erstelle FUNCTION „pg_catalog.gtrgm_in("cstring")“
> pg_restore: [Archivierer (DB)] Fehler in Phase PROCESSING TOC:
> pg_restore: [Archivierer (DB)] Fehler in Inhaltsverzeichniseintrag 893; 1255 511230 FUNCTION gtrgm_in("cstring")
postgres
> pg_restore: [Archivierer (DB)] could not execute query: ERROR: pg_type OID value not set when in binary upgrade
mode
> Die Anweisung war: CREATE FUNCTION "gtrgm_in"("cstring") RETURNS "gtrgm"
> LANGUAGE "c" IMMUTABLE STRICT
> AS '$libdir/pg_trgm', 'gtrgm_in'...
It does sound similar to
http://postgresql.nabble.com/BUG-5942-pg-trgm-sql-has-cyclic-dependency-on-type-gtrgm-creation-td4259677.html
which, however, wouldn't help me in solving the problem.
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
В списке pgsql-general по дате отправления: