Re: postgres 11 issue? - Mailing list pgsql-general

From Steve Rogerson
Subject Re: postgres 11 issue?
Date
Msg-id ef35f12c-ed6d-2aa5-4bcc-12acbcab08a1@yewtc.demon.co.uk
Whole thread Raw
In response to Re: postgres 11 issue?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Andrey Sychev
Date:
Subject: Re: Error: rows returned by function are not all of the same row type
Next
From: PegoraroF10
Date:
Subject: Re: Converting to identity columns with domains on PK columns