Shared table across all databases
От | Mourad EL HADJ MIMOUNE |
---|---|
Тема | Shared table across all databases |
Дата | |
Msg-id | 004801c22815$bcf740a0$71a337c1@ensma.fr обсуждение исходный текст |
Ответ на | Re: update problem? (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: