Re: Permission denied for create table

"Pascal Tufenkji" <ptufenkji@usj.edu.lb> 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