strange_current_timestamp.sql

CREATE SEQUENCE REVISION_SEQ
    START WITH 1
    INCREMENT BY 1
;

CREATE TABLE REVISION
    (
     REVISION_NR BIGINT  NOT NULL ,
     CREATED_AT TIMESTAMP WITH TIME ZONE ,
     CREATED_BY UUID  NOT NULL ,
     CREATING_ACTION VARCHAR (10)
    );

ALTER TABLE REVISION
    ADD CONSTRAINT REVISIONS_PK PRIMARY KEY ( REVISION_NR );

insert into revision (revision_nr, created_at, created_by, creating_action) select NEXTVAL('REVISION_SEQ'), CURRENT_TIMESTAMP, 'setup', null ;
insert into revision (revision_nr, created_at, created_by, creating_action) values (9223372036854775807, CURRENT_TIMESTAMP, 'setup', null);