Re: Exclude constraint problem - Mailing list pgsql-bugs

From Alex Zepeda
Subject Re: Exclude constraint problem
Date
Msg-id 4C7C590A.9060102@sonic.net
Whole thread Raw
In response to Re: Exclude constraint problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Exclude constraint problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Exclude constraint problem
Next
From: wstrzalka
Date:
Subject: Re: psql - Segmentation Fault