Postgres Pro
Downloads
Home   >   mailing lists

timestamp default current_timestamp not working - Mailing list pgsql-general

From Sanjay Minni
Subject timestamp default current_timestamp not working
Date
Msg-id CAMpxBomkxEiQW7rV-S1ewsEccLRHULJv5QWDmWmr05VSOTg-MA@mail.gmail.com
Whole thread Raw
Responses Re: timestamp default current_timestamp not working  (Ron <ronljohnsonjr@gmail.com>)
Re: timestamp default current_timestamp not working  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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

with warm regards
Sanjay Minni

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: locks within select
Next
From: Ron
Date:
Subject: Re: timestamp default current_timestamp not working