pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Carmen Martinez <carmenmtezcruz@yahoo.es>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Catalog insertion
Date: Mon, 9 Jul 2007 11:22:05 +0200 (CEST)
Message-ID: <20070709092205.91514.qmail@web26506.mail.ukl.yahoo.com> (raw)
In-Reply-To: <20070709004240.GB9539@alvh.no-ip.org>

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

view thread (10+ messages)  latest in thread

Message-ID: <20070709092205.91514.qmail@web26506.mail.ukl.yahoo.com>
Permalink:  ../20070709092205.91514.qmail@web26506.mail.ukl.yahoo.com/
Also on:    postgresql.org/message-id/20070709092205.91514.qmail@web26506.mail.ukl.yahoo.com

 · 

reply

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: carmenmtezcruz@yahoo.es, alvherre@commandprompt.com
  Subject: Re: Catalog insertion
  In-Reply-To: <20070709092205.91514.qmail@web26506.mail.ukl.yahoo.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