Re: [HACKERS] Wanting to learn about pgsql design decision

2016-08-03 Thread Kevin Grittner
On Wed, Aug 3, 2016 at 2:52 AM, Tal Walter wrote: > I'd appreciate if you could help me understand how I can research the > answers to these type of questions by myself. > Could I perhaps search the commit > comments somehow? Or perhaps a different approach to suggest? In addition to Tom's sugg

Re: [HACKERS] Wanting to learn about pgsql design decision

2016-08-03 Thread Tom Lane
Tal Walter writes: > The example questions I gave are just some of the questions I've tried to > search the answer to, using google and searching this mailing list > specifically, but I came up with nothing. Could I perhaps search the commit > comments somehow? Or perhaps a different approach to s

Re: [HACKERS] Wanting to learn about pgsql design decision

2016-08-03 Thread Tal Walter
Thanks Tom and Andrew! This is indeed interesting. Because I have a couple more of these questions, and I prefer to avoid receiving a RTFM, I'd appreciate if you could help me understand how I can research the answers to these type of questions by myself. The example questions I gave are just som

Re: [HACKERS] Wanting to learn about pgsql design decision

2016-08-02 Thread Andrew Gierth
> "Tom" == Tom Lane writes: >> - Why to read from a table, both a usage permission on the schema >> and a read access permission on the table is needed? Tom> Because the SQL standard says so. You'd think, but in fact it doesn't; the spec (at least 2008 and the 2011 drafts) has no concept

Re: [HACKERS] Wanting to learn about pgsql design decision

2016-08-02 Thread Tom Lane
Tal Walter writes: >- Why in the roles system, user are actually roles with login attribute >and not a separate entity. Groups and users used to be separate concepts, actually, a long time ago. We got rid of that because it was a PITA; in particular, grants to groups had to be represented

[HACKERS] Wanting to learn about pgsql design decision

2016-08-02 Thread Tal Walter
Dear list, I'm interested in pgsql, and would like to know more about the design decisions behind it's features. Where should I search in order to know more about subjects, for example: - Why in the roles system, user are actually roles with login attribute and not a separate entity. - W