ensure all PG numeric and integer type codes are present in the list

Issue #1955 resolved
Mike Bayer repo owner created an issue

i.e. type 23 and such. here's pg8000's mapping:

pg_types = {
    16: {"bin_in": boolrecv},
    17: {"bin_in": bytearecv},
    19: {"bin_in": varcharin}, # name type
    20: {"bin_in": int8recv},
    21: {"bin_in": int2recv},
    23: {"bin_in": int4recv},
    25: {"bin_in": varcharin}, # TEXT type
    26: {"txt_in": numeric_in}, # oid type
    700: {"bin_in": float4recv},
    701: {"bin_in": float8recv},
    829: {"txt_in": varcharin}, # MACADDR type
    1000: {"bin_in": array_recv}, # BOOL[   1003: {"bin_in": array_recv}, # NAME[](]
)
    1005: {"bin_in": array_recv}, # INT2[   1007: {"bin_in": array_recv}, # INT4[](]
)
    1009: {"bin_in": array_recv}, # TEXT[   1014: {"bin_in": array_recv}, # CHAR[](]
)
    1015: {"bin_in": array_recv}, # VARCHAR[   1016: {"bin_in": array_recv}, # INT8[](]
)
    1021: {"bin_in": array_recv}, # FLOAT4[   1022: {"bin_in": array_recv}, # FLOAT8[](]
)
    1042: {"bin_in": varcharin}, # CHAR type
    1043: {"bin_in": varcharin}, # VARCHAR type
    1082: {"txt_in": date_in},
    1083: {"txt_in": time_in},
    1114: {"bin_in": timestamp_recv},
    1184: {"bin_in": timestamptz_recv}, # timestamp w/ tz
    1186: {"bin_in": interval_recv},
    1231: {"bin_in": array_recv}, # NUMERIC[   1263: {"bin_in": array_recv}, # cstring[](]
)
    1700: {"bin_in": numeric_recv},
    2275: {"bin_in": varcharin}, # cstring
}

Comments (2)

  1. Log in to comment