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.klaver@aklaver.com

On 2/3/2018 3:30 PM, Adrian Klaver wrote:

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.)"

Thanks. That helps. I was misled by seeing -- DROP FUNCTION
public.test(character varying); at the top of the SQL; now I see it is a
comment.

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

Thanks.
Do you refer to pgsql-admin@lists.postgresql.org?

On 02/03/2018 01:00 PM, bob gailer wrote:

On 2/3/2018 3:30 PM, Adrian Klaver wrote:

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.)"

Thanks. That helps. I was misled by seeing -- DROP FUNCTION
public.test(character varying); at the top of the SQL; now I see it is a
comment.

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

Thanks.
Do you refer to pgsql-admin@lists.postgresql.org?

No pgadmin-support:

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

--
Adrian Klaver
adrian.klaver@aklaver.com

On 2/3/2018 4:12 PM, Adrian Klaver wrote:

On 02/03/2018 01:00 PM, bob gailer wrote:

On 2/3/2018 3:30 PM, Adrian Klaver wrote:

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.)"

Thanks. That helps. I was misled by seeing -- DROP FUNCTION
public.test(character varying); at the top of the SQL; now I see it
is a comment.

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

Thanks.
Do you refer to pgsql-admin@lists.postgresql.org?

No pgadmin-support:

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

I failed to see that in the list. I did not realize I had to scroll down
to Projects!

When creating a function(e.g.)I 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

On Sun, Feb 4, 2018 at 2:54 AM, bob gailer <bgailer@gmail.com> wrote:

When creating a function(e.g.)I 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.

Please log a feature request at https://redmine.postgresql.

org/projects/pgadmin4

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.

Right now NO. But you can always hide the nodes as per your requirement

through File > Preferences > Nodes

Why does the server get disconnected? Is there a timeout? Can that be
changed?

Please give some more details (pgAdmin 4 version, OS version, Frequency of

the disconnection etc.) about this as ideally it should not.