Re: Create GLOBAL TABLE

Marius Cornea wrote:
> 1.The sintax for create table is :
> CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
> { column_name data_type [ DEFAULT default_expr ] [ column_constraint [
> ... ] ] ...
>
> What mean the parameter GLOBAL|LOCAL ??

http://www.postgresql.org/docs/8.0/static/sql-createtable.html

"Optionally, GLOBAL or LOCAL can be written before TEMPORARY or TEMP.
This makes no difference in PostgreSQL, but see Compatibility."

> 2. in pg_class it is a field "relisshared" how can i use it ?
> 3.1 how can I use BKI script ?,
> 3.2 it is posible to modify postgres.bki to create another table with
> initdb script ?
> like: "create bootstrap shared_relation .." ?

It almost certainly *is* possible to add your own system table. However,
that's probably not something to do without taking time to make sure you
know what you're doing. It will also mean your PostgreSQL installation
will be different from everyone else's.

First thing to do is search the mailing list archives and see if anyone
else has done the same.
http://archives.postgresql.org/

Then, I'd see how an existing table was added (say pg_authid which I
think is new in 8.1 to handle roles). There is a new cvs browser from
command-prompt - details here.
http://archives.postgresql.org/pgsql-general/2005-10/msg00852.php

Not sure if you might want to look at whether you need to allocate
another fixed OID for your new shared table too.

Check it looks possible and then post details of your plan on the
hackers list and see what they say.

--
Richard Huxton
Archonet Ltd