X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6C917D1B48A for ; Sat, 27 Dec 2003 15:46:14 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 55968-02 for ; Sat, 27 Dec 2003 11:45:28 -0400 (AST) Received: from emo.org.tr (emo.org.tr [195.142.105.9]) by svr1.postgresql.org (Postfix) with ESMTP id 01107D1B462 for ; Sat, 27 Dec 2003 11:45:24 -0400 (AST) Received: by emo.org.tr (Postfix, from userid 41643) id 67D04EE358; Sat, 27 Dec 2003 17:45:24 +0200 (EET) Received: from localhost (localhost [127.0.0.1]) by emo.org.tr (Postfix) with ESMTP id 619FFEE357 for ; Sat, 27 Dec 2003 17:45:24 +0200 (EET) Date: Sat, 27 Dec 2003 17:45:20 +0200 (EET) From: Devrim GUNDUZ X-X-Sender: devrim2@emo.org.tr To: PostgreSQL Mailing Lists-SQL Subject: Re: What am I doing wrong in here? In-Reply-To: <200312271024.03665.cshobe@softhome.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/204 X-Sequence-Number: 16370 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Sat, 27 Dec 2003, Casey Allen Shobe wrote: > > ERROR: permission denied for schema pg_catalog > > The user you create the user as needs to have createuser permission. > alter user "foo" with createuser; > > ...(run as an appropriate user) will grant the user such permission. Hmm, that solved the problem, thanks. But I still could not understand why the lack of createuser permission caused the error above... Regards, - -- Devrim GUNDUZ devrim@gunduz.org devrim.gunduz@linux.org.tr http://www.TDMSoft.com http://www.gunduz.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE/7akUtl86P3SPfQ4RAkBRAJ9gHSdmypPYYJRFEkLjgwbcQwB1ugCg1iE2 goLf9LvTeQkblKho+e5yUk8= =Y7Vg -----END PGP SIGNATURE-----