Postgres - Procedure or Function Editing

dinmil's profile image dinmil posted 8 years ago in General Permalink

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

[expired user #12208]'s profile image [expired user #12208] posted 5 years ago Permalink

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

[expired user #12208]'s profile image [expired user #12208] posted 5 years ago Permalink

me too. i have same problem please help

1 attachment(s):
  • Untitled
Koszyk's profile image Koszyk posted 5 years ago Permalink

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

abruck's profile image abruck posted 3 years ago Permalink

Has this bug been resolved yet; I'm getting it today

I'd hate to have to go back to pgAdmin ...

abruck's profile image abruck posted 3 years ago Permalink

Did not get the error in pgAdmin

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