Re: pgAdmin questions

On 02/03/2018 12:24 PM, bob gailer wrote:
> I am using pgAdmin to create functions (and other wonderful purposes).

>
> Once I have created a function I notice I can't change the arguments or
> return type. Why is this? The help topic does not address this.

Because pgAdmin is just a client over Postgres and creating functions is
a Postgres responsibility:

https://www.postgresql.org/docs/10/static/sql-createfunction.html

To replace the current definition of an existing function, use CREATE OR
REPLACE FUNCTION. It is not possible to change the name or argument
types of a function this way (if you tried, you would actually be
creating a new, distinct function). Also, CREATE OR REPLACE FUNCTION
will not let you change the return type of an existing function. To do
that, you must drop and recreate the function. (When using OUT
parameters, that means you cannot change the types of any OUT parameters
except by dropping the function.)"

For the below you might get better answers quicker on the pgAdmin list:

https://www.pgadmin.org/support/list/

>
> I also notice that the properties window always opens to a preset size
> rather than remembering what I changed it to. Could it be made to
> remember? There is not a lot of room to write code and I find I am
> constantly resizing the window.
>
> Is there a way  to get directly to a particular node, e.g. public
> schemas, in the browser tree view. It gets old having to click my way
> down the tree. A shortcut would be nice.
>
> Why does the server get disconnected? Is there a timeout? Can that be
> changed?
>
> When using help the Table of Contents (TOC) scrolls vertically when I
> scroll the help topic. It would be nice it it stayed in place instead.
> It would also be nice if the current topic were highlighted in the TOC.
>
> Bob Gailer
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com