From: Tom Lane <tgl@sss.pgh.pa.us>
To: Devrim GUNDUZ <devrim@gunduz.org>
Cc: PostgreSQL Mailing Lists-SQL <pgsql-sql@postgresql.org>
Subject: Re: What am I doing wrong in here?
Date: Sat, 27 Dec 2003 13:42:07 -0500
Message-ID: <12837.1072550527@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.44.0312271557410.26555-100000@emo.org.tr>
References: <Pine.LNX.4.44.0312271557410.26555-100000@emo.org.tr>
Devrim GUNDUZ <devrim@gunduz.org> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, devrim@gunduz.org
Subject: Re: What am I doing wrong in here?
In-Reply-To: <12837.1072550527@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox