Re: BUG #1267: Suggest TEXTOID parameters be treated like UNKNOWNOID - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1267: Suggest TEXTOID parameters be treated like UNKNOWNOID
Date
Msg-id 25988.1095950721@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1267: Suggest TEXTOID parameters be treated like UNKNOWNOID  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> -       if (inputTypeId == UNKNOWNOID && IsA(node, Const))
> +       if ( ( ( ( inputTypeId == UNKNOWNOID) || (inputTypeId == TEXTOID ) )
> && IsA(node, Const))&& IsA(node, Const) )

No thank you.  Fix your broken client code, rather than screwing up type
coercion behavior for everyone else.  If you've explicitly specified
that something is TEXT, then the system should treat it as TEXT.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: BUG #1266: Improper unique constraint / MVCC activities
Next
From: Tom Lane
Date:
Subject: Re: Permissions problem with sequences