edgedb icon indicating copy to clipboard operation
edgedb copied to clipboard

When adding a constraint to User.awards in cards db: InternalServerError: column old.id does not exist

Open msullivan opened this issue 1 year ago • 2 comments

_localdev:scope> alter type User create constraint exclusive on (.awards);
edgedb error: InternalServerError: column old.id does not exist
  Server traceback:
      edb.errors.InternalServerError: column old.id does not exist

msullivan avatar May 14 '24 20:05 msullivan

Same happens to me:

    type Report {
        required name: str;
        sim:=.<reports[is Similarity];

        trigger create_similarities after insert for each do (
            for other_report in (select Report filter .id != __new__.id)
            union (
                insert Similarity{
                    reports := DISTINCT {__new__, other_report}
                }
                unless conflict
            )
        )

    }

    type Similarity {
        multi reports: Report;
        constraint exclusive on (.reports); <-- when adding this 
        score: float64;
    }

Beiri22 avatar Jul 31 '25 20:07 Beiri22

This issue seems untouched for over one year. Is there any chance that someone has a look into it?

Beiri22 avatar Jul 31 '25 20:07 Beiri22