Re: Domains as Subtypes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Domains as Subtypes
Date
Msg-id 18189.1143299641@sss.pgh.pa.us
Whole thread Raw
In response to Re: Domains as Subtypes  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Domains as Subtypes  (Jim Nasby <jnasby@pervasive.com>)
List pgsql-hackers
"Jim C. Nasby" <jnasby@pervasive.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Role incompatibilities
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Where does the time go?