"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 no
Pascal Tufenkji wrote:
>
> P.S. I'm working on PostgreSQL 7.3.2
In case you missed Marcin's comment - don't use this version. Upgrade.
Version 7.3 is no longer supported by the core developers. Even if you
were determined to run 7.3 you should have upgraded to 7.3.21 at some point.
Read through
On Mon, Nov 24, 2008 at 7:50 AM, Pascal Tufenkji <[EMAIL PROTECTED]> wrote:
> sql073751=> SELECT * into emp2 from emp;
>
> ERROR: emp: permission denied
> Creating a normal table works fine, but creating a table with subqueries is
> giving me "permission denied"
>
> Anyone got a clue?
You don't
