I get the following error when I try to delete from an archive enabled feature class view (DELETE FROM myschema.mytable_evw WHERE objectid = 3;):
ERROR: date/time field value out of range: "12.31.9999 23:59:59.999"
LINE 2: ... WHERE objectid = old.objectid AND gdb_to_date = '12.31.999...
HINT: Perhaps you need a different "datestyle" setting.
QUERY: UPDATE myschema.mytable SET gdb_to_date = current_timestamp(3) AT TIME ZONE 'UTC'
WHERE objectid = old.objectid AND gdb_to_date = '12.31.9999 23:59:59.999'
CONTEXT: PL/pgSQL function myschema.nvv_update_11() line 15 at SQL statement
********** Error **********
ERROR: date/time field value out of range: "12.31.9999 23:59:59.999"
SQL state: 22008
Hint: Perhaps you need a different "datestyle" setting.
Context: PL/pgSQL function myschema.nvv_update_11() line 15 at SQL statement
Updating and inserting records to the view works, but not deleting. Is this deliberate, and if so, why?
I'm using a 10.3.1 geodatabase in postgres 9.3.15 on linux.
Thanks
Simon