On 02/11/2014 08:19 PM, Yeb Havinga wrote: > On 2014-02-11 12:09, Craig Ringer wrote:
>> rls-9.4-upd-sb-views-v7 >> > Hi Craig, > > I compared output of psql -ef of the minirim.sql script posted earlier > in http://www.postgresql.org/message-id/52f54927.1040...@gmail.com > between v4 and v7. > > Not everything is ok. > +psql:/home/m/minirim2.sql:409: ERROR: attribute 6 has wrong type > +DETAIL: Table has type tsrange, but query expects _confidentialitycode. That's downright strange. I'll need to look into that one. > +psql:/home/m/minirim2.sql:439: connection to server was lost I've seen a server crash for causes as yet unknown in the main regression tests too. I'd love to stick with the in-optimizer approach used in v4, which - after all - works. The trouble is that it cannot support row-security quals that incorporate views correctly. I would have to invoke the rewriter from the optimizer and deal with recursion detection to make that work, and it looks pretty ugly. -- Craig Ringer 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
