Skip to content
This repository was archived by the owner on Sep 22, 2025. It is now read-only.

PSQL mistake suggesting BOOLEAN -> BIT #305

@LiamMacpherson

Description

@LiamMacpherson

Apologies if maybe I've misunderstood, this is not the behaviour I've seen when implementing changesets or generating a changelog, while using PSQL 16.4. Incorrect assertion that creates confusion about the reading of the very complete table which follows.

Steps to reproduce the behavior:

  1. https://docs.liquibase.com/concepts/data-type-handling.html?
  2. Read the third paragraph in the introduction.

Expectation:
The documentation incorrectly states that BOOLEANs will be converted to BITs when running against a PostgreSQL table. This isn't the case. A more clarifying example should be supplied

<p>For example, if you specify the data type <code>BOOLEAN</code> in your changelog, Liquibase passes it to a Snowflake database as a <code>BOOLEAN</code>. However, on a PostgreSQL&#160;database, Liquibase converts it to a <code>BIT</code>.</p>

Image

Extra info:
PostgreSQL 16.4 (Debian 16.4-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
Liquibase 4.28.0

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions