Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 3992E9FB670 for ; Tue, 10 Jul 2007 06:03:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 06976-08 for ; Tue, 10 Jul 2007 06:03:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web26506.mail.ukl.yahoo.com (web26506.mail.ukl.yahoo.com [217.146.176.43]) by postgresql.org (Postfix) with SMTP id D75889FB60F for ; Tue, 10 Jul 2007 06:03:29 -0300 (ADT) Received: (qmail 73957 invoked by uid 60001); 10 Jul 2007 09:03:28 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.es; h=Message-ID:X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=m5fuzJqzgg3nGVVGQy93zdISL9OPiMhj7xz3by8y8qP+Pp5xLAi85ehP805SMBG0Fmga45Tyfjv7Nu5qrFafINYd+IW/nNCaCWBVHrfPM3vSmKBTE1e3fyDTGwVChRT8i/iXxzidMpubIxZZ+k7qAdy2MXFj3sfHw7jY6IxkllQ= ; Message-ID: <20070710090328.73955.qmail@web26506.mail.ukl.yahoo.com> X-YMail-OSG: 8gA_9JsVM1l6z3jm0pMcqhgs18Q30Sz8UDCY.aZxBWaRZ_tB_N01G_8G3R8EUe3VFjL4CGrcP3VVtWs2sYYsiKEt6ghNivTDAq8gwl3766NGBEGQrlZeeWWZ5y8- Received: from [84.76.226.225] by web26506.mail.ukl.yahoo.com via HTTP; Tue, 10 Jul 2007 11:03:28 CEST Date: Tue, 10 Jul 2007 11:03:28 +0200 (CEST) From: Carmen Martinez Subject: Re: Catalog insertion To: Alvaro Herrera , Tom Lane , Steve Holdoway Cc: pgsql-admin@postgresql.org In-Reply-To: <20070709133317.GB8121@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1569123443-1184058208=:73695" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/79 X-Sequence-Number: 26060 --0-1569123443-1184058208=:73695 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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!. Thank you very much Carmen. Alvaro Herrera 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 --0-1569123443-1184058208=:73695 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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!.

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
--0-1569123443-1184058208=:73695--