bug(postgres): cannot connect to postgres table with tsvector column

[gforsyth]

What happened?

Reposting from https://stackoverflow.com/questions/74520302/why-cant-i-connect-ibis-to-a-postgres-table-with-a-tsvector-column

Implementing whatever postgres functionality exists around tsvector may not be something we want to do, but I think we should at least allow connecting to the table.

What version of ibis are you using?

3.2.0

What backend(s) are you using, if any?

postgres

Relevant log output

KeyError                                  Traceback (most recent call last)
File ~/anaconda3/envs/ec_extract/lib/python3.9/site-packages/multipledispatch/dispatcher.py:269, in Dispatcher.__call__(self, *args, **kwargs)
    268 try:
--> 269     func = self._cache[types]
    270 except KeyError:

KeyError: (<class 'sqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2'>, <class 'sqlalchemy.dialects.postgresql.base.TSVECTOR'>)

During handling of the above exception, another exception occurred:

NotImplementedError                       Traceback (most recent call last)
*** 
----> 29 main_table = con.table(table_name)[columns['column_list']]

File ~/anaconda3/envs/ec_extract/lib/python3.9/site-packages/ibis/backends/base/sql/alchemy/__init__.py:438, in BaseAlchemyBackend.table(self, name, database, schema)
    428     return self.database(database=database).table(
    429         name=name,
    430         database=database,
    431         schema=schema,
    432     )
    433 sqla_table = self._get_sqla_table(
    434     name,
...
    275             (self.name, str_signature(types)))
    276     self._cache[types] = func
    277 try:

NotImplementedError: Could not find signature for dtype: <PGDialect_psycopg2, TSVECTOR>

Code of Conduct

• I agree to follow this project's Code of Conduct

[cpcloud]

What should we infer this type as? String?

[gforsyth]

I think that's what makes the most sense given what we currently support. We won't have any of the specialized string vector methods, but at least users can interact with the rest of the table.