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-ad...@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!
