Skip to content

Instantly share code, notes, and snippets.

@danielbwatson
danielbwatson / update_database_to_0.9.sql
Created March 13, 2025 23:18
Postgres updates for Apache Polaris to go from Aug 2024 to Polaris 0.9
begin;
set transaction read write;
-- Changing the type to match Polaris 0.9.x
ALTER TABLE entities
ALTER COLUMN internalproperties SET DATA TYPE text,
ALTER COLUMN name SET DATA TYPE text,
ALTER COLUMN properties SET DATA TYPE text;
-- Changing the type to match Polaris 0.9.x