-
-
Notifications
You must be signed in to change notification settings - Fork 539
Closed
Labels
bugDefective behaviour in HeidiSQLDefective behaviour in HeidiSQLconfirmedIssue verified by project memberIssue verified by project membernettype-postgresqlPostgreSQL specific issuePostgreSQL specific issue
Milestone
Description
Preconditions
- HeidiSQL version: Version 11.1.0.6211 (64 Bit)
- Database type and version: PostgreSQL 11.9 (Debian 11.9-0+deb10u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
- OS: win10
Describe the bug
Creating a function via a CREATE FUNCTION command doesn't work.
To Reproduce
- Open a new Query Tab
- Paste the below code:
CREATE FUNCTION x() RETURNS INT LANGUAGE plpgsql AS $$
BEGIN
RETURN 1;
END;
$$;
- Ctrl-A (Edit -> Select All)
- F9 (Query -> Run)
Screenshots or Crash reports
I get this error message:
ERROR: unterminated dollar-quoted string at or near "$$
BEGIN
RETURN 1"
LINE 1: CREATE FUNCTION x() RETURNS INT LANGUAGE
plpgsql AS $$
^
Executing the same command from psql works well so the syntax is correct. Heidi also should be able to execute it, I think.
Metadata
Metadata
Assignees
Labels
bugDefective behaviour in HeidiSQLDefective behaviour in HeidiSQLconfirmedIssue verified by project memberIssue verified by project membernettype-postgresqlPostgreSQL specific issuePostgreSQL specific issue