Re: Domains as Subtypes

On Mar 25, 2006, at 4:14 PM, Tom Lane wrote:

> "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.

Performance hit on just domain handling or overall? Personally, I'd
rather see a hit on domain handling that we can work on later rather
than the current state of things which seems to smack of MySQL (Get
the feature 'checked off the list' first, then worry about doing it
the right way).
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461