你好@CannonFodderr!我在这里帮助你解决关于仓库的任何错误、问题或贡献。请随时寻求帮助！

要解决pgvector组件中连接字符串解析的问题，其中以'@'字符结尾的密码导致解析错误，你可以修改build方法，以确保连接字符串被正确地URL编码。可以使用Python的urllib.parse模块对连接字符串中的密码部分进行编码。

以下是如何更新build方法：

from urllib.parse import quote

def build(
    self,
    embedding: Embeddings,
    pg_server_url: str,
    collection_name: str,
    documents: Optional[Document] = None,
) -> Union[VectorStore, BaseRetriever]:
    """
Builds the Vector Store or BaseRetriever object.

Args:
- embedding (Embeddings): The embeddings to use for the Vector Store.
- documents (Optional[Document]): The documents to use for the Vector Store.
- collection_name (str): The name of the PG table.
- pg_server_url (str): The URL for the PG server.

Returns:
- VectorStore: The Vector Store object.
"""
    try:
        # Parse the connection string to handle special characters in the password
        parsed_url = pg_server_url.split('@')
        if len(parsed_url) == 2:
            user_info, host_info = parsed_url
            user_info = user_info.split(':')
            if len(user_info) == 2:
                user, password = user_info
                password = quote(password, safe='')
                pg_server_url = f"{user}:{password}@{host_info}"

        if documents is None:
            vector_store = PGVector.from_existing_index(
                embedding=embedding,
                collection_name=collection_name,
                connection_string=pg_server_url,
            )
        else:
            vector_store = PGVector.from_documents(
                embedding=embedding,
                documents=documents,  # type: ignore
                collection_name=collection_name,
                connection_string=pg_server_url,
            )
    except Exception as e:
        raise RuntimeError(f"Failed to build PGVector: {e}")
    return vector_store

这段代码确保密码中的所有特殊字符(包括'@')都被正确地URL编码，防止连接字符串被错误解析。

• 要继续与1(https://github.com/logspace-ai/langflow/blob/dev/src/backend/langflow/components/vectorstores/pgvector.py)交流，请提及@dosu。*

on it

嘿，@CannonFodderr,

请确保在连接字符串中包含"SQL",应该是：
postgresql://user:12345@@postgreshost.dev/dbname
而不是：
postgres://user:12345@@postgreshost.dev/dbname

非常感谢！