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

[Ron <ronljohnsonjr@xxxxxxxxx>]

    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?

--
Born in Arizona, moved to Babylonia.