Re: The mysterious pg_proc.protrftypes

2021-01-25 Thread Tom Lane
"Joel Jacobson" writes: > Attached patch adds "(references pg_type.oid)" to the documentation for > pg_proc.protrftypes. Agreed, pushed. I also stumbled over a backend core dump while testing it :-(. So this whole area seems a bit spongy ... regards, tom lane

Re: The mysterious pg_proc.protrftypes

2021-01-25 Thread Pavel Stehule
po 25. 1. 2021 v 8:47 odesílatel Joel Jacobson napsal: > On Mon, Jan 25, 2021, at 08:14, Pavel Stehule wrote: > >you should to use TRANSFORM clause in CREATE FUNCTION statement > > Thanks, it worked, and like expected it references the pg_type.oid of the > transform. > > Attached patch adds

Re: The mysterious pg_proc.protrftypes

2021-01-24 Thread Joel Jacobson
On Mon, Jan 25, 2021, at 08:14, Pavel Stehule wrote: >you should to use TRANSFORM clause in CREATE FUNCTION statement Thanks, it worked, and like expected it references the pg_type.oid of the transform. Attached patch adds "(references pg_type.oid)" to the documentation for

Re: The mysterious pg_proc.protrftypes

2021-01-24 Thread Pavel Stehule
po 25. 1. 2021 v 8:05 odesílatel Joel Jacobson napsal: > Hi, > > I'm trying to understand how pg_proc.protrftypes works. > > The documentation says "Data type OIDs for which to apply transforms.". > For this column, there is no reference to any catalog table? > I would guess it should be

The mysterious pg_proc.protrftypes

2021-01-24 Thread Joel Jacobson
Hi, I'm trying to understand how pg_proc.protrftypes works. The documentation says "Data type OIDs for which to apply transforms.". For this column, there is no reference to any catalog table? I would guess it should be "(references pg_type.oid)", right? I tried to generate a value for this