Adrian Klaver <aklaver(at)attbi(dot)com> writes:
> I finally tracked down the problem. You have to use the GRANT command to set
> privileges on your table. Postgres assumes the table owner has all rights but
> does do not write that info into the access control list of pg_class. It
> would seem the JDBC driver looks to pg_class for information on permissions.
Hm. The backend treats NULL in pg_class.relacl as meaning the default
permissions (owner = all, everyone else = none). I wonder whether jdbc
gets that right?
regards, tom lane