PostgreSQL TinyInteger (tinyint) does not exist as a type

[nickb937]

As far as I can tell, the type tinyint, or 1-byte integer, does not exist for PostgreSQL: https://www.postgresql.org/docs/14/datatype-numeric.html

I suppose one solution is to define the column with a CHECK constraint, but it would cause hassle around forcing into a i8/u8 type:

room_bed_count SMALLINT CHECK (room_bed_count >=-128 && room_bed_count <= 127)

SeaORM definition:

impl ColumnTrait for Column {
    type EntityName = Entity;

    fn def(&self) -> ColumnDef {
        match self {
            Self::RoomId => ColumnType::BigInteger.def(),
            Self::RoomTag => ColumnType::String(Some(64)).def(),
            Self::RoomLocation => ColumnType::String(Some(32)).def().nullable(),
            Self::RoomType => ColumnType::String(Some(32)).def().nullable(),
            Self::RoomTypeOther => ColumnType::String(Some(32)).def().nullable(),
            Self::RoomRate => ColumnType::Decimal(Some((8, 2))).def().nullable(),
            Self::RoomRateUnit => ColumnType::String(Some(16)).def().nullable(),
            Self::RoomBedCount => ColumnType::TinyInteger.def(),
        }
    }
}

Resulting statement:

CREATE TABLE "asset_room" ( "room_id" bigserial NOT NULL PRIMARY KEY, "room_tag" varchar(64) NOT NULL, "room_location" varchar(32), "room_type" varchar(32), "room_type_other" varchar(32), "room_rate" decimal(8, 2), "room_rate_unit" varchar(16), "room_bed_count" tinyint NOT NULL );

Resulting psql error:

ERROR:  type "tinyint" does not exist
LINE 1: ...), "room_rate_unit" varchar(16), "room_bed_count" tinyint NO...

[billy1624]

Hey @nickb937, sorry for the delay.

For now, I will map ColumnType::TinyInteger to smallint

sea-query/src/backend/postgres/table.rs

Lines 32 to 35 in b9876ba

	ColumnType::TinyInteger(length) => match length {
	Some(length) => format!("tinyint({})", length),
	None => "tinyint".into(),
	},

REF: https://www.postgresql.org/docs/current/datatype.html