Skip to content

Trying to render a very long pgsql array column results in an error #272

@TikiTDO

Description

@TikiTDO

Steps to reproduce this issue

I haven't been able to how to create a table that causes the error, but I do know why it happens, the line that causes it, and that it occurs in a clone of our production DB.

  1. Create a pgsql database, with a table that has an array of varchars column
  2. Insert a value that causes this code to run while rendering the data (Haven't figured out exactly when this runs)

Current behavior

Error dialog with: ERROR: function substr(character varying[], integer, integer) does not exist

Expected behavior

Values should display in the data tab

Possible solution

The SUBSTR code should not be called when rendering an array column

Environment

  • HeidiSQL version: 9.5.0.4196
  • Database system and version: PostgreSQL 10.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.0, 64-bit

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLnettype-postgresqlPostgreSQL specific issue

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions