[Bug] PostgreSQL Migration 1.9.0 fails: column "online" is of type integer but default expression is of type boolean #1018

New Issue

MrUnknownDE · 2026-04-05T18:07:28+02:00

MrUnknownDE commented

2026-04-05 18:07:28 +02:00

Originally created by @Blacks-Army on 8/25/2025

Hi,
when running the 1.9.0 migration, the following error occurs:

Failed query: ALTER TABLE "exitNodes" ADD COLUMN "online" integer DEFAULT false NOT NULL;
error: column "online" is of type integer but default expression is of type boolean

Logs:

DrizzleQueryError: Failed query: ALTER TABLE "exitNodes" ADD COLUMN "online" integer DEFAULT false NOT NULL;
cause: error: column "online" is of type integer but default expression is of type boolean
code: '42804'

Expected behavior:
The migration should add the column successfully.

*Originally created by @Blacks-Army on 8/25/2025* Hi, when running the 1.9.0 migration, the following error occurs: ```yaml Failed query: ALTER TABLE "exitNodes" ADD COLUMN "online" integer DEFAULT false NOT NULL; error: column "online" is of type integer but default expression is of type boolean ``` Logs: ```yaml DrizzleQueryError: Failed query: ALTER TABLE "exitNodes" ADD COLUMN "online" integer DEFAULT false NOT NULL; cause: error: column "online" is of type integer but default expression is of type boolean code: '42804' ``` Expected behavior: The migration should add the column successfully.

MrUnknownDE closed this issue

2026-04-05 18:07:28 +02:00

Sign in to join this conversation.

Branches Tags

main

dev

dependabot/npm_and_yarn/dev-minor-updates-b4e5d6b9c5

revert-2766-feature/systemd-install-instructions

dependabot/npm_and_yarn/prod-patch-updates-05702d39f2

dependabot/npm_and_yarn/next-16.2.1

dependabot/npm_and_yarn/recharts-3.8.1

alerting-rules

private-site-ha

dependabot/docker/docker/library/node-25-slim

ssh

delete-account

msg-delivery

org-only-idp

cicd

patch

site-targets-auto-login

No Label

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/pangolin#1018