Re: Exclude constraint problem

Поиск
Список
Период
Сортировка
От Alex Zepeda
Тема Re: Exclude constraint problem
Дата
Msg-id 4C7C590A.9060102@sonic.net
обсуждение исходный текст
Ответ на Re: Exclude constraint problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Exclude constraint problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Tom Lane wrote:
> Alex Zepeda <zipzippy@sonic.net> writes:
>> I'd be happy to provide someone with a copy of the dump...
>> but it's ~70MB bzip'd.
>
> I'd be willing to take a look ... but if my WAG is right, the insertion
> order would be critical information to reproduce the problem.  Is it
> possible to tell what order the rows were inserted in?

Yes.  There are two relevant columns:
   id -- a sequence
   created_at -- a timestamp w/ timezone

The timestamps are all a bit wonky, but in a consistent manner due
to how ActiveRecord handles timezones.

- alex

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Exclude constraint problem
Следующее
От: wstrzalka
Дата:
Сообщение: Re: psql - Segmentation Fault