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

Re: Automating Partitions in PostgreSQL - Query on syntax

From: "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
To: Kedar Potdar <kedar(dot)potdar(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Automating Partitions in PostgreSQL - Query on syntax
Date: 2009-04-21 18:48:07
Message-ID: 1240339687.7167.34.camel@analise3.cresoltec.com.br (view raw or flat)
Thread:
Lists: pgsql-hackers
Em Ter, 2009-04-21 às 19:33 +0530, Kedar Potdar escreveu:

(...)

> You can have multiple columns as partition key attributes and values
> for these attributes should appear in the order specified. 

How would be the behavior if the partition keys are foreing key with ON
UPDATE CASCADE? I'm thinking in the scenario that this is allowed we can
do a update that don't satisfies the actual partition rule but another
in other partition, so the data will be moved?

This make senses?

[]s
Dickson S. Guedes 
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://guedesoft.net - http://planeta.postgresql.org.br

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-04-21 18:51:36
Subject: Re: Automating Partitions in PostgreSQL - Query on syntax
Previous:From: Tom LaneDate: 2009-04-21 18:43:37
Subject: Re: [ADMIN] License Issue

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