Re: Rich LIKE inheritance

From: Richard Huxton <dev(at)archonet(dot)com>
To: Reg Me Please <regmeplease(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Rich LIKE inheritance
Date: 2007-12-19 20:18:23
Message-ID: 47697C8F.3040500@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-12-19 20:24:09 Re: Deploy postgres - upgrade strategy
Previous Message Robert Treat 2007-12-19 20:17:03 phpPgAdmin 4.2-Beta-1 translation status