Lori Corbani <Lori.Corbani@xxxxxxx> writes: > My example: > DROP FUNCTION ACC_setMax(); > CREATE OR REPLACE FUNCTION ACC_setMax ( > increment int, > prefixPart varchar(30) = 'MGI:' > ) > RETURNS VOID AS > \$\$ This is not the right thing: you need to include the parameters in the drop command. ACC_setMax() is a totally different function from ACC_setMax(int, varchar). regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general