Re: WIP Patch for GROUPING SETS phase 1
От | Andrew Gierth |
---|---|
Тема | Re: WIP Patch for GROUPING SETS phase 1 |
Дата | |
Msg-id | 87fvgoo80r.fsf@news-spur.riddles.org.uk обсуждение исходный текст |
Ответ на | Re: WIP Patch for GROUPING SETS phase 1 (Alvaro Herrera <alvherre@2ndquadrant.com>) |
Список | pgsql-hackers |
>>>>> "Alvaro" == Alvaro Herrera <alvherre@2ndquadrant.com> writes: >> (This of course means that if someone has a cube() function call>> in a group by clause of a view, then upgrading willchange the>> meaning of the view and possibly fail to create it; there seems to>> be no fix for this, not even usingthe latest pg_dump, since>> pg_dump relies on the old server's ruleutils) Alvaro> This sucks. Can we tweak pg_dump to check for presence ofAlvaro> the cube extension, and if found refuse to dumpunless aAlvaro> minor version older than some hardcoded version (known toAlvaro> have fixed ruleutils) is used? I honestly don't think it's worth it. cube() is not a function that really makes any sense in a GROUP BY, though of course someone could have written their own function called cube() that does something else; while this case is a problem, it is also likely to be vanishingly rare. -- Andrew (irc:RhodiumToad)
В списке pgsql-hackers по дате отправления: