Partitioning (was Re: Slightly OT.)

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Partitioning (was Re: Slightly OT.)
Date: 2007-06-02 03:13:59
Message-ID: 4660E077.3040309@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 06/01/07 19:29, Jeff Davis wrote:
[snip]
> You shouldn't use a volatile function in a check constraint. Use a
> trigger instead, but even that is unlikely to work for enforcing
> constraints correctly.
>
> In general, for partitioning, you have to make some sacrifices. It's
> very challenging (and/or expensive) to ensure uniqueness across
> partitions.

Are partitioned databases the same as federated databases?

--
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Islam Hegazy 2007-06-02 03:24:55 debugging C functions
Previous Message Ron Johnson 2007-06-02 03:00:46 Re: One last Slony question (was Re: Slightly OT.)