CheckViolationError

[ianhorn]

Here is a link to a thread I started stac3698 channel.

I am adding new items to an existing collection but get this error:

{
  "code": "CheckViolationError",
  "description": "new row for relation \"_items_2\" violates check constraint \"_items_2_dt\"\nDETAIL:  Failing row contains (N069E285_2025_DEM_Phase3_cog.tif, 0103000020E6100000010000000500000087DF74E4CA3155C04A0551A1382C43..., dem-phase3, 2025-03-03 00:00:00+00, 2025-03-08 00:00:00+00, {\"bbox\": [-84.77800856984514, 38.3454782147988, -84.760390309226..., null)."
}

Nothing has changed in my scripts and the output looks the same as existing item json files.  I understand that it's a constraint on the pgstac side, but I've tried removing start/end time and just having datetime, no date.  nothing works.  Here's a basic file:

"type": "Feature",
    "stac_version": "1.1.0",
    "stac_extensions": [
        "https://stac-extensions.github.io/projection/v2.0.0/schema.json"
    ],
    "id": "N069E285_2025_DEM_Phase3_cog.tif",
    "geometry": {
        "type": "Polygon",
        "coordinates": [
            [
                [
                    -84.77800856984514,
                    38.3454782147988
                ],
                [
                    -84.77800856984514,
                    38.35935175928568
                ],
                [
                    -84.76039030922635,
                    38.35935175928568
                ],
                [
                    -84.76039030922635,
                    38.3454782147988
                ],
                [
                    -84.77800856984514,
                    38.3454782147988
                ]
            ]
        ]
    },
    "bbox": [
        -84.77800856984514,
        38.3454782147988,
        -84.76039030922635,
        38.35935175928568
    ],
    "properties": {
        "license": "CC-BY-4.0",
        "start_datetime": "2025-03-03T00:00:00Z",
        "end_datetime": "2025-03-08T00:00:00Z",
        "proj:code": "EPSG:3089",
        "proj:geometry": {
            "type": "Polygon",
            "coordinates": [
                [
                    [
                        5200000.0,
                        4015000.0
                    ],
                    [
                        5200000.0,
                        4020000.0
                    ],
                    [
                        5205000.0,
                        4020000.0
                    ],
                    [
                        5205000.0,
                        4015000.0
                    ],
                    [
                        5200000.0,
                        4015000.0
                    ]
                ]
            ]
        },
        "proj:bbox": [
            5200000.0,
            4015000.0,
            5205000.0,
            4020000.0
        ],
        "proj:shape": [
            2500,
            2500
        ],
        "proj:transform": [
            2.0,
            0.0,
            5200000.0,
            0.0,
            -2.0,
            4020000.0,
            0.0,
            0.0,
            1.0
        ],
        "extensions": [
            "https://stac-extensions.github.io/projection/v1.1.0/schema.json"
        ],
        "datetime": "2025-03-03T00:00:00Z"
    },
    "links": [],
    "assets": {
        "asset": {
            "href": "https://kyfromabove.s3.us-west-2.amazonaws.com/elevation/DEM/Phase3/N069E285_2025_DEM_Phase3_cog.tif",
            "type": "image/tiff; application=geotiff; profile=cloud-optimized",
            "title": "asset",
            "roles": [
                "data"
            ]
        }
    },
    "collection": "dem-phase3"

Edited: Just to make sure my stac item was fine, I created a new temporary collection and posted the item no problem.

The only solution I can think to do is proceed with creating my items and saving to file. Grab my back up item json files, delete the collection, create a new, and post both the existing and new items together.