-
-
Notifications
You must be signed in to change notification settings - Fork 563
Trying to render a very long pgsql array column results in an error #272
Copy link
Copy link
Open
Labels
bugDefective behaviour in HeidiSQLDefective behaviour in HeidiSQLnettype-postgresqlPostgreSQL specific issuePostgreSQL specific issue
Milestone
Description
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.
- Create a pgsql database, with a table that has an
array of varcharscolumn - 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
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugDefective behaviour in HeidiSQLDefective behaviour in HeidiSQLnettype-postgresqlPostgreSQL specific issuePostgreSQL specific issue