Re: reference to system table

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: reference to system table
Дата
Msg-id 200301260158.h0Q1wod22458@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: reference to system table  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
Stephan Szabo wrote:
> On Sun, 19 Jan 2003, Anton wrote:
>
> > Is there a way to create reference to any system relation?
>
> Not really in general.  System tables aren't guaranteed to go
> through the same steps for updating as user tables.

Right.  The best you can do is to create a table that has the extra
column and a userid column, then create a join that shows the join of
pg_shadow and your new table.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: libpq.so.2.2 & libpq.so.3.0
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: passwords and 7.3