Re: Bug#347548: DOMAIN CHECK constraint bypassed

Peter Eisentraut <peter_e@gmx.net> writes:
> This bug was reported to Debian.  Comments?

These are all known issues.  The implementation of domains really needs
rather a lot of work :-(.

One thing we might think about is having domain types use a special set
of input functions rather than just linking directly to the base-type
functions (kinda like arrays use array_in, etc).  These functions could
then be charged with applying the appropriate constraint checks after
invoking the correct base-type input function.  I'm not sure about
performance issues (ie, how to avoid repetitive lookups and memory
leaks) but at least we'd only need to solve it in one place and not
several.

            regards, tom lane