Re: Partitioning syntax - Mailing list pgsql-hackers

From David Fetter
Subject Re: Partitioning syntax
Date
Msg-id 20100317135215.GA2577@fetter.org
Whole thread Raw
In response to Re: Partitioning syntax  (Dmitry Fefelov <fozzy@ac-sw.com>)
Responses Re: Partitioning syntax
List pgsql-hackers
On Wed, Mar 17, 2010 at 01:55:45PM +0600, Dmitry Fefelov wrote:
> > Here is a revised partitioning syntax patch. It implements only syntax and
> > on-disk structure mentioned below:
> >     Table Partitioning#Syntax
> >       http://wiki.postgresql.org/wiki/Table_partitioning#Syntax
> >     Table Partitioning#On-disk structure
> >       http://wiki.postgresql.org/wiki/Table_partitioning#On-disk_structure
> 
> Will 9.1 partitions allow to reference partitioned tables in foreign keys?

For now, you can do something like this:

http://people.planetpostgresql.org/dfetter/index.php?/archives/51-Partitioning-Is-Such-Sweet-Sorrow.html

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: Dyamic updates of NEW with pl/pgsql
Next
From: Tom Lane
Date:
Subject: Re: PQftype implementation