Re: [Phpgroupware-developers] Scheme Proc on sequence for postgresql

[Edgar Luna]

Michael Dean <address@hidden> writes:

> The short version is that the sequence needs to be updated to match the
> table data after the new table is created and populated.  The flow of
> the function does not need to change.  Try adding this before the final
> return (beware of line wrapping):
Yeap.

> // Update sequence to match
> $sSeqField = '';
> $this->GetSequenceFieldForTable($oProc, $sTableName, $sSeqField);
> if ($sSeqField != '')
> {
>       $sSeqName = '';
>       $this->GetSequenceForTable($oProc, $sTableName, $sSeqName);
>       if ($sSeqName != '')
>       {
>               // we have a sequence name and the corresponding field, so it 
> must be
> golden
>               $sSQL = "SELECT SETVAL('$sSeqName', (SELECT MAX($sSeqField) FROM
> $sTableName))";
>               $oProc->m_odb->query($sSQL);
>       }
> }

Ok, I'll test with this then.

Thanks a lot

-- 
Edgar Antonio Luna Díaz - http://www.sogrp.com
Fingerprint: C008 5EAC 5272 AC8C 7589  4821 8B34 6166 8733 8310