This is a multi-part message in MIME format.
--------------090107010309060303050002
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Venkateswara Rao Bondada wrote:
>
> Hi,
>
> I'm new to PostgreSQL, and currently facing an issue with PostgreSQL
> 7.4 database. I'm getting the following error when tried to create a
> table. Please let me know the steps (with queries) that I should take
> care to resolve this issue.
>
>
>
> cms=# create table test(id character varying(80));
>
> ERROR: could not create relation "test": Permission denied
>
>
>
> Thanks in advance,
>
> Venkat
>
login with postgres user like psql -Upostgres cms and THEN execute
create table statement.
OR
Refer this : http://www.postgresql.org/docs/7.4/static/sql-grant.html
--
Regards,
* *
*Amit Jain **
Synechron Technology Pvt. Ltd.*
Pune 411 057.
Phone : +91.20.40262000 Ext 2162 | Mobile:+91.9373415075 | Fax:
+91.20.30513500
http://www.synechron.com | MailTo: amitjain [at] synechron.com
--------------090107010309060303050002
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<br>
Venkateswara Rao Bondada wrote:
<blockquote
cite="mid:22640DE58AF78445BA8AB69FF76F07321AA2C20C0C [at] BLRKECM BX01.ad.infosys.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
..MsoChpDefault
{mso-style-type:export-only;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="Section1">
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal">I’m new to PostgreSQL, and currently facing an
issue
with PostgreSQL 7.4 database. I’m getting the following error when
tried
to create a table. Please let me know the steps (with queries) that I
should
take care to resolve this issue.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">cms=# create table test(id character
varying(80));<o:p></o:p></p>
<p class="MsoNormal">ERROR: could not create relation "test":
Permission denied<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks in advance,<o:p></o:p></p>
<p class="MsoNormal">Venkat<o:p></o:p></p>
</div>
</blockquote>
<br>
<br>
login with postgres user like psql -Upostgres cms and THEN execute
create table statement. <br>
<br>
OR<br>
Refer this :
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/7.4/static/sql-grant.html">http://www.postgresql.org/docs/7.4/static/sql-grant.html</a><br>
<div class="moz-signature">-- <br>
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="ProgId" content="Word.Document">
<meta name="Generator" content="Microsoft Word 11">
<meta name="Originator" content="Microsoft Word 11">
<link rel="File-List" href="amit_files/filelist.xml">
<title>Regards, </title>
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>Amit</o:Author>
<o:LastAuthor>Amit</o:LastAuthor>
<o:Revision>1</o:Revision>
<o:TotalTime>2</o:TotalTime>
<o:Created>2009-05-28T13:41:00Z</o:Created>
<o:LastSaved>2009-05-28T13:43:00Z</o:LastSaved>
<o:Pages>1</o:Pages>
<o:Words>30</o:Words>
<o:Characters>177</o:Characters>
<o:Company>Synechron</o:Company>
<o:Lines>1</o:Lines>
<o:Paragraphs>1</o:Paragraphs>
<o:CharactersWithSpaces>206</o:CharactersWithSpaces>
<o:Version>11.5606</o:Version>
</o:DocumentProperties>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridI
nCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:536871559 0 0 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]--><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1"/>
</o:shapelayout></xml><![endif]-->
<div class="Section1">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: Verdana;">Regards, <o:p></o:p></span></p>
<p class="MsoNormal"><b><span
style="font-size: 10pt; font-family: Verdana; color: blue;"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span
style="font-size: 10pt; font-family: Verdana; color: blue;">Amit Jain </span></b><b><span
style="font-size: 10pt; font-family: Verdana;"><br>
Synechron Technology Pvt. Ltd.<o:p></o:p></span></b></p>
<p class="MsoNormal"><span class="SpellE"><span class="GramE"><span
style="font-size: 10pt; font-family: Verdana;">Pune</span></span></span><span
class="GramE"><span style="font-size: 10pt; font-family: Verdana;">
411 057.</span></span><span
style="font-size: 10pt; font-family: Verdana;"><br>
<span class="GramE">Phone :</span> +91.20.40262000 Ext 2162 |
Mobile:+91.9373415075 | Fax: +91.20.30513500 <br>
<a class="moz-txt-link-freetext" href="http://www.synechron.com">http://www.synechron.com</a> | MailTo: <a class="moz-txt-link-abbreviated" href="mailto:amitjain [at] synechron.com">amitjain [at] synechron.com</a></span><span
style=""><br style="">
<!--[if !supportLineBreakNewLine]--><br style="">
<!--[endif]--><o:p></o:p></span></p>
</div>
</div>
</body>
</html>
--------------090107010309060303050002--
