Re: Errors creating partitioned tables from existing using (LIKE) after renaming table constraints Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Errors creating partitioned tables from existing using (LIKE) after renaming table constraints
Дата
Msg-id 20181217020634.GC31474@paquier.xyz
обсуждение исходный текст
Ответ на Re: Errors creating partitioned tables from existing using (LIKE) after renaming table constraints  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: Errors creating partitioned tables from existing using (LIKE) after renaming table constraints  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Список pgsql-bugs
Дерево обсуждения 
On Mon, Dec 17, 2018 at 10:51:10AM +0900, Michael Paquier wrote:
> Done just a few moments ago.  I have also added a test with a primary
> key rename which does not matter as long as LIKE INCLUDE INDEXES is
> involved but that felt safer in the long-run.

Buildfarm member prion is complaining on that:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=prion&dt=2018-12-17%2001%3A46%3A36
This uses -DRELCACHE_FORCE_RELEASE -DCATCACHE_FORCE_RELEASE.

It seems that the call to relation_close should happen after
CacheInvalidateRelcache.  Damn..
--
Michael
Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Errors creating partitioned tables from existing using (LIKE) after renaming table constraints
Следующее
От: Amit Langote
Дата:
Сообщение: Re: BUG #15552: Unexpected error in COPY to a foreign table in atransaction