In my case, the issue was that Postgres was looking for the vector type in the public
schema instead of the shared_extensions
schema. So this ended up working for me:
CREATE TABLE langchain_pg_embedding (
collection_id uuid,
embedding shared_extensions.vector(1536),
...
)