Skip to content

v1.9.8: Schema qualification for ALL Lakebase tables

Choose a tag to compare

@knowusuboaky knowusuboaky released this 16 May 22:57
· 75 commits to main since this release

Comprehensive Schema Fix

Added explicit PostgreSQL schema qualification to ALL Lakebase table operations.

Problem

Table operations were not using schema-qualified names, causing issues when:

  • Tables exist in different schemas
  • Default search_path doesn't include expected schema
  • Schema isolation is required

Solution

Added helper methods for schema-qualified table references:

  • _table_ref(name) → "schema"."name"
  • _doc_table_ref() → "schema"._vectrix_documents
  • _node_table_ref() → "schema"._vectrix_nodes

Methods Fixed

Collection Operations:

  • _ensure_collection_table, insert, insert_batch
  • get, get_batch, update, delete, delete_batch, scan, count
  • vector_search, hybrid_search, ultimate_search

Document Index Operations:

  • ensure_document_tables, save_document, get_document, list_documents
  • delete_document, save_node, get_node, get_document_nodes
  • get_child_nodes, delete_document_nodes

Notes

  • DeltaLake storage already uses _full_table_name() - no changes needed
  • CosmosDB is schemaless NoSQL - no changes needed

Install

pip install vectrixdb==1.9.8