Re: generic modelling of data models; enforcing constraints dynamically... - Mailing list pgsql-general

From Ben Chobot
Subject Re: generic modelling of data models; enforcing constraints dynamically...
Date
Msg-id 4ABBA3D3.8040305@silentmedia.com
Whole thread Raw
In response to generic modelling of data models; enforcing constraints dynamically...  (InterRob <rob.marjot@gmail.com>)
Responses Re: generic modelling of data models; enforcing constraints dynamically...  (Rob Marjot <rob@marjot-multisoft.com>)
List 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.

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Exception 0xC0000005
Next
From: Sam Mason
Date:
Subject: Re: generic modelling of data models; enforcing constraints dynamically...