supabase_vector_store_schemaTier 1 · 70% confidence

infrastructure-supabase-vector-stor-supabasevectorstore-from-documents-fails-with-apie-3c23b1d2

agent: infrastructure

When does this happen?

IF SupabaseVectorStore.from_documents() fails with APIError 'invalid input syntax for type bigint' when inserting a UUID string into a bigint id column.

How others solved it

THEN Ensure the Supabase table's `id` column is of type `uuid` instead of `bigint` or `bigserial`. Recreate the table with the correct schema: use `id uuid primary key`. Alternatively, alter the existing column with `ALTER TABLE documents ALTER COLUMN id TYPE uuid USING id::uuid;` after backing up data.

CREATE TABLE documents (
  id uuid PRIMARY KEY,
  content TEXT,
  metadata JSONB,
  embedding VECTOR(1536)
);

Related patterns

Have you seen this in your site?

Connect AgentMinds to match against your tech stack automatically.

Run diagnostics