pgAdmin 4 commit: More jQuery 3 updates.

[Dave Page]

More jQuery 3 updates.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=3b862bd70bc1804f28e557dc8dd1cbde71f67f34
Author: Aditya Toshniwal 

Modified Files
--
web/pgadmin/browser/static/js/wizard.js|  2 +-
web/pgadmin/misc/file_manager/static/js/utility.js |  6 +--
web/pgadmin/settings/static/js/settings.js |  2 +-
web/pgadmin/static/js/keyboard_shortcuts.js|  4 +-
.../static/js/selection/xcell_selection_model.js   |  2 +-
web/pgadmin/static/js/slickgrid/editors.js | 62 +++---
6 files changed, 39 insertions(+), 39 deletions(-)

Re: [pgAdmin4][patch] jQuery 3 migration few more leftovers

[Dave Page]

Thanks, applied.

On Tue, Jul 10, 2018 at 8:14 AM, Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Hackers,
>
> Attached is the patch to migrate few more occurrences of deprecated
> functions of older jQuery versions in pgAdmin4 to jQuery 3 (which were
> missed in previous patches of jQuery migration :( ).
>
> Kindly review.
>
> --
> Thanks and Regards,
> Aditya Toshniwal
> Software Engineer | EnterpriseDB Software Solutions | Pune
> "Don't Complain about Heat, Plant a tree"
>



-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: [pgAdmin4][RM3480] User can not see any SQL query in SQL pane

[Dave Page]

Hi

On Tue, Jul 10, 2018 at 10:36 AM, Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Hackers,
>
> Attached is the fix. It is again related to changed made for RM3294, the
> font size was set to 0em. Also included changes to make sure CodeMirror
> font size is never set to 0em but to default 1em if font size is not
> available from preferences.
>

Unfortunately this fails linting, and when that is fixed, fails the tests:

HeadlessChrome 0.0.0 (Mac OS X 10.12.6) SqlEditorUtils Calculate font size
of input number passed calcFontSize FAILED

Expected '1em' to equal '0em'.

at UserContext.
(regression/javascript/webpack:/regression/javascript/sqleditor_utils_spec.js:35:47)

HeadlessChrome 0.0.0 (Mac OS X 10.12.6): Executed 660 of 741 (1 FAILED) (0
secs / 7.075 secs)

HeadlessChrome 0.0.0 (Mac OS X 10.12.6) SqlEditorUtils Calculate font size
of input number passed calcFontSize FAILED

Expected '1em' to equal '0em'.

HeadlessChrome 0.0.0 (Mac OS X 10.12.6): Executed 741 of 741 (1 FAILED)
(7.74 secs / 7.383 secs)

error Command failed with exit code 1.

info Visit *https://yarnpkg.com/en/docs/cli/run
* for documentation about this command.

make: *** [check-js] Error 1


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: [pgAdmin4][RM3480] User can not see any SQL query in SQL pane

[Aditya Toshniwal]

Hi Hackers,

On Tue, Jul 10, 2018 at 3:37 PM, Dave Page  wrote:

> Hi
>
> On Tue, Jul 10, 2018 at 10:36 AM, Aditya Toshniwal  enterprisedb.com> wrote:
>
>> Hi Hackers,
>>
>> Attached is the fix. It is again related to changed made for RM3294, the
>> font size was set to 0em. Also included changes to make sure CodeMirror
>> font size is never set to 0em but to default 1em if font size is not
>> available from preferences.
>>
>
> Unfortunately this fails linting, and when that is fixed, fails the tests:
>
​Not good. Should have checked. Attached is the updated patch.​


>
> HeadlessChrome 0.0.0 (Mac OS X 10.12.6) SqlEditorUtils Calculate font size
> of input number passed calcFontSize FAILED
>
> Expected '1em' to equal '0em'.
>
> at UserContext. (regression/javascript/webpack:/regression/
> javascript/sqleditor_utils_spec.js:35:47)
>
> HeadlessChrome 0.0.0 (Mac OS X 10.12.6): Executed 660 of 741 (1 FAILED)
> (0 secs / 7.075 secs)
>
> HeadlessChrome 0.0.0 (Mac OS X 10.12.6) SqlEditorUtils Calculate font size
> of input number passed calcFontSize FAILED
>
> Expected '1em' to equal '0em'.
>
> HeadlessChrome 0.0.0 (Mac OS X 10.12.6): Executed 741 of 741 (1 FAILED)
> (7.74 secs / 7.383 secs)
>
> error Command failed with exit code 1.
>
> info Visit *https://yarnpkg.com/en/docs/cli/run
> * for documentation about this
> command.
>
> make: *** [check-js] Error 1
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>



-- 
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB Software Solutions | Pune
"Don't Complain about Heat, Plant a tree"

Re: [pgAdmin4][RM3480] User can not see any SQL query in SQL pane

[Dave Page]

I think you forgot the patch :-/

On Tue, Jul 10, 2018 at 11:48 AM, Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Hackers,
>
> On Tue, Jul 10, 2018 at 3:37 PM, Dave Page  wrote:
>
>> Hi
>>
>> On Tue, Jul 10, 2018 at 10:36 AM, Aditya Toshniwal <
>> aditya.toshni...@enterprisedb.com> wrote:
>>
>>> Hi Hackers,
>>>
>>> Attached is the fix. It is again related to changed made for RM3294, the
>>> font size was set to 0em. Also included changes to make sure CodeMirror
>>> font size is never set to 0em but to default 1em if font size is not
>>> available from preferences.
>>>
>>
>> Unfortunately this fails linting, and when that is fixed, fails the tests:
>>
> ​Not good. Should have checked. Attached is the updated patch.​
>
>
>>
>> HeadlessChrome 0.0.0 (Mac OS X 10.12.6) SqlEditorUtils Calculate font
>> size of input number passed calcFontSize FAILED
>>
>> Expected '1em' to equal '0em'.
>>
>> at UserContext. (regression/javascript/webpack
>> :/regression/javascript/sqleditor_utils_spec.js:35:47)
>>
>> HeadlessChrome 0.0.0 (Mac OS X 10.12.6): Executed 660 of 741 (1 FAILED)
>> (0 secs / 7.075 secs)
>>
>> HeadlessChrome 0.0.0 (Mac OS X 10.12.6) SqlEditorUtils Calculate font
>> size of input number passed calcFontSize FAILED
>>
>> Expected '1em' to equal '0em'.
>>
>> HeadlessChrome 0.0.0 (Mac OS X 10.12.6): Executed 741 of 741 (1 FAILED)
>> (7.74 secs / 7.383 secs)
>>
>> error Command failed with exit code 1.
>>
>> info Visit *https://yarnpkg.com/en/docs/cli/run
>> * for documentation about this
>> command.
>>
>> make: *** [check-js] Error 1
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>
>
> --
> Thanks and Regards,
> Aditya Toshniwal
> Software Engineer | EnterpriseDB Software Solutions | Pune
> "Don't Complain about Heat, Plant a tree"
>



-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: [pgAdmin4][RM3480] User can not see any SQL query in SQL pane

[Aditya Toshniwal]

Hi,

On Tue, Jul 10, 2018 at 4:24 PM, Dave Page  wrote:

> I think you forgot the patch :-/
>
​Apologies. I know this is annoying :(
​
PFA.

>
>
> On Tue, Jul 10, 2018 at 11:48 AM, Aditya Toshniwal  enterprisedb.com> wrote:
>
>> Hi Hackers,
>>
>> On Tue, Jul 10, 2018 at 3:37 PM, Dave Page  wrote:
>>
>>> Hi
>>>
>>> On Tue, Jul 10, 2018 at 10:36 AM, Aditya Toshniwal <
>>> aditya.toshni...@enterprisedb.com> wrote:
>>>
 Hi Hackers,

 Attached is the fix. It is again related to changed made for RM3294,
 the font size was set to 0em. Also included changes to make sure CodeMirror
 font size is never set to 0em but to default 1em if font size is not
 available from preferences.

>>>
>>> Unfortunately this fails linting, and when that is fixed, fails the
>>> tests:
>>>
>> ​Not good. Should have checked. Attached is the updated patch.​
>>
>>
>>>
>>> HeadlessChrome 0.0.0 (Mac OS X 10.12.6) SqlEditorUtils Calculate font
>>> size of input number passed calcFontSize FAILED
>>>
>>> Expected '1em' to equal '0em'.
>>>
>>> at UserContext. (regression/javascript/webpack
>>> :/regression/javascript/sqleditor_utils_spec.js:35:47)
>>>
>>> HeadlessChrome 0.0.0 (Mac OS X 10.12.6): Executed 660 of 741 (1 FAILED)
>>> (0 secs / 7.075 secs)
>>>
>>> HeadlessChrome 0.0.0 (Mac OS X 10.12.6) SqlEditorUtils Calculate font
>>> size of input number passed calcFontSize FAILED
>>>
>>> Expected '1em' to equal '0em'.
>>>
>>> HeadlessChrome 0.0.0 (Mac OS X 10.12.6): Executed 741 of 741 (1 FAILED)
>>> (7.74 secs / 7.383 secs)
>>>
>>> error Command failed with exit code 1.
>>>
>>> info Visit *https://yarnpkg.com/en/docs/cli/run
>>> * for documentation about this
>>> command.
>>>
>>> make: *** [check-js] Error 1
>>>
>>>
>>> --
>>> Dave Page
>>> Blog: http://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>> EnterpriseDB UK: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>
>>
>>
>> --
>> Thanks and Regards,
>> Aditya Toshniwal
>> Software Engineer | EnterpriseDB Software Solutions | Pune
>> "Don't Complain about Heat, Plant a tree"
>>
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>



-- 
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB Software Solutions | Pune
"Don't Complain about Heat, Plant a tree"


RM3480.patch
Description: Binary data

Re: [pgAdmin4][RM3480] User can not see any SQL query in SQL pane

[Dave Page]

Thanks - patch applied!

On Tue, Jul 10, 2018 at 11:58 AM, Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi,
>
> On Tue, Jul 10, 2018 at 4:24 PM, Dave Page  wrote:
>
>> I think you forgot the patch :-/
>>
> ​Apologies. I know this is annoying :(
> ​
> PFA.
>
>>
>>
>> On Tue, Jul 10, 2018 at 11:48 AM, Aditya Toshniwal <
>> aditya.toshni...@enterprisedb.com> wrote:
>>
>>> Hi Hackers,
>>>
>>> On Tue, Jul 10, 2018 at 3:37 PM, Dave Page  wrote:
>>>
 Hi

 On Tue, Jul 10, 2018 at 10:36 AM, Aditya Toshniwal <
 aditya.toshni...@enterprisedb.com> wrote:

> Hi Hackers,
>
> Attached is the fix. It is again related to changed made for RM3294,
> the font size was set to 0em. Also included changes to make sure 
> CodeMirror
> font size is never set to 0em but to default 1em if font size is not
> available from preferences.
>

 Unfortunately this fails linting, and when that is fixed, fails the
 tests:

>>> ​Not good. Should have checked. Attached is the updated patch.​
>>>
>>>

 HeadlessChrome 0.0.0 (Mac OS X 10.12.6) SqlEditorUtils Calculate font
 size of input number passed calcFontSize FAILED

 Expected '1em' to equal '0em'.

 at UserContext. (regression/javascript/webpack
 :/regression/javascript/sqleditor_utils_spec.js:35:47)

 HeadlessChrome 0.0.0 (Mac OS X 10.12.6): Executed 660 of 741 (1 FAILED)
 (0 secs / 7.075 secs)

 HeadlessChrome 0.0.0 (Mac OS X 10.12.6) SqlEditorUtils Calculate font
 size of input number passed calcFontSize FAILED

 Expected '1em' to equal '0em'.

 HeadlessChrome 0.0.0 (Mac OS X 10.12.6): Executed 741 of 741 (1 FAILED)
 (7.74 secs / 7.383 secs)

 error Command failed with exit code 1.

 info Visit *https://yarnpkg.com/en/docs/cli/run
 * for documentation about this
 command.

 make: *** [check-js] Error 1


 --
 Dave Page
 Blog: http://pgsnake.blogspot.com
 Twitter: @pgsnake

 EnterpriseDB UK: http://www.enterprisedb.com
 The Enterprise PostgreSQL Company

>>>
>>>
>>>
>>> --
>>> Thanks and Regards,
>>> Aditya Toshniwal
>>> Software Engineer | EnterpriseDB Software Solutions | Pune
>>> "Don't Complain about Heat, Plant a tree"
>>>
>>
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>
>
> --
> Thanks and Regards,
> Aditya Toshniwal
> Software Engineer | EnterpriseDB Software Solutions | Pune
> "Don't Complain about Heat, Plant a tree"
>



-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: Regarding RM #3316 Pgadmin4 No Tray Crash

[Dave Page]

Hi

On Tue, Jul 10, 2018 at 11:20 AM, Akshay Joshi <
akshay.jo...@enterprisedb.com> wrote:

> Hi Hackers,
>
> I have implemented the fix for RM #3316 "Pgadmin4 No Tray Crash". I have
> implemented it as follows:
>
>- Check the availability of System Tray for 30 seconds (no changes
>made here).
>- If System Tray not found create one Floating Window with menu.
>(Refer attached screenshot).
>- I have remove close(x) button of the floating window.
>- Fedora have "Quit" menu for the applications, so I have handle the
>close event and shutdown the python server.
>
> I have tested this on Fedora-28 (no system tray) and Ubuntu 18.04 (with
> system tray).
>
> Please review the screenshot and suggest changes (if any). I'll send the
> patch later.
>

What does the window look like without the menu? I'd suggest putting a
Slonik image there, and maybe a note (or a button to display a note) saying
that installing a system tray plugin can be used to hide the window.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

[pgAdmin4][RM3480] User can not see any SQL query in SQL pane

[Aditya Toshniwal]

Hi Hackers,

Attached is the fix. It is again related to changed made for RM3294, the
font size was set to 0em. Also included changes to make sure CodeMirror
font size is never set to 0em but to default 1em if font size is not
available from preferences.

-- 
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB Software Solutions | Pune
"Don't Complain about Heat, Plant a tree"


RM3480.patch
Description: Binary data

Re: Regarding RM #3316 Pgadmin4 No Tray Crash

[Dave Page]

On Tue, Jul 10, 2018 at 4:05 PM, Akshay Joshi  wrote:

>
>
> On Tue, 10 Jul 2018, 18:32 Dave Page,  wrote:
>
>> Hi
>>
>> On Tue, Jul 10, 2018 at 11:20 AM, Akshay Joshi <
>> akshay.jo...@enterprisedb.com> wrote:
>>
>>> Hi Hackers,
>>>
>>> I have implemented the fix for RM #3316 "Pgadmin4 No Tray Crash". I have
>>> implemented it as follows:
>>>
>>>- Check the availability of System Tray for 30 seconds (no changes
>>>made here).
>>>- If System Tray not found create one Floating Window with menu.
>>>(Refer attached screenshot).
>>>- I have remove close(x) button of the floating window.
>>>- Fedora have "Quit" menu for the applications, so I have handle the
>>>close event and shutdown the python server.
>>>
>>> I have tested this on Fedora-28 (no system tray) and Ubuntu 18.04 (with
>>> system tray).
>>>
>>> Please review the screenshot and suggest changes (if any). I'll send the
>>> patch later.
>>>
>>
>> What does the window look like without the menu? I'd suggest putting a
>> Slonik image there, and maybe a note (or a button to display a note) saying
>> that installing a system tray plugin can be used to hide the window.
>>
>
>  You mean instead of "pgAdmin4" menu we should add toolbar with button
> having slonik image and when click on there submenus will be open.
>

No - I assume that's a drop down menu over a blank window? I'm suggesting
something to fill the blank space.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgAgent commit: Using mutex around the logging functionality to avoid l

[Ashesh Vashi]

Using mutex around the logging functionality to avoid logging at the
same time from different threads in the same file, and make a mess of
the log file.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgagent.git;a=commitdiff;h=5706a7738f566686ab8a5046572e4c67dccfcc4a

Modified Files
--
connection.cpp | 35 ---
include/misc.h | 35 +++
unix.cpp   | 11 +++
3 files changed, 46 insertions(+), 35 deletions(-)

pgAgent commit: Using the FindBoost.cmake from cmake 3.11.4 to work wit

[Ashesh Vashi]

Using the FindBoost.cmake from cmake 3.11.4 to work with the boost
version 1.67.0, or lesser.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgagent.git;a=commitdiff;h=54130ee9bf394ca6ef6ff89d6cf3265543468be7
Author: Sandeep Thankkar 

Modified Files
--
cmake/FindBoost.cmake | 1252 +
1 file changed, 1068 insertions(+), 184 deletions(-)

[pgAdmin4][Patch]: Fix RM #3191 : Debug option is not working

[Khushboo Vashi]

Hi,

Please find the attached patch to fix #3191 : Debug option is not working.

Issues fixed:

1. EPAS packages' function/procedure does not honour INOUT arguments, it
converts INOUT to OUT.

2.  Packages' functions and procedures are not getting listed in their
respected nodes in some scenarios like procedure having INOUT argument and
function with void return type

3. The Reverse engineering SQL is not correct for Packages'
functions/procedures

4. In case of INOUT argument, debugger asks for mendatory input which
should not.


Thanks,
Khushboo
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/packages/edbfuncs/__init__.py b/web/pgadmin/browser/server_groups/servers/databases/schemas/packages/edbfuncs/__init__.py
index b1b7521..8f0e712 100644
--- a/web/pgadmin/browser/server_groups/servers/databases/schemas/packages/edbfuncs/__init__.py
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/packages/edbfuncs/__init__.py
@@ -391,32 +391,13 @@ class EdbFuncView(PGChildNodeView, DataTypeReader):
 proargmodenames = {'i': 'IN', 'o': 'OUT', 'b': 'INOUT',
'v': 'VARIADIC', 't': 'TABLE'}
 
-# The proargtypes doesn't give OUT params, so we need to fetch
-# those from database explicitly, below code is written for this
-# purpose.
-#
-# proallargtypes gives all the Function's argument including OUT,
-# but we have not used that column; as the data type of this
-# column (i.e. oid[]) is not supported by oidvectortypes(oidvector)
-# function which we have used to fetch the datatypes
-# of the other parameters.
+# EPAS explicitly converts OUT to INOUT, So we always have proargtypes
 
 proargmodes_fltrd = copy.deepcopy(proargmodes)
 proargnames_fltrd = []
 cnt = 0
 for m in proargmodes:
-if m == 'o':  # Out Mode
-SQL = render_template("/".join([self.sql_template_path,
-'get_out_types.sql']),
-  out_arg_oid=proallargtypes[cnt])
-status, out_arg_type = self.conn.execute_scalar(SQL)
-if not status:
-return internal_server_error(errormsg=out_arg_type)
-
-# Insert out parameter datatype
-proargtypes.insert(cnt, out_arg_type)
-proargdefaultvals.insert(cnt, '')
-elif m == 'v':  # Variadic Mode
+if m in ['v', 'o']:  # Out / Variadic Mode
 proargdefaultvals.insert(cnt, '')
 elif m == 't':  # Table Mode
 proargmodes_fltrd.remove(m)
@@ -532,8 +513,7 @@ class EdbFuncView(PGChildNodeView, DataTypeReader):
 """
 SQL = render_template(
 "/".join([self.sql_template_path, 'get_body.sql']),
-scid=scid,
-pkgid=pkgid)
+edbfnid=edbfnid)
 
 status, res = self.conn.execute_dict(SQL)
 if not status:
@@ -543,7 +523,7 @@ class EdbFuncView(PGChildNodeView, DataTypeReader):
 gettext("Could not find the function in the database.")
 )
 
-body = self.get_inner(res['rows'][0]['pkgbodysrc'])
+body = res['rows'][0]['funcdef']
 
 if body is None:
 body = ''
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/packages/edbfuncs/templates/edbfunc/ppas/11_plus/get_oid.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/packages/edbfuncs/templates/edbfunc/ppas/11_plus/get_oid.sql
new file mode 100644
index 000..8908a27
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/packages/edbfuncs/templates/edbfunc/ppas/11_plus/get_oid.sql
@@ -0,0 +1,17 @@
+SELECT
+pr.oid, pr.proname || '(' || COALESCE(pg_catalog
+.pg_get_function_identity_arguments(pr.oid), '') || ')' as name,
+lanname, pg_get_userbyid(proowner) as funcowner
+FROM
+pg_proc pr
+JOIN
+pg_type typ ON typ.oid=prorettype
+JOIN
+pg_language lng ON lng.oid=prolang
+JOIN
+pg_namespace nsp ON nsp.oid=pr.pronamespace
+AND nsp.nspname={{ nspname|qtLiteral }}
+WHERE
+pr.prokind IN ('f', 'w')
+AND typname NOT IN ('trigger', 'event_trigger')
+AND pr.proname = {{ name|qtLiteral }};
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/packages/edbfuncs/templates/edbfunc/ppas/11_plus/properties.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/packages/edbfuncs/templates/edbfunc/ppas/11_plus/properties.sql
new file mode 100644
index 000..a0cc7d7
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/packages/edbfuncs/templates/edbfunc/ppas/11_plus/properties.sql
@@ -0,0 +1,27 @@
+SELECT  pg_proc.oid,
+proname AS name,
+pronargs,
+proallargtypes,
+proargnames AS argnames,
+pronargdefaults,
+