book
Article ID: KB0080253
calendar_today
Updated On:
Description
In PostgreSQL, the data types 'smallserial', 'serial' and 'bigserial' are not true data types, but merely a notational convenience for creating unique identifier columns. When a custom query (in Spotfire connector) is used to retrieve data from a PostgreSQL data table that contains column type(s) as serial, Spotfire throws a query verification error as below:
External error:
Unable to map the following columns:
– Column <column name> with data type 'serial'
Issue/Introduction
Can TIBCO Spotfire read "Serial" Data Type from a PostgreSQL data table?
Environment
All supported OS versions