mirror of
https://github.com/windmill-labs/windmill.git
synced 2026-10-13 08:02:47 +00:00
Ruben FiszelandClaude Opus 5
e62bfdcd8c
* fix: give every table a primary key so the db can be logically replicated Co-Authored-By: Claude Opus 5 (1M context) <noreply@anthropic.com> Claude-Session: https://claude.ai/code/session_017WS9iNfYQiLJNuBnxysBzi * fix: tighten replicability guard and trim migration comments Co-Authored-By: Claude Opus 5 (1M context) <noreply@anthropic.com> Claude-Session: https://claude.ai/code/session_017WS9iNfYQiLJNuBnxysBzi * fix: split deployment_metadata into its own primary-key migration Co-Authored-By: Claude Opus 5 (1M context) <noreply@anthropic.com> Claude-Session: https://claude.ai/code/session_017WS9iNfYQiLJNuBnxysBzi * docs: correct the partial-index predicate note after the deployment_metadata split Co-Authored-By: Claude Opus 5 (1M context) <noreply@anthropic.com> Claude-Session: https://claude.ai/code/session_017WS9iNfYQiLJNuBnxysBzi --------- Co-authored-by: Claude Opus 5 (1M context) <noreply@anthropic.com>
10 lines
502 B
SQL
10 lines
502 B
SQL
-- Dropping the column drops the primary key and the identity sequence with it, and
|
|
-- only marks the column dropped in the catalog rather than rewriting the table, so
|
|
-- this takes the ACCESS EXCLUSIVE lock but not the time.
|
|
|
|
ALTER TABLE workspace_runnable_dependencies DROP COLUMN IF EXISTS id;
|
|
ALTER TABLE dbt_node DROP COLUMN IF EXISTS id;
|
|
ALTER TABLE dbt_edge DROP COLUMN IF EXISTS id;
|
|
ALTER TABLE dbt_column_edge DROP COLUMN IF EXISTS id;
|
|
ALTER TABLE dbt_graph_snapshot DROP COLUMN IF EXISTS id;
|