From 1470f9b1373b9917f28e8d1dd77a32b1c08787f9 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 30 Jul 2008 17:37:44 +0000 Subject: [PATCH 1/1] add a reasonable prefix to autogenerated TCNs git-svn-id: svn://svn.open-ils.org/ILS/trunk@10191 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 4a9794e8ad..b87e091c93 100644 --- a/Open-ILS/src/sql/Pg/010.schema.biblio.sql +++ b/Open-ILS/src/sql/Pg/010.schema.biblio.sql @@ -22,7 +22,7 @@ CREATE SCHEMA biblio; CREATE SEQUENCE biblio.autogen_tcn_value_seq; CREATE FUNCTION biblio.next_autogen_tcn_value () RETURNS TEXT AS $$ - BEGIN RETURN nextval('biblio.autogen_tcn_value_seq'::TEXT); END; + BEGIN RETURN 'AUTOGENERATED-' || nextval('biblio.autogen_tcn_value_seq'::TEXT); END; $$ LANGUAGE PLPGSQL; CREATE TABLE biblio.record_entry ( -- 2.43.2