Re: timestamp default current_timestamp not working

2021-12-14 Thread Adrian Klaver
On 12/14/21 08:00, Sanjay Minni wrote: Its an insert and my insert SQL contains the column timestamp and value nil. Will it work if the SQL contains timestamp through value is nil No nil(NULL) is a valid value for the field as you have not specified NOT NULL on the column. If you do add that co

Re: timestamp default current_timestamp not working

2021-12-14 Thread David G. Johnston
On Tuesday, December 14, 2021, Sanjay Minni wrote: > Its an insert and my insert SQL contains the column timestamp and value > nil. > Will it work if the SQL contains timestamp through value is nil > >> >> If you explicitly specify NULL for the value of the column then there is no need for the sy

Re: timestamp default current_timestamp not working

2021-12-14 Thread Ron
Show us the code (especially since there is no value "nil" in SQL). On 12/14/21 10:00 AM, Sanjay Minni wrote: Its an insert and my insert SQL contains the column timestamp and value nil. Will it work if the SQL contains timestamp through value is nil On Tue, 14 Dec, 2021, 9:20 pm Adrian Klaver,

Re: timestamp default current_timestamp not working

2021-12-14 Thread Sanjay Minni
Its an insert and my insert SQL contains the column timestamp and value nil. Will it work if the SQL contains timestamp through value is nil On Tue, 14 Dec, 2021, 9:20 pm Adrian Klaver, wrote: > On 12/14/21 07:36, Sanjay Minni wrote: > > Hi > > > > I am not getting the timestamp value which i am

Re: timestamp default current_timestamp not working

2021-12-14 Thread Adrian Klaver
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

Re: timestamp default current_timestamp not working

2021-12-14 Thread Ron
On 12/14/21 9:36 AM, 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 i