"Pascal Tufenkji" <[EMAIL PROTECTED]> writes: > Creating a normal table works fine, but creating a table with subqueries is > giving me "permission denied"
You need to explicitly grant select permission on the child tables not just the parent. > P.S. I'm working on PostgreSQL 7.3.2 As already noted, you really ought to update that ... among other things, the documentation in recent versions explicitly covers the point above ;-) regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql