Re: [HACKERS] Why doesn't psql use the information schema to get ACL description ?

2011-08-25 Thread Dave Cramer
On Thu, Aug 25, 2011 at 5:51 PM, Jim Nasby wrote: > On Aug 23, 2011, at 1:57 PM, Peter Eisentraut wrote: >>> Ultimately my ulterior motive is to make sure the information schema >>> is actually useful and ensure that it maintains that status. >> >> The information schema only exposes privileges de

Re: [HACKERS] Why doesn't psql use the information schema to get ACL description ?

2011-08-25 Thread Jim Nasby
On Aug 23, 2011, at 1:57 PM, Peter Eisentraut wrote: >> Ultimately my ulterior motive is to make sure the information schema >> is actually useful and ensure that it maintains that status. > > The information schema only exposes privileges defined in the SQL > standard on objects defined in the SQ

Re: [HACKERS] Why doesn't psql use the information schema to get ACL description ?

2011-08-23 Thread Peter Eisentraut
On tis, 2011-08-23 at 12:48 -0400, Dave Cramer wrote: > Recently a bug was reported on the JDBC list regarding table > privileges. It turns out that we have not been parsing the ACL tables > correctly. This is partially due to having to track the catalogs > through each version. So this breaks down

[HACKERS] Why doesn't psql use the information schema to get ACL description ?

2011-08-23 Thread Dave Cramer
Recently a bug was reported on the JDBC list regarding table privileges. It turns out that we have not been parsing the ACL tables correctly. This is partially due to having to track the catalogs through each version. So this breaks down into two questions 1) is it possible to get all of the ACL d