Re: Patch: shouldn't timezone(text, timestamp[tz]) be STABLE?

Поиск
Список
Период
Сортировка
От Aleksander Alekseev
Тема Re: Patch: shouldn't timezone(text, timestamp[tz]) be STABLE?
Дата
Msg-id CAJ7c6TN-9OJWbkmsYLmm8vgX-zZZXdUGSEzrXWHv0Y-v5BE66g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Patch: shouldn't timezone(text, timestamp[tz]) be STABLE?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Patch: shouldn't timezone(text, timestamp[tz]) be STABLE?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> BTW, it's customary to *not* include catversion bumps in submitted
> patches

Thanks, Tom.

> Anyway, attached is a revised patch that gets rid of the antique
> code, and it produces correct results AFAICT.

I tested your patch against the current master branch 78aa616b on
MacOS Catalina. I have nothing to add to the patch.

> I'm fairly unhappy now that we don't have any
> regression test coverage for this function.

Yep, that's unfortunate. I see several tests for `AT TIME ZONE`
syntax, which is a syntax sugar to timezone() with timestamp[tz]
arguments. But considering how `timetz` type is broken in the first
place [1], I'm not surprised few people feel motivated to do anything
related to it. Do you think there is a possibility that one day we may
be brave enough to get rid of this type?


[1]: https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use_timetz

-- 
Best regards,
Aleksander Alekseev



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

Предыдущее
От: "r.takahashi_2@fujitsu.com"
Дата:
Сообщение: RE: Implementing Incremental View Maintenance
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: [BUG] Failed Assertion in ReorderBufferChangeMemoryUpdate()