[SQL] Permission denied for create table

2008-11-23 Thread Pascal Tufenkji
Hello, I'm doing a workshop for my students and I'm teaching them how to create tables in Postgres. So I created a database for every student, but I'm facing the following problem: sql073751=> CREATE TABLE emp1 (id int); CREATE TABLE sql073751=> SELECT * into emp2 from emp; ERROR: emp:

Re: [SQL] Permission denied for create table

2008-11-23 Thread Marcin Stępnicki
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