alter_table regression test problem

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема alter_table regression test problem
Дата
Msg-id 1383765381.96470.YahooMailNeo@web162906.mail.bf1.yahoo.com
обсуждение исходный текст
Ответы Re: alter_table regression test problem  (Andres Freund <andres@anarazel.de>)
Re: alter_table regression test problem  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-hackers
In checking things out with CLOBBER_CACHE_ALWAYS, I was getting
this problem, which seems to be unrelated to my changes:

*** /home/kgrittn/pg/master/src/test/regress/expected/alter_table.out   2013-11-01 09:07:35.418829105 -0500
--- /home/kgrittn/pg/master/src/test/regress/results/alter_table.out    2013-11-06 11:06:29.785830560 -0600
***************
*** 2320,2325 ****
      ) mapped;
   incorrectly_mapped | have_mappings
  --------------------+---------------
!                   0 | t
  (1 row)
 
--- 2320,2325 ----
      ) mapped;
   incorrectly_mapped | have_mappings
  --------------------+---------------
!                   1 | t
  (1 row)
 

======================================================================

I looked for detail with this query:

SELECT
    mapped_oid, oid
FROM (
    SELECT
        oid, reltablespace, relfilenode, relname,
        pg_filenode_relation(reltablespace, pg_relation_filenode(oid)) mapped_oid
    FROM pg_class
    WHERE relkind IN ('r', 'i', 'S', 't', 'm')
    ) mapped
WHERE (mapped_oid != oid OR mapped_oid IS NULL);

... with this result:

 mapped_oid | oid
------------+------
 2139062143 | 2619
(1 row)

2619 is the oid for pg_statistic, and the mapped_oid value matches
what we use to clobber the cache.  Any ideas before I start
digging?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Kohei KaiGai
Дата:
Сообщение: Re: [v9.4] row level security
Следующее
От: Andres Freund
Дата:
Сообщение: Re: alter_table regression test problem