Re: Permission denied for create table

On Mon, Nov 24, 2008 at 7:50 AM, Pascal Tufenkji <ptufenkji(at)usj(dot)edu(dot)lb> 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? ;-)