Re: BUG #1267: Suggest TEXTOID parameters be treated like UNKNOWNOID

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Colin Chapman" <c0linchapman(at)btinternet(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1267: Suggest TEXTOID parameters be treated like UNKNOWNOID
Date: 2004-09-23 14:45:21
Message-ID: 25988.1095950721@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-09-23 23:29:47 Re: Permissions problem with sequences
Previous Message Stephan Szabo 2004-09-23 14:15:45 Re: BUG #1266: Improper unique constraint / MVCC activities