Re: [HACKERS] By Passed Domain Constraints - Mailing list pgsql-interfaces

From Christopher Kings-Lynne
Subject Re: [HACKERS] By Passed Domain Constraints
Date
Msg-id 42CC840E.3030708@familyhealth.com.au
Whole thread Raw
In response to Re: By Passed Domain Constraints  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
> You could work around this by explicitly specifying the parameter
> type as text or varchar or whatever the domain's base type is.
> I wonder though if we oughtn't change the backend so that the inferred
> type of a parameter symbol is never a domain, but the domain's base
> type.  That would force the proper application of CoerceToDomain inside
> the constructed query parsetree.

Remember we have similar weirdness when returning domain types from 
stored procs :(

Chris



pgsql-interfaces by date:

Previous
From: Robert Perry
Date:
Subject: Re: By Passed Domain Constraints
Next
From: jtv@xs4all.nl
Date:
Subject: Re: libpq and connection failures