Re: Should AT TIME ZONE be volatile?

Поиск
Список
Период
Сортировка
От Shay Rojansky
Тема Re: Should AT TIME ZONE be volatile?
Дата
Msg-id CADT4RqDvg-juSfRW0sfYbsP-nxxwhQWD01LHH76_V=xw-xNxEA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Should AT TIME ZONE be volatile?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Yeah, it's not clear that forbidding this would make anyone's life any
> better.  If you want an index on the UTC equivalent of a local time,
> you're going to have to find a way to cope with potential mapping
> changes.  But refusing to let you use a generated column doesn't
> seem to help that.

Makes sense, thanks Tom.

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [PATCH] Partial foreign key updates in referential integrity triggers
Следующее
От: "houzj.fnst@fujitsu.com"
Дата:
Сообщение: RE: [BUG]Invalidate relcache when setting REPLICA IDENTITY