pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
Date: Wed, 8 Mar 2023 17:20:58 -0600
Message-ID: <94d5c746-60e8-3cb2-b500-1332e74a1cb4@gmail.com> (raw)
In-Reply-To: <2DD444F9-4B17-4BDE-B735-E1E9EB7B2B45@yugabyte.com>
References: <46DE0CE7-7E90-480D-8395-74E5309F7D26@yugabyte.com>
	<CAKFQuwZrLZzoHCPc21X9PaWQPi74EUViwDjgNtgN3oM+AJfzfg@mail.gmail.com>
	<ECD0AB67-C3AC-4AD3-ABD8-0BF7AAE761B7@yugabyte.com>
	<CAKFQuwaihWfF9U1LvZMg3DQiXS55Rk2KA-HH1bUVPstpsdza1Q@mail.gmail.com>
	<26A104A8-0B5F-421A-996E-226B4770F0BC@yugabyte.com>
	<CAKFQuwbEgqCORc3MiDbeB6zRibO1Fg+19MTxNYeqDUsudYyc-w@mail.gmail.com>
	<CAKFQuwbx=xFMedvGBk99d9dLmNhu_KNC_LwknsWV1793qjWXLw@mail.gmail.com>
	<121427.1678250955@sss.pgh.pa.us>
	<2DD444F9-4B17-4BDE-B735-E1E9EB7B2B45@yugabyte.com>

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.

view thread (13+ messages)  latest in thread

Message-ID: <94d5c746-60e8-3cb2-b500-1332e74a1cb4@gmail.com>
Permalink:  ../94d5c746-60e8-3cb2-b500-1332e74a1cb4@gmail.com/
Also on:    postgresql.org/message-id/94d5c746-60e8-3cb2-b500-1332e74a1cb4@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: ronljohnsonjr@gmail.com
  Subject: Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
  In-Reply-To: <94d5c746-60e8-3cb2-b500-1332e74a1cb4@gmail.com>
  References: <46DE0CE7-7E90-480D-8395-74E5309F7D26@yugabyte.com> <CAKFQuwZrLZzoHCPc21X9PaWQPi74EUViwDjgNtgN3oM+AJfzfg@mail.gmail.com> <ECD0AB67-C3AC-4AD3-ABD8-0BF7AAE761B7@yugabyte.com> <CAKFQuwaihWfF9U1LvZMg3DQiXS55Rk2KA-HH1bUVPstpsdza1Q@mail.gmail.com> <26A104A8-0B5F-421A-996E-226B4770F0BC@yugabyte.com> <CAKFQuwbEgqCORc3MiDbeB6zRibO1Fg+19MTxNYeqDUsudYyc-w@mail.gmail.com> <CAKFQuwbx=xFMedvGBk99d9dLmNhu_KNC_LwknsWV1793qjWXLw@mail.gmail.com> <121427.1678250955@sss.pgh.pa.us> <2DD444F9-4B17-4BDE-B735-E1E9EB7B2B45@yugabyte.com> <94d5c746-60e8-3cb2-b500-1332e74a1cb4@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox