What am I doing wrong in here?
От | Devrim GUNDUZ |
---|---|
Тема | What am I doing wrong in here? |
Дата | |
Msg-id | Pine.LNX.4.44.0312271557410.26555-100000@emo.org.tr обсуждение исходный текст |
Ответы |
Re: What am I doing wrong in here?
Re: What am I doing wrong in here? |
Список | pgsql-sql |
-----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 oni686-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 tdmsoftmailserverWITH 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, domainvarchar(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-----
В списке pgsql-sql по дате отправления: