Re: [GENERAL] Column privileges and Hibernate (SOLVED)

2010-01-05 Thread Tom Lane
Stephen Frost writes: > This begs the question of if this is something PG should just allow > rather than denying the update. AFAICT, throwing a permissions error for "UPDATE SET foo = foo" is required by the SQL standard. There's nothing in there about "it's okay depending on what you assign to

Re: [GENERAL] Column privileges and Hibernate (SOLVED)

2010-01-05 Thread Craig Ringer
Stephen Frost wrote: > * Craig Ringer (cr...@postnewspapers.com.au) wrote: >> The issue with column privs is that Hibernate lists all columns, even >> ones it hasn't set or altered, in the INSERT and UPDATE statements it >> issues. Column privileges are checked based on the INSERT or UPDATE >> colu

Re: [GENERAL] Column privileges and Hibernate (SOLVED)

2010-01-05 Thread Stephen Frost
* Craig Ringer (cr...@postnewspapers.com.au) wrote: > The issue with column privs is that Hibernate lists all columns, even > ones it hasn't set or altered, in the INSERT and UPDATE statements it > issues. Column privileges are checked based on the INSERT or UPDATE > column list, not the actual val

Re: [GENERAL] Column privileges and Hibernate (SOLVED)

2010-01-05 Thread Craig Ringer
Craig Ringer wrote: > One of the apps using the database uses the Hibernate ORM system for > Java. While excellent in most ways, it's giving me some trouble when it > comes to inserts/updates on tables with column privileges. > > It's easy enough to tell Hibernate that certain columns are not > in