Re: [ADMIN] Catalog insertion

2007-07-10 Thread Alvaro Herrera
Carmen Martinez escribió: > 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. We may be able to help y

Re: [ADMIN] Catalog insertion

2007-07-10 Thread Carmen Martinez
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 <[EMAIL PROTECTED]> escribió: On 10/07/07

Re: [ADMIN] Catalog insertion

2007-07-10 Thread Peter Childs
On 10/07/07, Carmen Martinez <[EMAIL PROTECTED]> 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

Re: [ADMIN] Catalog insertion

2007-07-10 Thread Carmen Martinez
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.

Re: [ADMIN] Catalog insertion

2007-07-09 Thread Steve Holdoway
Sounds like a Bad Idea(tm) to me. If you want to create extra systemmy tables, then why not set up your own private resources, and put them there instead??? Steve On Mon, 9 Jul 2007 11:22:05 +0200 (CEST) Carmen Martinez <[EMAIL PROTECTED]> wrote: > I want to insert new tables in the pg_catalog

Re: [ADMIN] Catalog insertion

2007-07-09 Thread Tom Lane
Carmen Martinez <[EMAIL PROTECTED]> 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.

Re: [ADMIN] Catalog insertion

2007-07-09 Thread Alvaro Herrera
Carmen Martinez escribió: > 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

Re: [ADMIN] Catalog insertion

2007-07-09 Thread Carmen Martinez
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 tabl

Re: [ADMIN] Catalog insertion

2007-07-08 Thread Alvaro Herrera
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 c

[ADMIN] Catalog insertion

2007-07-08 Thread Carmen Martinez
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 currentl