Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D20BC9FB2E8 for ; Mon, 9 Jul 2007 06:22:12 -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 14016-02 for ; Mon, 9 Jul 2007 06:22:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web26506.mail.ukl.yahoo.com (web26506.mail.ukl.yahoo.com [217.146.176.43]) by postgresql.org (Postfix) with SMTP id 3C6E89FB1F9 for ; Mon, 9 Jul 2007 06:22:07 -0300 (ADT) Received: (qmail 91516 invoked by uid 60001); 9 Jul 2007 09:22:05 -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=lWmJwLCV6EzkyEJo5K8n2qej6N3xF16Uyp831cQ4OaH412oEnhrE8gyknok/iF2EklrAUITUIvQbGHo9W27bT2RjHIXk/tlbNQcAFaXrGFO+AkN+zyQQ1cezHFGoXPCKe1kVoJ0zfUV0QDd4iPg7/Pt0pTFAvmRncEwWiiire6c= ; Message-ID: <20070709092205.91514.qmail@web26506.mail.ukl.yahoo.com> X-YMail-OSG: Oi8nUxYVM1nUtB0vtYwFf2TUDnQu7wUH9j5A4KJXWJ6ehef4K3bNaYdY4zimPTNZf7iELs0ulqgenuAXHaW0PtbTGQBmPERWUr0GaFoqu9WjcuB5gtvJ2cjlmKE- Received: from [84.76.226.225] by web26506.mail.ukl.yahoo.com via HTTP; Mon, 09 Jul 2007 11:22:05 CEST Date: Mon, 9 Jul 2007 11:22:05 +0200 (CEST) From: Carmen Martinez Subject: Re: Catalog insertion To: Alvaro Herrera Cc: pgsql-admin@postgresql.org In-Reply-To: <20070709004240.GB9539@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1007062090-1183972925=:90868" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/72 X-Sequence-Number: 26053 --0-1007062090-1183972925=:90868 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. Thanks Alvaro Herrera escribió: Carmen Martinez escribió: > Hello, > I am trying to include new tables in the PG catalog. Also, I am doing > that using the JDBC interface in a Java program. But when I connect to > de Postgress template1 database and I execute the CREATE TABLE > sentence an error message appears saying: "System catalog > modifications are currently disallowed". > > Please, I need help to know how to allow to modify the system catalog . What CREATE TABLE exactly? -- Alvaro Herrera http://www.PlanetPostgreSQL.org/ "No hay cielo posible sin hundir nuestras raíces en la profundidad de la tierra" (Malucha Pinto) --------------------------------- 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-1007062090-1183972925=:90868 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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.


Thanks

Alvaro Herrera <alvherre@commandprompt.com> escribió:
Carmen Martinez escribió:
> Hello,
> I am trying to include new tables in the PG catalog. Also, I am doing
> that using the JDBC interface in a Java program. But when I connect to
> de Postgress template1 database and I execute the CREATE TABLE
> sentence an error message appears saying: "System catalog
> modifications are currently disallowed".
>
> Please, I need help to know how to allow to modify the system catalog .

What CREATE TABLE exactly?

--
Alvaro Herrera http://www.PlanetPostgreSQL.org/
"No hay cielo posible sin hundir nuestras raíces
en la profundidad de la tierra" (Malucha Pinto)



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-1007062090-1183972925=:90868--