Update dependencies to use/permit pgvector 0.3

[amotl]

Hi there,

thanks a stack for conceiving langchain-postgres. We are using it to derive langchain-cratedb from, because CrateDB is compatible with PostgreSQL, and that works perfectly well.

@ccurme: We are in dear need for an update, because, currently, using the adapter (both langchain-postgres and langchain-cratedb) is not possible when downstream projects already depend on pgvector>=0.3.0, which has been released on Jun 26, 2024.

GH-147 by @danielfornarini does even more about bringing in features of recent pgvector, but at the minimum, we need it to unblock installing pgvector 0.3.

With kind regards,
Andreas.

Problem

poetry add langchain-cratedb

Because no versions of langchain-cratedb match >0.1.0,<0.2.0
 and langchain-cratedb (0.1.0) depends on langchain-postgres (0.0.12), langchain-cratedb (>=0.1.0,<0.2.0) requires langchain-postgres (0.0.12).
And because langchain-postgres (0.0.12) depends on pgvector (>=0.2.5,<0.3.0), langchain-cratedb (>=0.1.0,<0.2.0) requires pgvector (>=0.2.5,<0.3.0).
So, because langflow depends on both pgvector (0.3.6) and langchain-cratedb (^0.1.0), version solving failed.

[amotl]

Software tests succeed without ado on GH-157, so GH-147 can possibly be scheduled for a subsequent release?

[eyurtsev]

merged