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