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 have SELECT permissions on emp table. You are trying to create a emp2 table using data from emp. That won't work if you can't access emp in the first place. > P.S. I'm working on PostgreSQL 7.3.2 Whoa. Are you paleontologist per any chance? ;-) -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
