Re: Losing data
От
Tom Lane
Тема
Re: Losing data
Дата
Msg-id
19287.1213899626@sss.pgh.pa.us
Ответ на
Re: Losing data (Garry Saddington)
Список
Дерево обсуждения
Losing data Garry Saddington <garry@schoolteachers.co.uk>
Re: Losing data "Joshua D. Drake" <jd@commandprompt.com>
Re: Losing data Garry Saddington <garry@schoolteachers.co.uk>
Re: Losing data Alan Hodgson <ahodgson@simkin.ca>
Re: Losing data Garry Saddington <garry@schoolteachers.co.uk>
Re: Losing data "Joshua D. Drake" <jd@commandprompt.com>
Re: Losing data Garry Saddington <garry@schoolteachers.co.uk>
Re: Losing data "Joshua D. Drake" <jd@commandprompt.com>
Re: Losing data Robert Treat <xzilla@users.sourceforge.net>
Re: Losing data Garry Saddington <garry@schoolteachers.co.uk>
Re: Losing data Tom Lane <tgl@sss.pgh.pa.us>
Re: Losing data Geoffrey <lists@serioustechnology.com>
Re: Losing data Bill Moran <wmoran@collaborativefusion.com>
Re: Losing data Garry Saddington <garry@schoolteachers.co.uk>
Re: Losing data Tom Lane <tgl@sss.pgh.pa.us>
Re: Losing data Tino Wildenhain <tino@wildenhain.de>
Re: Losing data "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Losing data Garry Saddington <garry@schoolteachers.co.uk>
Garry Saddington writes: > Oh, and the problem has been intermittant. Another > thing that happened this morning is that Postgres had today as 18/06/2008 > when in fact it was 19/06/2008 and the OS reported this correctly. Two theories about that one: 1. Postgres' timezone setting is far away from where you are. 2. You were in a transaction that had been open since yesterday. now() and related functions show time of transaction start. #2 is interesting since forgetting to commit an open transaction might also explain the "data loss" complaint. regards, tom lane
В списке pgsql-general по дате отправления
