Pikaview: Handling postgres serial columns

Ignition
1

I am currently exploring the Pikaview exchange resource. From what I could test so far, it worked well with a MySQL database. However when I tried to use it with postgres, I got stuck when it came to displaying the data. It seems like the type conversion has problems handling postgres serial columns.

Those columns have a default value in the form of nextval('my_table_id_seq').

When I try to display a table for a newly created configuration I get the following error:

Traceback (most recent call last): File "", line 133, in transform File "module:exchange.pikaview.model_base", line 467, in getNewInstance File "module:exchange.pikaview.model_base", line 487, in _convertFromDBType File "module:exchange.pikaview.type_map", line 96, in convertFromDbType ValueError: invalid literal for int() with base 10: 'nextval('my_table_id_seq'::regclass)

I think MySQL works because it does not have a default value vor AUTO INCREMENT columns.

Any suggestions, where to start fixing this? I am not sure how I could extend the type_map to accommodate the serial columns?

2

The assumption that default values aren't expressions is common in the MySQL & MariaDB world. (MariaDB added support in v10.2-ish.)

PostgreSQL has supported expressions as defaults for ages, and uses that support to implement its auto-increment functionality.

You have to break the assumption that the default can be directly parsed as the data type of the column.