Hi,
There are some ways to create or make table shared across all databases in
the cluster?
I have created a table in the template1 and I updated his definition in
pg_class like in the exemple below:
$ psql template1
.....
template1=# CREATE TABLE shared_table (ID SERIAL8,
template1=#
name VARCHAR UNIQUE);
create sequence......
create index ...........
CREATE
template1=# UPDATE pg_class SET relisshared = TRUE WHERE relname
='shared_table';
UPDATE 1
template1=# insert into shared_table values (1, 'test');
NOTICE: RelationBuildDesc: can't open shared_table: No such file or
directory
ERROR: cannot open shared_table: No such file or directory
NOTICE: RelationBuildDesc: can't open shared_table: No such file or
directory
ERROR: cannot open shared_table: No such file or directory
So, I made some investigation and I realised that shared tables are stored
in C:\cygwin\usr\local\pgsql\data\global.
But the shared_table I created is stored in the
C:\cygwin\usr\local\pgsql\data\base\test.
There is some command which allows shared tables creation?
Thanks for your help.
Mourad.