Permission denied for create table

Поиск
Список
Период
Сортировка
От Pascal Tufenkji
Тема Permission denied for create table
Дата
Msg-id 003401c94e00$ee6235b0$150fa8c0@interne.usj.edu.lb
обсуждение исходный текст
Ответы Re: Permission denied for create table  ("Marcin Stępnicki" <mstepnicki@gmail.com>)
Re: Permission denied for create table  (Richard Huxton <dev@archonet.com>)
Re: Permission denied for create table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">Hello, I’m doing a workshop for my students and I’m teaching them how to create tables in
Postgres.</span></font><pclass="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; 
font-family:Verdana">So I created a database for every student, but I’m facing the following problem:</span></font><p
class="MsoNormal"><fontface="Verdana" size="2"><span style="font-size:10.0pt; 
font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">sql073751=> CREATE TABLE emp1 (id int);</span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New"">CREATE TABLE</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">sql073751=> SELECT * into emp2 from emp;</span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New"">ERROR:  emp: permission denied</span></font><p class="MsoNormal"><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt; 
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">sql073751=> CREATE TABLE emp3 as SELECT * from emp;</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New"">ERROR:  emp: permission denied</span></font><p class="MsoNormal"><font face="Verdana"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">Creating a normal table works fine, but creating a table with subqueries is giving me “permission
denied”</span></font><pclass="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; 
font-family:Verdana">Anyone got a clue?</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size:10.0pt;
font-family:Verdana">P.S. I’m working on PostgreSQL 7.3.2</span></font><p class="MsoNormal"><font face="Verdana"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">Thx </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size:10.0pt;
font-family:Verdana">Pascal</span></font></div>

В списке pgsql-sql по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: simple text parsing function
Следующее
От: "Marcin Stępnicki"
Дата:
Сообщение: Re: Permission denied for create table