Horton

Re: Calling PLpgSQL function with composite type fails with an error: "ERROR: could not open relation with OID ..."

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ashutosh Sharma <ashu.coek88@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2019-12-27T03:50:34Z
Lists: pgsql-hackers 
Ashutosh Sharma <ashu.coek88@gmail.com> writes:
> Okay. Thanks for that fix. You've basically forced
> revalidate_rectypeid() to update the PLpgSQL_rec's rectypeid
> irrespective of typcache entry requires re-validation or not.

Right.  The assignment is cheap enough that it hardly seems
worth avoiding.

			regards, tom lane

Commits

  1. Fix possible loss of sync between rectypeid and underlying PLpgSQL_type.