Re: postgres 11 issue?

Поиск
Список
Период
Сортировка
От Steve Rogerson
Тема Re: postgres 11 issue?
Дата
Msg-id ef35f12c-ed6d-2aa5-4bcc-12acbcab08a1@yewtc.demon.co.uk
обсуждение исходный текст
Ответ на Re: postgres 11 issue?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On 03/07/2019 20:36, Tom Lane wrote:
>
> It looks like what's happening is that the result of my_from_local()
> is being stored into the table as an anonymous record value rather
> than a value of type my_timestamp.  (The originating session can figure
> out what the anonymous record type is, but no other session can.)
> That should be fixed, but in the meantime you could dodge the problem by
> declaring my_from_local()'s v_result variable as my_timestamp not record.
>
Thanks for the quick response. The "workaround" works, though it would seem
best practice in any case.

Steve



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

Предыдущее
От: Andrey Sychev
Дата:
Сообщение: Re: Error: rows returned by function are not all of the same row type
Следующее
От: PegoraroF10
Дата:
Сообщение: Re: Converting to identity columns with domains on PK columns