RE: The follwing error sometimes happened while updating partitioned table using inheritance; ERROR: attribute xxx of type record has wrong type
От
ideriha.takeshi@fujitsu.com
Тема
RE: The follwing error sometimes happened while updating partitioned table using inheritance; ERROR: attribute xxx of type record has wrong type
Дата
Msg-id
TYCPR01MB7041496C7DCC4860741D8634EA299@TYCPR01MB7041.jpnprd01.prod.outlook.com
Ответ на
Список
Дерево обсуждения
The follwing error sometimes happened while updating partitioned table using inheritance; ERROR: attribute xxx of type record has wrong type "ideriha.takeshi@fujitsu.com" <ideriha.takeshi@fujitsu.com>
Re: The follwing error sometimes happened while updating partitioned table using inheritance; ERROR: attribute xxx of type record has wrong type Amit Langote <amitlangote09@gmail.com>
RE: The follwing error sometimes happened while updating partitioned table using inheritance; ERROR: attribute xxx of type record has wrong type "ideriha.takeshi@fujitsu.com" <ideriha.takeshi@fujitsu.com>
RE: The follwing error sometimes happened while updating partitioned table using inheritance; ERROR: attribute xxx of type record has wrong type "ideriha.takeshi@fujitsu.com" <ideriha.takeshi@fujitsu.com>
Re: The follwing error sometimes happened while updating partitioned table using inheritance; ERROR: attribute xxx of type record has wrong type Amit Langote <amitlangote09@gmail.com>
RE: The follwing error sometimes happened while updating partitioned table using inheritance; ERROR: attribute xxx of type record has wrong type "ideriha.takeshi@fujitsu.com" <ideriha.takeshi@fujitsu.com>
Hi, thank you for your kind replay. >> Would you hit upon any other work arounds? > >Have you considered not using the sub-select expression in the UPDATE targetlist? That is, doesn't the following query, which doesn't use the subquery expression, do the same job as the original >query: > >update a set a = wk.x::char(10), b = wk.x, c = wk.y from b wk where wk.x = a.b and a.a = '2017'; Thank you, it seems work in my test cases. I misunderstood that SubLink (and following SubPlan) is always made from update on a partitioned table, but it actually made from subquery in update target list. Regards. Takeshi Ideriha
В списке pgsql-bugs по дате отправления
От: PG Bug reporting form
Дата:
От: Andres Freund
Дата: