pg_tle icon indicating copy to clipboard operation
pg_tle copied to clipboard

Errored when inserting array value of custom datatype in binary mode .

Open thiru-baffle opened this issue 3 months ago • 3 comments

Description

We created the custom type. And created the custom_type[] column. While inserting the array values in those columns in binary mode, the server errored with 'no binary input function available for type custom_type'.

If the array values are in the text mode, it works as expected.

Steps to reproduce

  1. Create customType.
  2. Create customtype[] column in a table.
  3. insert into table values ('\0xcustomdatatypeValues,...); -> make sure this data is transferred via binary mode.

Expected outcome

The values to be inserted.

Actual outcome

Error from the server with ErrMessage: 'no binary input function available for type custom_type'.

Analysis

None.

If applicable, please provide logs that demonstrate the issue. Please remove any sensitive information from the logs.

thiru-baffle avatar Mar 27 '24 11:03 thiru-baffle