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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to