Function normalizePostgreSQLTypecastInDefault

backend/plugin/schema/differ.go:708–732

normalizePostgreSQLTypecastInDefault normalizes PostgreSQL type casts in default values

(defaultValue string)

// normalizePostgreSQLTypecastInDefault normalizes PostgreSQL type casts in default values
func normalizePostgreSQLTypecastInDefault(defaultValue string) string {
	if defaultValue == "" {
		return ""
	}

	normalized := strings.TrimSpace(defaultValue)

	// Remove PostgreSQL type casts from default values
	// Handle patterns like '1 day'::interval -> '1 day'
	normalized = strings.ReplaceAll(normalized, "'::interval", "'")
	normalized = strings.ReplaceAll(normalized, "'::timestamp", "'")
	normalized = strings.ReplaceAll(normalized, "'::date", "'")
	normalized = strings.ReplaceAll(normalized, "'::time", "'")
	normalized = strings.ReplaceAll(normalized, "'::numeric", "'")

	// Handle string type casts
	// Handle character varying first (longest match first to avoid partial replacement)
	normalized = strings.ReplaceAll(normalized, "'::character varying", "'") // CHARACTER VARYING type (full form of VARCHAR)
	normalized = strings.ReplaceAll(normalized, "'::bpchar", "'")            // CHAR type
	normalized = strings.ReplaceAll(normalized, "'::text", "'")              // TEXT type
	normalized = strings.ReplaceAll(normalized, "'::varchar", "'")           // VARCHAR type
	normalized = strings.ReplaceAll(normalized, "'::character", "'")         // CHARACTER type

	return normalized
}

// generationMetadataEqual compares two generation metadata structs.
func generationMetadataEqual(engine storepb.Engine, gen1, gen2 *storepb.GenerationMetadata) bool {