Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4

Поиск

Список

Период

Сортировка

От	Evan D. Hoffman
Тема	Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4
Дата	9 мая 2013 г. 23:21:11
Msg-id	CABRB-LuuWWV3RedUeWBBPmJ0QB6obepiJ=k5aTpsv2nPBWJEsQ@mail.gmail.com обсуждение исходный текст
Ответ на	Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 (Bruce Momjian <bruce@momjian.us>)
Ответы	Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4
Список	pgsql-hackers

Looks like your guess was correct:

[ehoffman@dev-db2 ~]$ psql -Upostgres db -p 5433

psql (9.2.4)

Type "help" for help.

db=# SELECT oid, relname, reltoastrelid, reltoastidxid FROM pg_class

db-# WHERE reltoastrelid = 299749;

oid | relname | reltoastrelid | reltoastidxid

-------+-----------+---------------+---------------

17304 | setupinfo | 299749 | 0

(1 row)

db=# \q

[ehoffman@dev-db2 ~]$ psql -Upostgres db -p 5432

psql (9.2.4, server 9.1.9)

WARNING: psql version 9.2, server version 9.1.

Some psql features might not work.

Type "help" for help.

db=# SELECT oid, relname, reltoastrelid, reltoastidxid FROM pg_class

db-# WHERE oid = 17304;

oid | relname | reltoastrelid | reltoastidxid

-------+-----------+---------------+---------------

17304 | setupinfo | 0 | 0

(1 row)

db=#

On Thu, May 9, 2013 at 4:15 PM, Bruce Momjian <bruce@momjian.us> wrote:

SELECT oid, relname, reltoastrelid, reltoastidxid FROM pg_class
WHERE oid =

В списке pgsql-hackers по дате отправления:

От: Bruce Momjian
Дата: 09 мая 2013 г., 23:15:45
Сообщение: Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4

От: Tom Lane
Дата: 09 мая 2013 г., 23:24:41
Сообщение: Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4