Re: generic modelling of data models; enforcing constraints dynamically...

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: rob(at)marjot-multisoft(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: generic modelling of data models; enforcing constraints dynamically...
Date: 2009-09-24 16:52:35
Message-ID: 4ABBA3D3.8040305@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

InterRob wrote:
> Dear List,
>
> I am trying to implement the following:
>
> [snip]
>
> All suggestions are very much appreciated,
> regards,
>
>
> Rob
>
>

It's not clear to me what you're asking, but I suspect the suggestion
you need is the same as if you had asked how to best implement an
Entity-Attribute-Value scheme: don't do it. Why it may be possible,
performance is going to go into the toilet, constraints are going to be
difficult to enforce, and maintenance will be difficult at best.
Spending the effort upfront to define a schema will have drastic
long-term payoffs. It can be tempting to believe an application can
define the appropriate schema for itself at runtime if you just give it
a big enough sandbox, but this rarely works out well.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-09-24 16:52:36 Re: generic modelling of data models; enforcing constraints dynamically...
Previous Message Grzegorz Jaśkiewicz 2009-09-24 16:45:15 Re: Exception 0xC0000005