Re: Column-Level Privileges - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Column-Level Privileges
Date
Msg-id 20090120190155.GB32428@tamriel.snowman.net
Whole thread Raw
In response to Re: Column-Level Privileges  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Column-Level Privileges  (KaiGai Kohei <kaigai@ak.jp.nec.com>)
List pgsql-hackers
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> On the whole I think we have to go back to the original plan of
> recursively searching the query's expressions after we've finished all
> the transformations (and have a completed jointree to refer to).  This
> is slightly annoying on the grounds of adding parsing overhead that's
> completely useless unless per-column privileges are in use.  On the
> other hand, none of the workable alternatives are exactly overhead-free
> either.
>
> Comments?

Honestly, I like this approach.  There is some additional overhead
during parsing, but it seems cleaner and more robust.  Also, hopefully
in most cases where people are concerned about parse time they're
preparing their queries.  If it's warrented, we could try doing
benchmarks to see how bad the impact is and if we need to do something
different.  It doesn't strike me as likely to be a significant amount of
overhead though.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Column-Level Privileges
Next
From: Heikki Linnakangas
Date:
Subject: Re: Hot standby, RestoreBkpBlocks and cleanup locks