Re: timestamp default current_timestamp not working

On 12/14/21 07:36, Sanjay Minni wrote:
> Hi
> 
> I am not getting the timestamp value which i am expecting to be 
> automatically inserted in the column defined:
> ...
> "timestamp" timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
> ...
> (I see the above definition in pgadmin4 in the tab SQL.
> I have set it thru pgadmin4 table->properties->columns by entering 
> CURRENT_TIMESTAMP in the default column)
> 
> why is the timestamp value not being automatically inserted by the system

1) It is a DEFAULT value so if a value is provided in the INSERT that 
will be used.

2) DEFAULT values only apply to INSERTs not UPDATEs.

> 
> with warm regards
> Sanjay Minni


-- 
Adrian Klaver
adrian.klaver@aklaver.com