The regression test files plpgsql and rangefuncs both create a dup()
function, and as they are run in parallel this just caused an error for
me, as attached. This just happened once for me, but it still ought to
be corrected.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
*** ./expected/plpgsql.out Thu Jun 30 18:32:22 2005
--- ./results/plpgsql.out Fri Jul 1 19:39:51 2005
***************
*** 1855,1860 ****
--- 1855,1861 ----
(1 row)
drop function dup(anyelement);
+ ERROR: function dup(anyelement) does not exist
--
-- test PERFORM
--
======================================================================
*** ./expected/rangefuncs.out Mon May 30 17:35:15 2005
--- ./results/rangefuncs.out Fri Jul 1 19:39:48 2005
***************
*** 493,498 ****
--- 493,499 ----
--
CREATE FUNCTION dup (f1 anyelement, f2 out anyelement, f3 out anyarray)
AS 'select $1, array[$1,$1]' LANGUAGE sql;
+ ERROR: function "dup" already exists with same argument types
SELECT dup(22);
dup
----------------
***************
*** 508,514 ****
(1 row)
SELECT * FROM dup('xyz'::text);
! f2 | f3
-----+-----------
xyz | {xyz,xyz}
(1 row)
--- 509,515 ----
(1 row)
SELECT * FROM dup('xyz'::text);
! j | k
-----+-----------
xyz | {xyz,xyz}
(1 row)
***************
*** 516,521 ****
--- 517,525 ----
-- equivalent specification
CREATE OR REPLACE FUNCTION dup (inout f2 anyelement, out f3 anyarray)
AS 'select $1, array[$1,$1]' LANGUAGE sql;
+ ERROR: cannot change return type of existing function
+ DETAIL: Row type defined by OUT parameters is different.
+ HINT: Use DROP FUNCTION first.
SELECT dup(22);
dup
----------------
======================================================================
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
