Postgres - Procedure or Function Editing

dinmil posted 3 years ago in General

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

vandalizm posted 1 month ago

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

vandalizm posted 1 month ago

me too. i have same problem please help

1 attachment(s):
  • Untitled
Koszyk posted 2 days ago

I use quotation marks only when fields are considered as key words. I wouldn't say it is a problem.

Please login to leave a reply, or register at first.