pgsql: Add some errdetail to checkRuleResultList().
От | Tom Lane |
---|---|
Тема | pgsql: Add some errdetail to checkRuleResultList(). |
Дата | |
Msg-id | E1X2NRY-0007ch-QM@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Add some errdetail to checkRuleResultList(). This function wasn't originally thought to be really user-facing, because converting a table to a view isn't something we expect people to do manually. So not all that much effort was spent on the error messages; in particular, while the code will complain that you got the column types wrong it won't say exactly what they are. But since we repurposed the code to also check compatibility of rule RETURNING lists, it's definitely user-facing. It now seems worthwhile to add errdetail messages showing exactly what the conflict is when there's a mismatch of column names or types. This is prompted by bug #10836 from Matthias Raffelsieper, which might have been forestalled if the error message had reported the wrong column type as being "record". Back-patch to 9.4, but not into older branches where the set of translatable error strings is supposed to be stable. Branch ------ REL9_4_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/cec3be05f624bc32599c2a056ec1b47bec917510 Modified Files -------------- src/backend/rewrite/rewriteDefine.c | 33 ++++++++++++++++++++++++++++----- 1 file changed, 28 insertions(+), 5 deletions(-)
В списке pgsql-committers по дате отправления: