SQL_IDENTIFIER_RE issue

[jseabold]

I have encountered table names that look like schema.table.name and reflection is breaking because SQL_IDENTIFER_RE.findall(key) returns a list of length 3 in dialect._get_schema_and_relation.

[jseabold]

Seems like you may be able to get away with something like this since the schema / relation split doesn't need to meet the redshift identifier rules.

identifiers = re.split("\.", key, 1)

[graingert]

Do you have the example DDL?

[jseabold]

What else you need? The relname from pg_catalogue.pg_class for an ordinary table is 'schema.schema.table', so it was created with something like

create table schema."stupid.name" (id int);

and the relname won't reflect the quotes, when you query pg_catalog.pg_class.