Re: Bug#347548: DOMAIN CHECK constraint bypassed - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug#347548: DOMAIN CHECK constraint bypassed
Date
Msg-id 19098.1138476644@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug#347548: DOMAIN CHECK constraint bypassed  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Bug#347548: DOMAIN CHECK constraint bypassed
Next
From: "Nicholas"
Date:
Subject: BUG #2218: Variables selected in VIEWs under different names break queries using those views