Re: [GENERAL] Adding 3 hours while inserting data into table

2014-08-07 Thread Gaurav Tiwari G
any sense or is there any way to do so. ?? Regards, Gaurav Tiwari -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Thursday, August 07, 2014 8:05 PM To: Gaurav Tiwari G; M Tarkeshwar Rao; pgsql-general@postgresql.org Subject: Re: [GENERAL] Adding 3 h

Re: [GENERAL] Adding 3 hours while inserting data into table

2014-08-07 Thread Gaurav Tiwari G
e required ?? Regards, Gaurav Tiwari -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Thursday, August 07, 2014 8:30 PM To: Gaurav Tiwari G; M Tarkeshwar Rao; pgsql-general@postgresql.org Subject: Re: [GENERAL] Adding 3 hours while inserting data into table On 08/

Re: [GENERAL] Adding 3 hours while inserting data into table

2014-08-07 Thread Gaurav Tiwari G
, August 06, 2014 6:42 PM To: M Tarkeshwar Rao; pgsql-general@postgresql.org Cc: Gaurav Tiwari G Subject: Re: [GENERAL] Adding 3 hours while inserting data into table On 08/06/2014 03:50 AM, M Tarkeshwar Rao wrote: > Hi Team, > > We are facing some inconsistence behaviour of Postgres

Re: [GENERAL] Adding 3 hours while inserting data into table

2014-08-07 Thread Adrian Klaver
On 08/07/2014 08:09 AM, Gaurav Tiwari G wrote: Hi, Java application configuration has no issue, we have cross check it. On third point, what data you require as you mentioned that "what is being provided to the Postgres server and what the result is ". I think postgres.conf would be sufficie

Re: [GENERAL] Adding 3 hours while inserting data into table

2014-08-07 Thread Adrian Klaver
On 08/07/2014 07:49 AM, Gaurav Tiwari G wrote: Hi, 1. Postgres configuration might be the suspect area but as we are not specifying any timezone related property. I was not talking about Postgres, it is not the application but the server. I was referring to whatever Java application you are r

Re: [GENERAL] Adding 3 hours while inserting data into table

2014-08-07 Thread Adrian Klaver
On 08/06/2014 11:29 PM, Gaurav Tiwari G wrote: Hi, Plz find my comment inline below. One more point, if we direct fired insert query, then it is working fine but with application, it is showing problem. Points at a configuration issue in the application. Regards, Gaurav Tiwari > We a

Re: [GENERAL] Adding 3 hours while inserting data into table

2014-08-06 Thread Adrian Klaver
On 08/06/2014 03:50 AM, M Tarkeshwar Rao wrote: Hi Team, We are facing some inconsistence behaviour of Postgres. We have deployed our database on a server where timezone is GMT+3 hours. What Postgres version? How was Postgres installed and on what OS? We have application which is running on

[GENERAL] Adding 3 hours while inserting data into table

2014-08-06 Thread M Tarkeshwar Rao
Hi Team, We are facing some inconsistence behaviour of Postgres. We have deployed our database on a server where timezone is GMT+3 hours. We have application which is running on the same server. When application starts, it is inserting the correct timestamp in the table but after running few mi