[OPEN-ILS-DEV] AUTO-GENERATED

[Grant Johnson]

Got a "Best practice" recommendation on this one?
-- 

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

>>> On 5/27/2009 at 12:28 PM, in message
<b918cf3d0905270828g3ccd89c7y3b278a4c8a16a827 at mail.gmail.com>, Mike Rylander
<mrylander at gmail.com> wrote:
> On Wed, May 27, 2009 at 9:25 AM, Grant Johnson <fgjohnson at upei.ca> wrote:
>> I use pgAdminIII.
>> And went into the function() biblio.autogen_tcn_value and just updated the 
> string to UPEI.
>> We have had a few collisions that this was used.
>>
>> Does this cause any other real issues except for aesthetic problems?
>> If not then it's one of those "local mods" that we'll just have to document 
> and remember...
>>
> 
> This one in particular, not today.  If an upgrade script decides to
> depend on that value, obviously, hilarity will ensue. ;)
> 
> --miker
> 
>>
>>
>> F. Grant Johnson
>>  Systems Coordinator
>>  Robertson Library
>>  University of Prince Edward Island
>>
>>
>>>>> On Wed, May 27, 2009 at 10:13 AM, in message
>> <b918cf3d0905270613i421f95ceuafc07496abfc9869 at mail.gmail.com>, Mike Rylander
>> <mrylander at gmail.com> wrote:
>>> On Wed, May 27, 2009 at 9:01 AM, Grant Johnson <fgjohnson at upei.ca> wrote:
>>>> Thanks Bill,
>>>> How might I change that to UPEI or something?
>>>
>>> You could issue:
>>>
>>> CREATE OR REPLACE FUNCTION biblio.next_autogen_tcn_value () RETURNS
>>> TEXT AS $$BEGIN RETURN 'UPEI-' ||
>>> nextval('biblio.autogen_tcn_value_seq'::TEXT); END;
>>>
>>> in psql.
>>>
>>> That stored procedure is used when there is no non-colliding TCN
>>> candidate in the record, and (hopefully!) no cadidate TCNs are in the
>>> form of "AUTOGENERATED-{number}".  Have you found a case where they
>>> are, and you can't spot your own autogenerated tcns?  As long as the
>>> prefix is stable, and no one else is using it, any value is equivalent
>>> -- UPEI and AUTOGENERATED serve the same purpose.  I'm just concerned
>>> about db-level (essentially) aesthetic changes that could potentially
>>> cause upgrade pain.
>>>
>>> --miker
>>>
>>>>
>>>>>>> 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;
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
> 
>