[SA 7.1.228 Pro] [postgresql] Edit function doesn't work

[SA 7.1.228 Pro] [postgresql] Edit function doesn't work

Edit function and show DDL for function don't.
It ends up with pg_dump error (no matching table were found).

Again, I suggest to use native postgresql solutions:
- table pg_proc - contain all info about function, including source code
- use pg_get_function_ family, see http://www.postgresql.org/docs/9.0/static/functions-info.html

Note, for pg_get_function functions you have to pass OID of function, you can get from pg_proc
Be aware, those function are no available in postgresql version lower than 8.4

And don't forget, that postgresql allows existing more than one function with the same name, while they differ by input arguments (number and/or type).

with regards

The internal architecture of SA is different, it's more or less abstract from database type. Database specific interfaces and settings are controlled by customized settings and scripts in SA options. That's why it cannot have PostgreSQL specific native code while for all other database systems use their readily available APIs.

First of all, from user point of view I have to rely on software. Doesn't matter what internal architecture is chosen.
Right now I'm trying to help you in development. I giving you some clues, I collected during my long-term experience in programming as well as databases it self.

To me using external utilities which make own connections are very sub-optimal. I understand choosing them for proof of concept. But in production you will face a lot of pitfalls. Once of them is speed of such solution. In case of using pg_dump, lag is significant and annoying. Also additional info retrieved is unneeded. Not to mention about problems with configuration.
Also, it is not as flexible as it seems to be (functions DDL not working).

Really don't have idea why you cannot just rely on SQL statements (like SA does). But at the end decision is not on my side. I just want to get it working ;)

Your input is certainly appreciate and we pay attention to it.