Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Conversion Error Codes/ Error Codes Generated During Conversion from SQL Server to TaurusDB for PostgreSQL/ U0530007: TaurusDB for PostgreSQL processes DECIMAL as BIGINT and the sequence value exceeds the BIGINT range
Updated on 2025-10-22 GMT+08:00
View PDF
Share

U0530007: TaurusDB for PostgreSQL processes DECIMAL as BIGINT and the sequence value exceeds the BIGINT range

Description

Database Type and Version

  • Source database type and version: all SQL Server versions
  • Target database type and version: TaurusDB for PostgreSQL 16.4 and later

Syntax Example

DECIMAL and NUMERIC defined in a SQL Server database are processed as BIGINT in a TaurusDB for PostgreSQL database. If the precision exceeds 18, the value will exceed the BIGINT range. For example:

SQL Server syntax:

-- The sequence is created in the SQL Server database.
-- Error " sequence type must have precision 18 or less" is reported during sequence creation in the TaurusDB for PostgreSQL database.
CREATE SEQUENCE seq1
    as decimal(19)
    START WITH 1  
    INCREMENT BY 1
    MINVALUE 1
    CYCLE
GO

Suggestion

Determine whether workloads are affected.