[Qgis-user] Index attribute no longer updated automatically

[Nyall Dawson]

On Mon, 21 Feb 2022 at 15:08, Johanna Botman <johannab at melton.vic.gov.au> wrote:
>
> Hi,
>
>
>
> Another QGIS 3.22.3 question.
>
>
>
> I have layers that come from a MSSQL database. Those tables were loaded into SQL using Easy Loader (I know, shh!) so they have the MI_PRINX attribute.
>
> In past versions of QGIS, this MI_PRINX attribute was updated automatically when a new feature is saved in a layer. That has stopped in 3.22.
>
>
>
> In my settings when a new feature is created, the default behaviour of Suppress attribute from pop-up after feature creation is not ticked, so a new feature created does open a pop-up box. The attribute for MI_PRINX is Orange and there is a small orange x on the right hand side.

Sounds like your database table has a not-null constraint on this
MI_PRINX attribute, which QGIS is detecting. That's what the orange x
represents -- the attribute value isn't valid for the layer.

Nyall