Re: [HACKERS] [INTERFACES] By Passed Domain Constraints

2005-07-07 Thread Robert Perry
Tom Thank you very much. This sounds like my problem exactly. I personally, feel that the change you have described is the right way to go for PostgreSQL. But, since the thing that I expected to work does not and would with your suggested change I guess that my opinion is pretty

Re: [HACKERS] [INTERFACES] By Passed Domain Constraints

2005-07-06 Thread Tom Lane
Robert Perry [EMAIL PROTECTED] writes: I have also been bitten by the problem you are describing. But, that one is a problem even when called from psql if I am not mistaken. Does psql not use pqlib? Perhaps it is something about PQexecParams that is the problem. I will test in a

Re: [HACKERS] [INTERFACES] By Passed Domain Constraints

2005-07-06 Thread Christopher Kings-Lynne
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