ID integer values too large for column type 'integer' in postgres

[ccwittwer]

generateKey function in Repository outputs a 10-digit integer, which is used for a record ID. The integer can exceed max size for Postgres integer column.

    protected function generateKey($value)
    {
        $hash = sha1($value);
        $integerHash = base_convert($hash, 16, 10);

        return (int)substr($integerHash, 0, 10);
    }

Changing the substring length will correct the issue.

    protected function generateKey($value)
    {
        $hash = sha1($value);
        $integerHash = base_convert($hash, 16, 10);

        return (int)substr($integerHash, 0, 8);
    }

[frankpinto]

Was this ever addressed? Considering using this for Laravel 4 but I think I won't if 6 months have gone by without any word on such a simple issue

[clphillips]

generateKey() always returns the max 32-bit signed integer when using 32-bit PHP.

[whatyoubendoing]

This is fixed in #12. With the ability to add custom key generators.