Skip to content

[BUG]: ALTER COLUMN FOR BOOLEAN #15829

@MaksimChernyavsky

Description

@MaksimChernyavsky

While updating default value for my boolean database column, i have an error while run migrations like

Runtime Error: Failed to modify column 'auto_tz' in table 'user_settings'. In 'UserSettingsMigration_100' migration. DB error: SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "COLUMN"
LINE 1:  ALTER COLUMN "auto_tz" SET DEFAULT false;

I suppose it is because code In class Phalcon\Db\Dialect\Postgresql (see image)
Screenshot 2021-12-13 at 19 33 00

Metadata

Metadata

Assignees

Labels

5.0The issues we want to solve in the 5.0 releasebugA bug reportstatus: mediumMedium

Type

No fields configured for Bug.

Projects

Status
Released

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions