Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Patches > Re: column leve...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 6 Topic 3691 of 3966
Post > Topic >>

Re: column level privileges

by tgl@[EMAIL PROTECTED] (Tom Lane) May 6, 2008 at 08:57 PM

Stephen Frost <sfrost@[EMAIL PROTECTED]
> writes:
> * Tom Lane (tgl@[EMAIL PROTECTED]
) wrote:
>> I'm not sure where we go from here.  Your GSOC student has disappeared,
>> right?  Is anyone else willing to take up the patch and work on it?

> I'm willing to take it up and work on it.

Excellent!  As you say, you've seen that code before, so it should
go more quickly for you than most people.

>> One possible solution is to add a flag field
>> to TargetEntry to carry the information forward.

> I'll look into this, I liked the bitmap idea, personally.

Yeah, I do too.  What I am thinking now is that we need two bitmaps
per RTE: one showing the columns explicitly referenced (hence needing
SELECT permission) and one showing the columns assigned to (hence
needing INSERT or UPDATE as appropriate --- we will never have both
cases in one Query, so we don't need two bitmaps).  It would be
fairly easy to build these in the parser, and to check them in
the executor ... the fun part would be keeping them up-to-date
while the rewriter and planner mash the query around ...


>> One other mistake I noted was that the version checks added in pg_dump
>> and psql are ">= 80300", which of course is obsolete now.

> That one's pretty easy to handle. :)

Yeah, I just wanted to make sure it wasn't forgotten.  It's the kind
of thing you'd not notice in testing unless you thought to try pg_dump
against old server versions (which is a good idea of course).

			regards, tom lane

-- 
Sent via pgsql-patches mailing list (pgsql-patches@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches
 




 6 Posts in Topic:
Re: column level privileges
tgl@[EMAIL PROTECTED] (T  2008-05-06 19:54:29 
Re: column level privileges
sfrost@[EMAIL PROTECTED]   2008-05-06 20:42:24 
Re: column level privileges
tgl@[EMAIL PROTECTED] (T  2008-05-06 20:57:48 
Re: column level privileges
andrew@[EMAIL PROTECTED]   2008-05-06 23:49:57 
Re: column level privileges
sfrost@[EMAIL PROTECTED]   2008-05-07 07:38:33 
Re: column level privileges
peter_e@[EMAIL PROTECTED]  2008-05-07 13:33:59 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Sep 6 15:34:19 CDT 2008.