Обсуждение: Rich LIKE inheritance

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

Rich LIKE inheritance

От
Reg Me Please
Дата:
Hi all.

Is there a way to inherit from a table with the LIKE construct and
also get its indexes along with contraints, DEFAULTs and NOT NULLs?

An example:

CREATE TABLE story_base (
  flag BOOL NOT NULL DEFAULT TRUE,
  starting TIMESTAMP NOT NULL DEFAULT '-INFINITY',
  ending TIMESTAMP NOT NULL DEFAULT 'INFINTY'
);

CREATE INDEX i_story_base
  ON story_base( flag,starting,ending );

CREATE TABLE atable (
  sometext TEXT,
  LIKE story_base INCLUDING DEFAULTS
);

I'd like atable to also "inherit" an index like the one defined for
story_base.

Any hint?

--
Reg me, please!

Re: Rich LIKE inheritance

От
Richard Huxton
Дата:
Reg Me Please wrote:
> Hi all.
>
> Is there a way to inherit from a table with the LIKE construct and
> also get its indexes along with contraints, DEFAULTs and NOT NULLs?

CREATE TABLE ... LIKE isn't inheritance, it's copying the structure.

I believe you can duplicate indexes in 8.3.

--
   Richard Huxton
   Archonet Ltd