Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 88C0B633923 for ; Mon, 3 Aug 2009 09:23:12 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 09917-09 for ; Mon, 3 Aug 2009 12:23:01 +0000 (UTC) X-Greylist: delayed 00:14:33.406167 by SQLgrey-1.7.6 Received: from KECGATE08.infosys.com (Kecgate08.infosysconsulting.com [122.98.10.33]) by mail.postgresql.org (Postfix) with ESMTP id 235A863348C for ; Mon, 3 Aug 2009 09:23:00 -0300 (ADT) X-TM-IMSS-Message-ID: Received: from blrkechub01.ad.infosys.com ([10.66.236.41]) by KECGATE08.infosys.com ([122.98.10.33]) with ESMTP (TREND IMSS SMTP Service 7.0) id f8ee0b8d001a31d1 ; Mon, 3 Aug 2009 17:40:31 +0530 Received: from BLRKECMBX01.ad.infosys.com ([10.66.236.21]) by blrkechub01.ad.infosys.com ([10.66.236.41]) with mapi; Mon, 3 Aug 2009 17:38:23 +0530 From: Venkateswara Rao Bondada To: "pgsql-sql@postgresql.org" Date: Mon, 3 Aug 2009 17:38:21 +0530 Subject: Create table command fails with permission denied Thread-Topic: Create table command fails with permission denied Thread-Index: AcoUMxghWlCW6TQyQ6iY3Ri+Bv3Tcg== Message-ID: <22640DE58AF78445BA8AB69FF76F07321AA2C20BAB@BLRKECMBX01.ad.infosys.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_22640DE58AF78445BA8AB69FF76F07321AA2C20BABBLRKECMBX01ad_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.184 tagged_above=-10 required=5 tests=BAYES_40=-0.185, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200908/9 X-Sequence-Number: 32918 --_000_22640DE58AF78445BA8AB69FF76F07321AA2C20BABBLRKECMBX01ad_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I'm new to PostgreSQL, and currently facing an issue with PostgreSQL 7.4 da= tabase. I'm getting the following error when tried to create a table. Pleas= e let me know the steps (with queries) that I should take care to resolve t= his issue. cms=3D# create table test(id character varying(80)); ERROR: could not create relation "test": Permission denied Thanks in advance, Venkat --_000_22640DE58AF78445BA8AB69FF76F07321AA2C20BABBLRKECMBX01ad_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

I’m new to PostgreSQL, and currently facing an i= ssue with PostgreSQL 7.4 database. I’m getting the following error when tr= ied to create a table. Please let me know the steps (with queries) that I shoul= d take care to resolve this issue.

cms=3D# create table test(id character varying(80));

ERROR: could not create relation "test"= ;: Permission denied

Thanks in advance,

Venkat

--_000_22640DE58AF78445BA8AB69FF76F07321AA2C20BABBLRKECMBX01ad_--