Partitioning (was Re: Slightly OT.) - Mailing list pgsql-general

From Ron Johnson
Subject Partitioning (was Re: Slightly OT.)
Date
Msg-id 4660E077.3040309@cox.net
Whole thread Raw
In response to Re: Slightly OT.  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Partitioning (was Re: Slightly OT.)  (Jeff Davis <pgsql@j-davis.com>)
List 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!


pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: One last Slony question (was Re: Slightly OT.)
Next
From: "Islam Hegazy"
Date:
Subject: debugging C functions