[OPEN-ILS-DEV] AUTO-GENERATED

Bill Ott bott at grpl.org
Wed May 27 08:47:38 EDT 2009


Grant Johnson said the following on 05/27/2009 08:42 AM:
> Where might I find the "AUTO-GENERATED" string for auto-generated TCN's during Z39-50 import.
> Can't find it with a grep...
>
> Is it in the database?
>
>   

Indeed it is, assuming you're looking for the following.

Found in:
 Open-ILS/src/sql/Pg/1.2.2.3-1.2.3.0-upgrade.sql


CREATE OR REPLACE FUNCTION biblio.next_autogen_tcn_value () RETURNS TEXT 
AS $$
    BEGIN RETURN 'AUTOGENERATED-' || 
nextval('biblio.autogen_tcn_value_seq'::TEXT); END;




More information about the Open-ils-dev mailing list