Re: Domains as Subtypes

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:
> On Fri, Mar 24, 2006 at 10:49:00PM -0500, Tom Lane wrote:
>> I think we've got that one actually.  It's domains as PL-function output
>> types that aren't checked.  Also plpgsql fails to enforce domain checks
>> on its local variables.

> So is this the complete list?

No, I don't think so.  IIRC we're also missing domain checks on
parameter values in Bind messages, and there might be some other
holes too.  See the archives.

I made a suggestion about closing all these holes at once by
integrating domain checking into the I/O functions for domains,
but it's not clear how to do that without a big performance hit.

			regards, tom lane