Partitioning (was Re: Slightly OT.)

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!