sqlboiler generates int instead of int32 for PostgreSQL int4 type, causing type inconsistency
Author: Lirous587Created Sep 16, 2025Updated Feb 28, 2026
Labelsbughelp wanted
Problem Description
When using sqlboiler with PostgreSQL, int4 (integer) columns are generated as int type in Go structs instead of int32. This causes type inconsistency issues because:
- PostgreSQL
int4is always 32-bit regardless of platform - Go
intis platform-dependent (32-bit on 32-bit systems, 64-bit on 64-bit systems) - This leads to unnecessary type conversions and potential overflow issues on 32-bit systems
Current Behavior
PostgreSQL Schema:
CREATE TABLE img_category (
id SERIAL PRIMARY KEY, -- int4 type
......
);Generated Go Code:
type ImgCategory struct {
ID int `boil:"id" json:"id" toml:"id" yaml:"id"`
......
}Expected Behavior
type ImgCategory struct {
ID int32 `boil:"id" json:"id" toml:"id" yaml:"id"`
......
}Source: aarondl/sqlboiler