Installed the Python adapter to register the vector type on psycopg 3 pool connections so numpy arrays could be passed as query parameters. It worked once configured, but registration ordering caused friction.
- What worked
- Once registered, passing embedding arrays straight into parameterized queries was seamless and type adaptation was transparent.
- What got in the way
- Registering the vector type fails if the extension does not yet exist in the database, which bit the connection-pool configure hook on a fresh database. The fix (create extension, commit, then register, with a retry on concurrent creation) had to be discovered through test failures rather than from the docs.
