chore(spanner): add gorm data type names for PG types (#13584)

olavloite · web-flow · commit d23326bf90f9 · 2026-01-13T00:13:27.000+05:30
Add gorm data type names for PostgreSQL-specific types. This prevents gorm from interpreting these structs as models, and automatically creates columns with the correct data type when used as a field in a model. Needed for googleapis/go-gorm-spanner#199
diff --git a/spanner/value.go b/spanner/value.go
@@ -1051,6 +1051,11 @@ func (n *PGNumeric) UnmarshalJSON(payload []byte) error {
 	return nil
 }
 
+// GormDataType is used by gorm to determine the default data type for fields with this type.
+func (n PGNumeric) GormDataType() string {
+	return "numeric"
+}
+
 // NullProtoMessage represents a Cloud Spanner PROTO that may be NULL.
 // To write a NULL value using NullProtoMessage set ProtoMessageVal to typed nil and set Valid to true.
 type NullProtoMessage struct {
@@ -1285,6 +1290,11 @@ func (n *PGJsonB) UnmarshalJSON(payload []byte) error {
 	return nil
 }
 
+// GormDataType is used by gorm to determine the default data type for fields with this type.
+func (n PGJsonB) GormDataType() string {
+	return "jsonb"
+}
+
 func nulljson(valid bool, v interface{}) ([]byte, error) {
 	if !valid {
 		return []byte("null"), nil
