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 D1577D1B48B for ; Sat, 27 Dec 2003 18:43:00 +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 71990-06 for ; Sat, 27 Dec 2003 14:42:11 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 7FF13D1B44F for ; Sat, 27 Dec 2003 14:42:10 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hBRIg719012838; Sat, 27 Dec 2003 13:42:07 -0500 (EST) To: Devrim GUNDUZ Cc: PostgreSQL Mailing Lists-SQL Subject: Re: What am I doing wrong in here? In-reply-to: References: Comments: In-reply-to Devrim GUNDUZ message dated "Sat, 27 Dec 2003 17:12:58 +0200" Date: Sat, 27 Dec 2003 13:42:07 -0500 Message-ID: <12837.1072550527@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/208 X-Sequence-Number: 16374 Devrim GUNDUZ writes: > And I get: > NOTICE: CREATE TABLE will create implicit sequence "tdmalias_mid_seq" for > "serial" column "tdmalias.mid" > ERROR: permission denied for schema pg_catalog I can't replicate that here: I get NOTICE: CREATE TABLE will create implicit sequence "tdmalias_mid_seq" for "serial" column "tdmalias.mid" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "tdmalias_pkey" for table "tdmalias" CREATE TABLE tdmsoftmailserver=> The nearby comments about needing to be superuser to create a user seem to me to be well wide of the mark, since you'd have failed much earlier than this in the script if that were the issue. What do you get from "select * from pg_namespace" in the database where this happens? regards, tom lane