[BUG] TIPG_DB_EXCLUDE_TABLES only accepts list of length 1

[jonaraphael]

I have a deployed TiPG instance in GCP Cloud Run, utilizing many environmental variables to control the deployment, like:
"TIPG_TABLE_CONFIG__public_mytable__GEOMCOL" = mygeomcol

The DB Setting TIPG_DB_EXCLUDE_TABLES is described in the documentation as accepting a list of strings, however, it silently fails when provided with a list of length 2.

TIPG_DB_EXCLUDE_TABLES = ["public.mytable1"] <<< This works, and reduces the exposed collections to exclude mytable1
TIPG_DB_EXCLUDE_TABLES = ["public.mytable2"] <<< This works, and reduces the exposed collections to exclude mytable2
TIPG_DB_EXCLUDE_TABLES = ["public.mytable1", "public.mytable2"] <<< This fails, and the exposed collections are NOT reduced.

My version is pinned to tipg~=0.3.0

[vincentsarago]

Thanks for the report @jonaraphael I can confirm this and add a failing test

something is not working here

tipg/tipg/sql/dbcatalog.sql

Line 249 in 9c5bbf0

AND (exclude_tables IS NULL OR concat(c.relnamespace::regnamespace::text,'.',c.relname::text) != ANY (exclude_tables))

[vincentsarago]

@jonaraphael I've started a PR #131 to fix this but adding more tests showed that we also have a bug for the functions.