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 66677D1B494 for ; Sat, 27 Dec 2003 15:13:55 +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 47484-09 for ; Sat, 27 Dec 2003 11:13:10 -0400 (AST) Received: from emo.org.tr (emo.org.tr [195.142.105.9]) by svr1.postgresql.org (Postfix) with ESMTP id 42150D1B481 for ; Sat, 27 Dec 2003 11:13:05 -0400 (AST) Received: by emo.org.tr (Postfix, from userid 41643) id 7A863EE358; Sat, 27 Dec 2003 17:13:02 +0200 (EET) Received: from localhost (localhost [127.0.0.1]) by emo.org.tr (Postfix) with ESMTP id 73FC5EE357 for ; Sat, 27 Dec 2003 17:13:02 +0200 (EET) Date: Sat, 27 Dec 2003 17:12:58 +0200 (EET) From: Devrim GUNDUZ X-X-Sender: devrim2@emo.org.tr To: PostgreSQL Mailing Lists-SQL Subject: What am I doing wrong in here? 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/201 X-Sequence-Number: 16367 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I'm tyring to create a new table/database/user; and I get some errors. I'm running: postgres@[local]:template1=# SELECT version(); version - ------------------------------------------------------------------------------------------------------- PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2 20031022 (Red Hat Linux 3.3.2-1) which has been installed using Lamar's RPMS. Here is set of commands: ========================================================= CREATE USER tdmsoftmailserveruser WITH ENCRYPTED PASSWORD 'test' NOCREATEDB NOCREATEUSER; CREATE DATABASE tdmsoftmailserver WITH ENCODING 'LATIN5' OWNER=tdmsoftmailserveruser; \c tdmsoftmailserver tdmsoftmailserveruser CREATE TABLE public.tdmalias ( mid serial, address varchar(255) NOT NULL default '' PRIMARY KEY, goto text NOT NULL, domain varchar(255) NOT NULL default '', create_date timestamp NOT NULL DEFAULT 'NOW', change_date timestamp NOT NULL DEFAULT 'NOW', active int2 NOT NULL default '1' ); ============================ 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 Google'd a bit; but could not find a solution for that. Is is something with schemas? 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/7aF+tl86P3SPfQ4RAtC7AJ974H/j5rWlTYP32De+LYLgEb2GmgCePZFW QHbdSSw9OKvY0cF/nYbUM5g= =3jq0 -----END PGP SIGNATURE-----