Re: Declarative partitioning grammar
Markus Wanner <markus@bluegap.ch>
From: Markus Schiltknecht <markus@bluegap.ch>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jeff Cohen <jcohen@greenplum.com>, Warren Turkal <turkal@google.com>, Ron Mayer <rm_pg@cheapcomplexdevices.com>, Gavin Sherry <swm@alcove.com.au>, pgsql-hackers@postgresql.org
Date: 2008-01-15T16:50:34Z
Lists: pgsql-hackers
Hi, Tom Lane wrote: > DBAs tend to be belt *and* suspenders guys, no? I rather know those admins with stupid looking faces who are wondering why their transactions fail. Often enough, that can have a lot of different reasons. Extending the set of possible traps doesn't seem like a clever idea for those admins. > I'd think a lot of them > would want a table constraint, plus a partitioning rule that rejects > anything outside the intended partitions. I'm rather a fan of the DRY principle (don't repeat yourself). Because having to maintain redundant constraints smells suspiciously like a maintenance nightmare. And where's the real use of making the database system check twice? Want to protect against memory corruption in between the two checks, eh? :-) Regards Markus