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?  (Casey Allen Shobe <cshobe@softhome.net>)
Re: What am I doing wrong in here?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "D'Arcy J.M. Cain"
Дата:
Сообщение: Re: Anti log in PostgreSQL
Следующее
От: Casey Allen Shobe
Дата:
Сообщение: Re: What am I doing wrong in here?