From e35b8cf537372ae24607e4409777e105ff6951ef Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 30 Jul 2008 18:17:19 +0000 Subject: [PATCH] adjustment to previous fix (create or replace ... so it it cut-n-paste friendly) git-svn-id: svn://svn.open-ils.org/ILS/trunk@10194 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/010.schema.biblio.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/010.schema.biblio.sql b/Open-ILS/src/sql/Pg/010.schema.biblio.sql index b87e091c93..15bdf29c6e 100644 --- a/Open-ILS/src/sql/Pg/010.schema.biblio.sql +++ b/Open-ILS/src/sql/Pg/010.schema.biblio.sql @@ -21,7 +21,7 @@ BEGIN; CREATE SCHEMA biblio; CREATE SEQUENCE biblio.autogen_tcn_value_seq; -CREATE FUNCTION biblio.next_autogen_tcn_value () RETURNS TEXT AS $$ +CREATE FUNCTION OR REPLACE biblio.next_autogen_tcn_value () RETURNS TEXT AS $$ BEGIN RETURN 'AUTOGENERATED-' || nextval('biblio.autogen_tcn_value_seq'::TEXT); END; $$ LANGUAGE PLPGSQL; -- 2.43.2