Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0AEA49FBAC4 for ; Mon, 9 Jul 2007 17:15:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 68315-06 for ; Mon, 9 Jul 2007 17:15:43 -0300 (ADT) X-Greylist: delayed 00:32:32.524919 by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id A949A9FBC4A for ; Mon, 9 Jul 2007 17:15:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from server.firetrust.net (mailserver.firetrust.com [209.213.221.13]) by svr4.postgresql.org (Postfix) with ESMTP id 985565AF024 for ; Mon, 9 Jul 2007 19:43:13 +0000 (GMT) Received: from localhost.localdomain (203-97-61-135.dsl.clear.net.nz [203.97.61.135]) by server.firetrust.net (8.14.1/8.14.1) with SMTP id l69Jh9GQ005652 for ; Tue, 10 Jul 2007 07:43:10 +1200 Date: Tue, 10 Jul 2007 07:45:27 +1200 From: Steve Holdoway To: pgsql-admin@postgresql.org Subject: Re: Catalog insertion Message-Id: <20070710074527.ecb0ab8a.steve.holdoway@firetrust.com> In-Reply-To: <20070709092205.91514.qmail@web26506.mail.ukl.yahoo.com> References: <20070709004240.GB9539@alvh.no-ip.org> <20070709092205.91514.qmail@web26506.mail.ukl.yahoo.com> Organization: Firetrust Ltd X-Mailer: Sylpheed version 2.3.0beta5 (GTK+ 2.8.20; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-MailWasher-Server-Scanned: Checked by MailWasher server v2.2.3 (www.Firetrust.com) X-MailWasher-Server-Status: Clean X-Virus-Scanned: ClamAV 0.90.3/3615/Tue Jul 10 02:28:23 2007 on server.firetrust.net X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/75 X-Sequence-Number: 26056 Sounds like a Bad Idea(tm) to me. If you want to create extra systemmy tabl= es, then why not set up your own private resources, and put them there inst= ead??? Steve On Mon, 9 Jul 2007 11:22:05 +0200 (CEST) Carmen Martinez wrote: > I want to insert new tables in the pg_catalog schema. So I have to execut= e 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.=20 >=20 > Following I show one of the sentences I execute and the error messages >=20 >=20 > One of the tables I try to create is: >=20 > 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) , PR= IMARY KEY (OBJ, COL) , CONSTRAINT LEN_TOO_LONG_IN_COL_LIST CHECK (LEN>=3D= 1 AND LEN<=3D10), CONSTRAINT TYPE_MUST_BE_1_2_o_3 CHECK (T_TYPE=3D1 OR T_T= YPE=3D2 OR T_TYPE=3D3)) >=20 > ERROR: permission denied to create "pg_catalog.col_list" > DETAIL: System catalog modifications are currently disallowed. >=20 >=20 > Thanks >=20 > Alvaro Herrera escribi=F3: Carmen Martinez e= scribi=F3: > > 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".=20 > >=20 > > Please, I need help to know how to allow to modify the system catalog . >=20 > What CREATE TABLE exactly? >=20 > --=20 > Alvaro Herrera http://www.PlanetPostgreSQL.= org/ > "No hay cielo posible sin hundir nuestras ra=EDces > en la profundidad de la tierra" (Malucha Pinto) >=20 >=20 > =09 > --------------------------------- >=20 > LLama Gratis a cualquier PC del Mundo. > Llamadas a fijos y m=F3viles desde 1 c=E9ntimo por minuto. > http://es.voice.yahoo.com