On 2013-10-26 11:27:19 -0400, Tom Lane wrote: > Andres Freund <and...@2ndquadrant.com> writes: > > [ patch for \a\t mode in rules and sanity_check output ] > > Committed with some minor adjustment of the comments.
Thanks. > >> +1 (but what are those silly parens in pg_seclabels definition?), > > > That's because it contain several UNION ALLs and ruleutils makes sure > > the order is correct. > > That looks weird to me too, but it's surely not the fault of this patch. > Maybe we should take a look at exactly what ruleutils is doing there. Imo what it does looks sane - it adds parentheses whenever a child of a set operation is a set operation again to make sure the order in which the generated set operations are parsed/interpreted stays the same. Now, we could probably remove that in some more cases (left is SetOp but doesn't have an ORDER BY/LIMIT/...), but it's hard enough to figure out when that's safe that I wouldn't bother. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers