Mladen Gogala wrote:
> On Mon, 23 Jan 2006 22:28:53 +0000, Andy Hassall wrote:
>
>
>>Yes, but the _index_ doesn't have to be unique, which opens up possibilities
>>such as deferrable constraints.
>
>
> Those are extremely useful when you design application badly, so that
> the children record are inserted before the parent record. I love
> applications designed around so called "object-relational mappers".
> Those applications are great examples of what not to do when designing
> an application on top of some RDBMS. Unfortunately, shooting application
> designers is illegal in most of the states of the Union.
>
They are also extremely useful in replication - well designed or not.
No, make that required, not just useful.
deferrable, initially deferred, please.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Tue Jan 24 2006 - 12:48:21 CST
