Re: creating gist index seems to look at data ignoring transaction?

2019-04-11 Thread Tom Lane
Palle Girgensohn writes: > I noticed some bad data where end < begin, so I modified these first, and > tried to vcreate the index in the same transaction. The index creation does > not notice the data changes. It seems creating the gist index this is not > transaction safe? Index creation has

creating gist index seems to look at data ignoring transaction?

2019-04-11 Thread Palle Girgensohn
Hi, I have a table with two dates, timeframe_begin and timeframe_end. I'd like to use daterange operators on this table, and an easy way would be to set up an index using gist on daterange(timeframe_begin, timeframe_end, '[]'); I noticed some bad data where end < begin, so I modified these