Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Find Text on Server fails when Postgres table contains Integer column #235

Closed
cookieguru opened this issue Apr 18, 2018 · 1 comment

Comments

Projects
None yet
2 participants
@cookieguru
Copy link

commented Apr 18, 2018

Steps to reproduce this issue

  1. Connect to a Postgres server
  2. Launch "Find text on server"
  3. Select a table that contains integer column(s)
  4. Then I get... ERROR: function lower(integer) does not exist

Current behavior

ERROR: function lower(integer) does not exist

Expected behavior

Feature works as it does for MySQL

Environment

Example table structure:

CREATE TABLE myschema.sources
(
  source_id integer,
  source_description character varying(255) COLLATE pg_catalog."default"
)
TABLESPACE pg_default;
  • HeidiSQL version:
    9.5.0.5256 (64 Bit)
  • Database system and version:
    PostgreSQL 10.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit

@ansgarbecker ansgarbecker added this to the v10.2 milestone Feb 20, 2019

@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

commented May 3, 2019

Fix was to apply LOWER() after CAST(... AS TEXT). Should work with the latest build now.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.