reference to system table

Поиск
Список
Период
Сортировка
От Anton
Тема reference to system table
Дата
Msg-id 18738660050.20030119230955@list.ru
обсуждение исходный текст
Ответы Re: reference to system table  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
Hello everybody!

Is there a way to create reference to any system relation?

For example I'd like to create relation which extends pg_shadow with
some attributes such as reference to relation of physical person,
information about worker etcetera.

Thanks in advance
--
  Anton


ps My stupid tries:

If I've tried to create reference to pg_shadow(usesysid) pgsql raised
an error.

Then I've tried to inherit pg_shadow but due to inheritance
restriction usesysid and usename become not unique. And if I insert a
tuple into new relation user shouldn't appear in the db.


В списке pgsql-general по дате отправления:

Предыдущее
От: mike
Дата:
Сообщение: problems configuring with readline and zlib
Следующее
От: Pablo Yaggi
Дата:
Сообщение: Re: problems configuring with readline and zlib