Doc patch to note which system catalogs have oids

Поиск
Список
Период
Сортировка
Hi,

The attached patch documents the oid column of those
system catalogs having an oid.

Distinguish system catalogs with an oid from those without
and make the primary key clear to the newbie.

Found catalogs with an oid by querying a 9.2 installation:

select pg_class.relkind, pg_class.relname
  from pg_class, pg_attribute
  where pg_attribute.attrelid = pg_class.oid
        and pg_attribute.attname = 'oid'
        and pg_class.relname like 'pg_%'
        and (pg_class.relkind = 'r'    -- table
             or pg_class.relkind = 'v') -- view
  order by pg_class.relkind, pg_class.relname;


Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein


Вложения

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

Предыдущее
От: "Karl O. Pinc"
Дата:
Сообщение: Re: Suggestion for --truncate-tables to pg_restore
Следующее
От: "Karl O. Pinc"
Дата:
Сообщение: Add big fat caution to pg_restore docs regards partial db restores