[mb-devel] Re: Why create the constraints after table creation?

Robert Kaye rob at eorbit.net
Mon Oct 23 21:17:56 UTC 2006


On Oct 22, 2006, at 8:40 AM, Matt Perry wrote:

> On Sun, 22 Oct 2006, Steve Wyles wrote:
>
>> On Sat, 21 Oct 2006, Matt Perry wrote:
>>
>> The contraints aren't always required, for instance they aren't  
>> used in replicated slaves.
>
> Since the SQL essentially acts as documentation it would make more
> sense to combine the statements into create table and just drop all
> the constraints on slaves.

I see what you're saying -- but keeping them separate is desirable  
for greater overall flexibility. I think the best way to fix the  
documentation problem is by writing actual documentation, rather than  
having to rely on SQL statements as our core docs.

Anyone feel like drawing some graphs?

--

--ruaok      Somewhere in Texas a village is *still* missing its idiot.

Robert Kaye     --     rob at eorbit.net     --    http://mayhem-chaos.net





More information about the MusicBrainz-devel mailing list