Method GenerateIndexName

server/tables/pg_database.go:271–296

GenerateIndexName implements the sql.IndexNameGenerator interface with PostgreSQL-compatible naming conventions: - UNIQUE indexes: _ [_col2...]_key - All other indexes: _ [_col2...]_idx Collisions are resolved by appending a numeric suffix (1, 2, …) to the base name. The c

(ctx *sql.Context, tableName string, idxDef sql.IndexDef, _ sql.Table)

// view, sequence, or another index — blocks a candidate name, matching PostgreSQL's
// behavior where all relations in a schema share one namespace.
func (d *PgDatabase) GenerateIndexName(ctx *sql.Context, tableName string, idxDef sql.IndexDef, _ sql.Table) (string, error) {
	colPart := strings.Join(idxDef.ColumnNames(), "_")
	suffix := "_idx"
	if idxDef.IsUnique() {
		suffix = "_key"
	}
	base := tableName + "_" + colPart + suffix

	exists, _, err := d.doesRelationExist(ctx, base)
	if err != nil {
		return "", err
	}
	if !exists {
		return base, nil
	}
	for i := 1; ; i++ {
		candidate := fmt.Sprintf("%s%d", base, i)
		exists, _, err = d.doesRelationExist(ctx, candidate)
		if err != nil {
			return "", err
		}
		if !exists {
			return candidate, nil
		}
	}
}

// doesRelationExist tests if a relation with the specified |name| exists in this database. If any relation with that
// name exists, this function returns true for |exists|, the relation type (e.g. index, view, table, sequence) for