reference to system table - Mailing list pgsql-general

From Anton
Subject reference to system table
Date
Msg-id 18738660050.20030119230955@list.ru
Whole thread Raw
Responses Re: reference to system table
List 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 by date:

Previous
From: mike
Date:
Subject: problems configuring with readline and zlib
Next
From: Pablo Yaggi
Date:
Subject: Re: problems configuring with readline and zlib