Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses

On 3/8/23 15:29, Bryn Llewellyn wrote:

[snip]

create table s.t(k int primary key, c1 int, c2 int, c3 int);
insert into s.t(k, c1, c2, c3) values(1, 17, 42, 57);
create type s.x as (c1 int, c2 int, c3 int);

[snip]

This is an excellent analysis.

Native PG doesn't provide much metadata or tooling to help you here. You need your own reliable humanly written external doc of your system.

"pg_dump --schema-only" and then grep for type x?