sicasley

Error when using SQL DELETE on archive view

Discussion created by sicasley on Jan 3, 2017
Latest reply on Jan 5, 2017 by sicasley

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

Outcomes