Heloy I'm using HeidiSQL for over a one year. Some things are great, but some are not. So, my questions are:
Is it possible to edit postgres procedure or function somehow? When I try to edit and save postgres procedure i got an error:
ERROR: relation "information_schema.ROUTINES" does not exist LINE 1: SELECT ROUTINE_NAME FROM "information_schema"."ROUTINES" WHE...
Query that produce error is: SELECT ROUTINE_NAME FROM "information_schema"."ROUTINES" WHERE ROUTINE_SCHEMA = E'public' AND ROUTINE_TYPE = E'FUNCTION';
I think correct query should without quotes
SELECT ROUTINE_NAME FROM "information_schema".ROUTINES WHERE ROUTINE_SCHEMA = E'public' AND ROUTINE_TYPE = E'FUNCTION';
Also, is there any plan to support sequences, make tree on left side to separata tables, functions, triggers, sequences, ...
Regards, Dinko