Catalog insertion

--0-16479318-1183938690=:60616
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hello,
I am trying to include new tables in the PG catalog. Also, I am doing tha=
t using the JDBC interface in a Java program. But when I connect to de Po=
stgress template1 database and I execute the CREATE TABLE sentence an er=
ror message appears saying: "System catalog modifications are currently d=
isallowed".=20

Please, I need help to know how to allow to modify the system catalog .

Thank you very much,

Carmen Mtez.



=20
---------------------------------

S=E9 un Mejor Amante del Cine
=BFQuieres saber c=F3mo? =A1Deja que otras personas te ayuden!.

--0-16479318-1183938690=:60616
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

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 connec=
t to de Postgress template1 database and I execute the CREATE TABLE sente=
nce  an error message appears saying: "System catalog modifications =
are currently disallowed".

Please, I need help to know how to all=
ow to modify the system catalog .

Thank you very much,

Carm=
en Mtez.

Re: Catalog insertion

Carmen Martinez escribi=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 .

What CREATE TABLE exactly?

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: Catalog insertion

--0-1007062090-1183972925=:90868
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

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

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.


Thanks

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 .

What CREATE TABLE exactly?

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


=09
---------------------------------

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y m=F3viles desde 1 c=E9ntimo por minuto.
http://es.voice.yahoo.com
--0-1007062090-1183972925=:90868
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

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.

Foll=
owing 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)  N=
OT NULL, LEN numeric(2)  NOT NULL, COM varchar(100) ,  PRIMARY =
KEY  (OBJ, COL) ,  CONSTRAINT LEN_TOO_LONG_IN_COL_LIST CHECK (L=
EN>=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 denie=
d to create "pg_catalog.col_list"
DETAIL:  System catalog modific=
ations are currently disallowed.


Thanks

Alvaro He=
rrera <alvherre@commandprompt.com> escribi=F3:

lass=3D"replbq" style=3D"border-left: 2px solid rgb(16,
16, 255); margin-left: 5px; padding-left: 5px;"> Carmen Martinez escribi=
=F3:
> Hello,
> I am trying to include new tables in the PG c=
atalog. Also, I am doing
> that using the JDBC interface in a Java =
program. But when I connect to
> de Postgress template1 database an=
d I execute the CREATE TABLE
> sentence an error message appears s=
aying: "System catalog
> modifications are currently disallowed". <=
br>>
> Please, I need help to know how to allow to modify the s=
ystem catalog .

What CREATE TABLE exactly?

--
Alvaro He=
rrera http://www.PlanetPostgreSQL.org/
"=
No hay cielo posible sin hundir nuestras ra=EDces
en la profundidad d=
e la tierra" (Malucha Pinto)

Re: Catalog insertion

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.=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) , 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))
>=20
> 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).

--=20
Alvaro Herrera http://www.CommandPrompt.co=
m/
The PostgreSQL Company - Command Prompt, Inc.

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

Re: Catalog insertion

Carmen Martinez writes:
> I want to insert new tables in the pg_catalog schema.

Why do you think that is a good idea? pg_catalog is for tables used by
the system itself, and it's going to take a lot more than a "create
table" to teach the system to work with a new catalog.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Catalog insertion

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
>
> ---------------------------------
>=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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Catalog insertion

--0-1569123443-1184058208=:73695
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable


I know all you say, but we actually are trying to extend the postresql wi=
th 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.=20

We have also implemented this in Oracle and now we want to do this with p=
ostgresql.=20

Any idea it would be welcome. But if this possibility is disallowed by po=
licy, 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=F3: Carmen Martinez e=
scribi=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.=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) , 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))
>=20
> 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).

--=20
Alvaro Herrera http://www.CommandPrompt.co=
m/
The PostgreSQL Company - Command Prompt, Inc.

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


=09
---------------------------------

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y m=F3viles desde 1 c=E9ntimo por minuto.
http://es.voice.yahoo.com
--0-1569123443-1184058208=:73695
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable


I know all you say, but we actually are trying to extend the postresq=
l 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.
r>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 possibilit=
y 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 int=
o account!.

Thank you very much
Carmen.


Alvaro=
Herrera <alvherre@commandprompt.com> escribi=F3: e class=3D"replbq" style=3D"border-left: 2px solid rgb(16, 16, 255); marg=
in-left: 5px; padding-left: 5px;"> 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 sho=
w one of the sentences I execute and the error messages
>
> =

> One of the tables I try to create is:
>
> CREATE TA=
BLE pg_catalog.COL_LIST ( OBJ OID NOT NULL, COL OID NOT NULL,
> T_T=
YPE numeric(1) NOT NULL, LEN numeric(2) NOT NULL, COM
> varchar(1=
00) , 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))
>
&g=
t; ERROR: permission denied to create "pg_catalog.col_list"
> DETAI=
L: System catalog modifications are currently disallowed.

Oh, you=
can't do that. It's disallowed by policy. If you want to
create cat=
alogs you need to be in standalone or bootstrap mode
(typically they a=
re 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.C=
ommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
>---------------------------(end of broadcast)---------------------------=

TIP 5: don't forget to increase your free space map settings
ckquote>

Re: Catalog insertion

------=_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.htm l

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 r/*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

Re: Catalog insertion

--0-413640091-1184065585=:20213
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

I'd like to use the same system we did with oracle due all the rdbms use =
a catalog in order to store their system tables and structures.=20
Using the CREATE TYPE sentence implies a new implementation totally diffe=
rent from the previous one.=20

Peter Childs escribi=F3:=20

On 10/07/07, Carmen Martinez wrote:=20
I know all you say, but we actually are trying to extend the postresql wi=
th 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.=20

We have also implemented this in Oracle and now we want to do this with =
postgresql.=20

Any idea it would be welcome. But if this possibility is disallowed by po=
licy, 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?.=20

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.htm l

Peter.
=20

Thank you very much
Carmen.


Alvaro Herrera < alvherre@commandprompt.com> escribi=F3: Carmen Martinez =
escribi=F3:=20
> 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.=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) , PRIMARY KEY (OBJ, COL) , CONSTRAINT=20
> 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))
>=20
> ERROR: permission denied to create "pg_catalog.col_list"=20
> 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).

--=20
Alvaro Herrera http://www.CommandPrompt.c=
om/
The PostgreSQL Company - Command Prompt, Inc.

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


=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


=20

=09
---------------------------------

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y m=F3viles desde 1 c=E9ntimo por minuto.
http://es.voice.yahoo.com
--0-413640091-1184065585=:20213
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

I'd like to use the same system we did with oracle due all the rdbms use =
a catalog in order to store their system tables and structures.
Using=
the CREATE TYPE sentence implies a new implementation totally different =
from the previous one.

Peter Childs <peterachilds@gmail.=
com> escribi=F3:

eft: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> <=
br>

On 10/07/07, ndername">Carmen Martinez < es">carmenmtezcruz@yahoo.es> wrote:

il_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
0pt 0pt 0.8ex; padding-left: 1ex;">
I know all you say, but we actua=
lly 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. <=
br>
Any idea it would be welcome. But if this possibility is disallowe=
d 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!. blockquote>

"Create type" I think might be what you need then=
..

see atetype.html"> http://www.postgresql.org/docs/8.2/static/sql-createtype.h=
tml

Peter.
 

" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt=
0.8ex; padding-left: 1ex;"> Thank you very much
Ca=
rmen.


Alvaro Herrera < f=3D"mailto:alvherre@commandprompt.com" target=3D"_blank" onclick=3D"retu=
rn top.js.OpenExtLink(window,event,this)">
alvherre@commandprompt.com> escribi=F3:

class=3D"e" id=3D"q_113af61cd52b05db_3">

2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> Carme=
n Martinez escribi=F3:
> I want to insert new tables in the pg_cat=
alog schema. So I have to
> execute a common create table sentence =
like "Create Table
> pg_catalog.newTable ....", but I am not allow=
ed 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:
>
> CRE=
ATE TABLE pg_catalog.COL_LIST ( OBJ OID NOT NULL, COL OID NOT NULL,
&g=
t; T_TYPE numeric(1) NOT NULL, LEN numeric(2) NOT NULL, COM
> var=
char(100) , PRIMARY KEY (OBJ, COL) , CONSTRAINT
> LEN_TOO_LONG_=
IN_COL_LIST CHECK (LEN>=3D1 AND LEN<=3D10), CONSTRAINT
> TYP=
E_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 current=
ly 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 bootst=
rap mode
(typically they are created by declaring a src/include/catal=
og/*.h file
and having it be included in postgres.bki by the genbki s=
cript).

--
Alvaro Herrera ef=3D"http://www.CommandPrompt.com/" target=3D"_blank" onclick=3D"return =
top.js.OpenExtLink(window,event,this)"> 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

an>

---

"Verdana" size=3D"-2">LLama Gratis a cualquier PC del
Mundo.
Llamadas a fijos y m=F3viles desde 1 c=E9ntimo por minuto.
=
ice.yahoo.com/" target=3D"_blank" onclick=3D"return top.js.OpenExtLink(wi=
ndow,event,this)"> http://es.voice.yahoo.com

=

Re: Catalog insertion

Carmen Martinez escribi=F3:
> I'd like to use the same system we did with oracle due all the rdbms
> use a catalog in order to store their system tables and structures.=20
> Using the CREATE TYPE sentence implies a new implementation totally
> different from the previous one.=20

We may be able to help you, but we can't if you don't say what you
actually want to do (rather than _how_ you think you should do it).
Keep in mind that this is a different system from Oracle and things may
be done differently.

There's a spanish mail list (pgsql-es-ayuda) on this very same server.
You may be able to explain yourself better there (and I'll be able to
respond more quickly).

--=20
Alvaro Herrera http://www.CommandPrompt.co=
m/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match