Thread: pgAdmin questions
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. 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
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!