Skip site navigation (1) Skip section navigation (2)

Re: A Guide to Constraint Exclusion (Partitioning)

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, bizgres-general(at)pgfoundry(dot)org,pgsql-hackers(at)postgresql(dot)org
Subject: Re: A Guide to Constraint Exclusion (Partitioning)
Date: 2005-07-24 19:55:09
Message-ID: 1122234909.21502.317.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-hackers
On Sun, 2005-07-24 at 15:00 -0400, Greg Stark wrote:

> Maybe I'm doing something more obvious wrong?
> 
>   db=> create table _test (a integer);
>   CREATE TABLE
> 
>   db=> create table _test2 (like _test);
>   CREATE TABLE

Yes, unfortunately. You need the phrase "INHERITS (_test)" after the
bracket and before the ; for any tables you want to be children of
_test, such as _test2. The syntax "like..." creates a similar table, but
with no linkage between parent and children.

Best Regards, Simon Riggs


In response to

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2005-07-24 20:06:51
Subject: Re: [HACKERS] Autovacuum loose ends
Previous:From: Magnus HaganderDate: 2005-07-24 19:10:10
Subject: Re: For review: Server instrumentation patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group