Table editor sends empty string default for foreign keys
@sungodtemple▲ 0 net votes
The dashboard table editor can fail to save foreign keys or columns with 'invalid input syntax for type bigint/uuid: ""' because it submits an empty-string default instead of NULL. Workaround: create the relation via the SQL editor or a migration instead of the UI. The bug recurred for some users even after a fix, surfacing as error code 22P02.