It worked when I included the parameter list in the DROP statement.
Thank you!
Lori
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, August 20, 2014 11:54 AM
To: Lori Corbani; pgsql-general@postgresql.org
Subject: Re: [GENERAL] create function
This worked! Many, many, thanks!
-Original Message-
From: Rob Sargent [mailto:robjsarg...@gmail.com]
Sent: Wednesday, August 20, 2014 10:15 AM
To: Adrian Klaver
Cc: Lori Corbani; Alban Hertroys; pgsql-general@postgresql.org
Subject: Re: [GENERAL] create function : change name of input
Will try a different approach to my wrapper.
Many thanks!
Lori
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, August 20, 2014 10:11 AM
To: Lori Corbani; pgsql-general@postgresql.org
Subject: Re: [GENERAL] create function : change name of input
= prefixPart
changed to
v_ prefixPart varchar(30) = 'MGI:'
where prefixPart = v_prefixPart
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, August 20, 2014 9:40 AM
To: Lori Corbani; pgsql-general@postgresql.org
Subject: Re: [GENERAL] cr
I *am* definitely dropping the function first. I still get the same error.
-Original Message-
From: Alban Hertroys [mailto:haram...@gmail.com]
Sent: Wednesday, August 20, 2014 9:44 AM
To: Lori Corbani
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] create function : change name
Yes, I am doing a DROP and then a CREATE OR REPLACE
Let me read over your example...
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, August 20, 2014 9:40 AM
To: Lori Corbani; pgsql-general@postgresql.org
Subject: Re: [GENERAL] create function
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/
procedures) over
to Postgres and I am finding the online Postgres documentation and the
Douglas book a bit lacking in some of the more specific examples that I
am interested in finding.
Thanks.
Lori
Richard Huxton wrote:
On 07/11/11 19:18, Lori Corbani wrote:
I have a function, call it 'f
er
to Postgres and I am finding the online Postgres documentation and the
Douglas book a bit lacking in some of the more specific examples that I
am interested in finding.
Thanks.
Lori
________
From: Lori Corbani [l...@informatics.jax.org]
Sent: Tuesday, November
I have a function, call it 'functionMain'. And I have several tables that each
have trigger functions. Each trigger function needs to call 'functionMain'
(with different parameters).
table A => trigger function A ==> functionMain
table B => trigger function B ==> functionMain
table C => trigg
10 matches
Mail list logo
