[OPEN-ILS-DEV] AUTO-GENERATED

[Grant Johnson]

Never mind... Found it



F. Grant Johnson
  Systems Coordinator
  Robertson Library
  University of Prince Edward Island


>>> On Wed, May 27, 2009 at  9:47 AM, in message <4A1D366A.6080606 at grpl.org>, Bill
Ott <bott at grpl.org> wrote: 
> 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;