Rich LIKE inheritance - Mailing list pgsql-general

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!