create function : change name of input parameter

From: Lori Corbani <Lori(dot)Corbani(at)jax(dot)org>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: create function : change name of input parameter
Date: 2014-08-20 13:25:12
Message-ID: 4542636FF9185340AC1FDDE71BF1992B62BFE1B9@jaxbhexms02.jax.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Using Postgres Version 9.0.4:

We are migrating our Sybase stored procedures to Postgres and need to be able to drop/replace the SPs, making needed changes to input parameters to fix issues/differences between Sybase and Postgres.

However, we keep getting this error when we drop/replace the PG/SP:

'ERROR : cannot change name of input parameter'

The 'create function' documentation states:

'You cannot change the name already assigned to any input parameter (although you can add names to parameters that had none before).'

Other than a complete restore of the database from a dump that does *not* contain the original SP...is there any other way to override this constraint?

This makes debugging *extremely* difficult. If you don't have your input parameters completely correct the first time...you're hosed.

Many thanks.
Lori

The information in this email, including attachments, may be confidential and is intended solely for the addressee(s). If you believe you received this email by mistake, please notify the sender by return email as soon as possible.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-08-20 13:40:03 Re: create function : change name of input parameter
Previous Message Rémi Cura 2014-08-20 08:29:32 Re: pg_advisory_lock problem