Error during item insert depending on properties datetime value

[g2giovanni]

Hi,
we have a running Stac Server with PGSTAC backend. When we try to add some Items with POST API /collections/{collection_id}/items we have an error like this:

{ "code": "UndefinedTableError", "description": "relation \"_items_24\" does not exist" }

We noticed that the error happens only when we try to insert an item with a properties datetime smaller than the constraint on the datetime we have on the partitions in the Items table.
For example, we have a collection HPR in our Stac Catalog and for this collection we have the following constraint in the table Items partition:

(datetime >= '2021-01-01 01:00:00+01'::timestamp with time zone) AND (datetime <= '2022-01-01 01:00:00+01'::timestamp with time zone) AND (end_datetime >= '2021-01-01 01:00:00+01'::timestamp with time zone) AND (end_datetime <= '2022-01-01 01:00:00+01'::timestamp with time zone)))

So we cannot insert item with a date smaller than year 2021 (we have the error reported above) but if we change the datetime to 2022 the insert ends without problem.

How can we overcome this problem? Who manages the creation and update of this constraints?

[gadomski]

cc @bitner ☝🏼

[bitner]

@g2giovanni can you tell me what version of stac-fastapi and what version of pgstac you are using?