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@xxxxxxxxxxxxxxxxxxxx?
