pgsql: Coerce 'unknown' type parameters to the right type in the - Mailing list pgsql-committers

From heikki@postgresql.org (Heikki Linnakangas)
Subject pgsql: Coerce 'unknown' type parameters to the right type in the
Date
Msg-id 20100818122015.EE2B27541D7@cvs.postgresql.org
Whole thread Raw
Responses Re: pgsql: Coerce 'unknown' type parameters to the right type in the  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
Log Message:
-----------
Coerce 'unknown' type parameters to the right type in the fixed-params
parse_analyze() function. That case occurs e.g with PL/pgSQL
EXECUTE ... USING 'stringconstant'.

The coercion with a CoerceViaIO node. The result is similar to the coercion
via input function performed for unknown constants in coerce_type(),
except that this happens at runtime.

Backpatch to 9.0. The issue is present in 8.4 as well, but the coerce param
hook infrastructure this patch relies on was introduced in 9.0. Given the
lack of user reports and harmlessness of the bug, it's not worth attempting
a different fix just for 8.4.

Modified Files:
--------------
    pgsql/src/backend/parser:
        parse_param.c (r2.4 -> r2.5)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/parse_param.c?r1=2.4&r2=2.5)

pgsql-committers by date:

Previous
From: fxjr@pgfoundry.org (User Fxjr)
Date:
Subject: npgsql - Npgsql2: Added fix to return CLR type when working with
Next
From: heikki@postgresql.org (Heikki Linnakangas)
Date:
Subject: pgsql: Coerce 'unknown' type parameters to the right type in the