From a46760b8a53a7221ea8fe9a87e6a85020474efc1 Mon Sep 17 00:00:00 2001 From: miker Date: Sat, 2 Aug 2008 14:53:20 +0000 Subject: [PATCH] set a reasonable prefix on autogenerated TCN values git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_2@10238 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/010.schema.biblio.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/010.schema.biblio.sql b/Open-ILS/src/sql/Pg/010.schema.biblio.sql index 845edc3eba..c3148b5761 100644 --- a/Open-ILS/src/sql/Pg/010.schema.biblio.sql +++ b/Open-ILS/src/sql/Pg/010.schema.biblio.sql @@ -21,8 +21,8 @@ BEGIN; 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; +CREATE OR REPLACE FUNCTION biblio.next_autogen_tcn_value () RETURNS TEXT AS $$ + BEGIN RETURN 'AUTOGENERATED-' || nextval('biblio.autogen_tcn_value_seq'::TEXT); END; $$ LANGUAGE PLPGSQL; CREATE TABLE biblio.record_entry ( -- 2.11.0