Re: [ADMIN] Changing the time on the server

2003-02-21 Thread Tom Lane
"Donald Fraser" <[EMAIL PROTECTED]> writes: > Could somebody tell me the consequences of setting the date forward in time= > on the server running PostgreSQL and then at a later date, after some tran= > sactions have been committed, setting the date back in time? AFAIR, Postgres itself couldn't c

Re: [ADMIN] Changing the time on the server

2003-02-21 Thread Nikolaus Dilger
Donald, It depends on your application and by how much you change the time. If you have a database field that is populated with the system time when you insert records your application logic may not work as intended. Not sure why you would want to play with the system clock in the first place.

[ADMIN] Changing the time on the server

2003-02-21 Thread Donald Fraser
Could somebody tell me the consequences of setting the date forward in time on the server running PostgreSQL and then at a later date, after some transactions have been committed, setting the date back in time?   Thanks in advance, Donald Fraser