From: Peter Childs <peterachilds@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Catalog insertion
Date: Tue, 10 Jul 2007 10:43:04 +0100
Message-ID: <a2de01dd0707100243k48a550aaubc884d24da2efcf0@mail.gmail.com> (raw)
In-Reply-To: <20070710090328.73955.qmail@web26506.mail.ukl.yahoo.com>
References: <20070709133317.GB8121@alvh.no-ip.org>
<20070710090328.73955.qmail@web26506.mail.ukl.yahoo.com>
On 10/07/07, Carmen Martinez <carmenmtezcruz@yahoo.es> wrote:
>
>
> I know all you say, but we actually are trying to extend the postresql
> with new data types, and they must be theorically in the system catalog.
> Also, these new data types go with some functions for manage it.
>
> We have also implemented this in Oracle and now we want to do this with
> postgresql.
>
> Any idea it would be welcome. But if this possibility is disallowed by
> policy, and I use the database as a server, how can I solve it?. Do I have
> to disallowed all conexions and then do these tasks in the server?.
>
> Ahh, I am working in windows so please take it into account!.
"Create type" I think might be what you need then.
see http://www.postgresql.org/docs/8.2/static/sql-createtype.html
Peter.
Thank you very much
> Carmen.
>
>
> *Alvaro Herrera <alvherre@commandprompt.com>* escribió:
>
> Carmen Martinez escribió:
> > I want to insert new tables in the pg_catalog schema. So I have to
> > execute a common create table sentence like "Create Table
> > pg_catalog.newTable ....", but I am not allowed to do that and I do
> > not know why.
> >
> > Following I show one of the sentences I execute and the error messages
> >
> >
> > One of the tables I try to create is:
> >
> > CREATE TABLE pg_catalog.COL_LIST ( OBJ OID NOT NULL, COL OID NOT NULL,
> > T_TYPE numeric(1) NOT NULL, LEN numeric(2) NOT NULL, COM
> > varchar(100) , PRIMARY KEY (OBJ, COL) , CONSTRAINT
> > LEN_TOO_LONG_IN_COL_LIST CHECK (LEN>=1 AND LEN<=10), CONSTRAINT
> > TYPE_MUST_BE_1_2_o_3 CHECK (T_TYPE=1 OR T_TYPE=2 OR T_TYPE=3))
> >
> > ERROR: permission denied to create "pg_catalog.col_list"
> > DETAIL: System catalog modifications are currently disallowed.
>
> Oh, you can't do that. It's disallowed by policy. If you want to
> create catalogs you need to be in standalone or bootstrap mode
> (typically they are created by declaring a src/include/catalog/*.h file
> and having it be included in postgres.bki by the genbki script).
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>
> ------------------------------
>
> LLama Gratis a cualquier PC del Mundo.
> Llamadas a fijos y móviles desde 1 céntimo por minuto.
> http://es.voice.yahoo.com<http://us.rd.yahoo.com/mail/es/tagline/messenger/*http://es.voice.yahoo...;
>
>
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-admin@postgresql.org
Cc: peterachilds@gmail.com
Subject: Re: Catalog insertion
In-Reply-To: <a2de01dd0707100243k48a550aaubc884d24da2efcf0@mail.gmail.com>
* 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