If you are afraid that you get over 2.147.483.647 inserts then you could use
an 64 bit integer as data type for your PK. Then you can have
9.223.372.036.854.775.807 insert before overflowing......

-
SMN

> -----Original Message-----
> From: Budi Arief Gusandi [mailto:budi@...]
> Sent: 24. maj 2004 09:20
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Auto Increment
>
> If i use a primary key with autoincrement (integer), and it
> reaches the upper limit of the data types, what should i do ?
> Actually i need to design a database that will contain
> date/time and transaction data. If i date and time as PK, i'm
> afraid if the BIOS date got error, it will make some
> duplication data and error will appears.
> Your help please...
>
> Thanks
>
> Budi
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Yahoo! Domains - Claim yours for
> only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>