Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0EE9B9FB478 for ; Tue, 10 Jul 2007 06:43:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 21577-07 for ; Tue, 10 Jul 2007 06:43:07 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ik-out-1112.google.com (ik-out-1112.google.com [66.249.90.180]) by postgresql.org (Postfix) with ESMTP id 01F699FB40B for ; Tue, 10 Jul 2007 06:43:06 -0300 (ADT) Received: by ik-out-1112.google.com with SMTP id c21so880831ika for ; Tue, 10 Jul 2007 02:43:05 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:subject:cc:in-reply-to:mime-version:content-type:references; b=Fnj+L3cumdIeHYcBoZWLeaQPKEHiztey9882vjFR6TsbEcU/KRu5NC+4KlGjo1QFJSQj6FavurUL02RdYgcq5APGh1wlZIN1rXQuFYiv9Q181KicXq/CEX6oKddj9wiTPuvgPPgh4y+iHj0HunutyKkNAsnC/K5VLRHlLK/k9Pg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:subject:cc:in-reply-to:mime-version:content-type:references; b=cNnApcylNkkPCm8GnDXKZVYoBSGhHUA4umOAVZoMyrAhmfUdda5EIFX2soTM4+DPRAea8WJES0eRBIVH5ypn0tO38csQcYVbRaeCvdtIYeZKhxtpIqWfxvxtGrSLr804q3vK3aXBF3bO8QokMa8811V9wOJimpdGo5VTh503Zg4= Received: by 10.78.160.2 with SMTP id i2mr1987325hue.1184060585131; Tue, 10 Jul 2007 02:43:05 -0700 (PDT) Received: by 10.78.146.6 with HTTP; Tue, 10 Jul 2007 02:43:04 -0700 (PDT) Message-ID: Date: Tue, 10 Jul 2007 10:43:04 +0100 From: "Peter Childs" Subject: Re: Catalog insertion Cc: pgsql-admin@postgresql.org In-Reply-To: <20070710090328.73955.qmail@web26506.mail.ukl.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_134495_15438074.1184060584832" References: <20070709133317.GB8121@alvh.no-ip.org> <20070710090328.73955.qmail@web26506.mail.ukl.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/80 X-Sequence-Number: 26061 ------=_Part_134495_15438074.1184060584832 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 10/07/07, Carmen Martinez 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 hav= e > 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 * escribi=F3: > > Carmen Martinez escribi=F3: > > 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>=3D1 AND LEN<=3D10), CONSTRAINT > > TYPE_MUST_BE_1_2_o_3 CHECK (T_TYPE=3D1 OR T_TYPE=3D2 OR T_TYPE=3D3)) > > > > 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=F3viles desde 1 c=E9ntimo por minuto. > http://es.voice.yahoo.com > > ------=_Part_134495_15438074.1184060584832 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

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. Al= so, 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 pos= tgresql.

Any idea it would be welcome. But if this possibility is d= isallowed 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 ser= ver?.

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

Pe= ter.
 

Thank you very much
Carmen.<= br>

Alvaro Herrera < alvherre@commandprompt.com> escribi=F3:
Carmen Marti= nez escribi=F3:
> 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 al= lowed to do that and I do
> not know why.
>
> Following= I show one of the sentences I execute and the error messages
>=20
>
> One of the tables I try to create is:
>
> CR= EATE 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
> varcha= r(100) , PRIMARY KEY (OBJ, COL) , CONSTRAINT
> LEN_TOO_LONG_IN_COL_LIST CHECK (LEN>=3D1 AND LEN<=3D10), CO= NSTRAINT
> TYPE_MUST_BE_1_2_o_3 CHECK (T_TYPE=3D1 OR T_TYPE=3D2 OR T_= TYPE=3D3))
>
> ERROR: permission denied to create "pg_cat= alog.col_list"
> DETAIL: System catalog modifications are currently disallowed.
Oh, you can't do that. It's disallowed by policy. If you wan= t 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 Promp= t, Inc.

---------------------------(end of broadcast)---------------= ------------
TIP 5: don't forget to increase your free space map set= tings

=20 =09=09



LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y m=F3vi= les desde 1 c=E9ntimo por minuto.
http://es.voice.yahoo.com


------=_Part_134495_15438074.1184060584832--