Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pa35p-0001is-Lp for pgsql-general@arkaria.postgresql.org; Wed, 08 Mar 2023 23:21:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pa35n-0003ah-6f for pgsql-general@arkaria.postgresql.org; Wed, 08 Mar 2023 23:21:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pa35m-0003aX-Ki for pgsql-general@lists.postgresql.org; Wed, 08 Mar 2023 23:21:06 +0000 Received: from mail-qv1-xf31.google.com ([2607:f8b0:4864:20::f31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pa35h-0006GA-2D for pgsql-general@lists.postgresql.org; Wed, 08 Mar 2023 23:21:05 +0000 Received: by mail-qv1-xf31.google.com with SMTP id ne1so296664qvb.9 for ; Wed, 08 Mar 2023 15:21:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1678317660; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=9k9Vpg3fyWeUF7ZVF0MlMkG5Cn2kJqDY/MApELTJASQ=; b=EaB3v1ewP4TKmm1nL/50PLwcceLC8HNVFIFuz+TjfdYxmgTu/DK+4mmoiqQrYkyy9H eOEmDUjEpxHf+axPIFyroGFmd2OjyYpdgSNMIuQdGDug3OVa8pTHwF8aTfjqJTcydthR sc1bg+foReg89L4NxDyVykX9WQEpoMoU7wJXLIZY8SF5IBa/d8+vhvWTaBBkwqmXVIrj jqKN6FHxHOVqFEPwguRzvWD/dUP7CBodRrjFwKgHnAaQa9sauTD6tHNtT1zkSicYcJ3T BFW5TiTaI8Bu6r/HTxNY1MD8RQr/gbTuc0jybuqJ6O3/A+MbRuPWd+4yAMVYrssg5Dau 2UQA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678317660; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=9k9Vpg3fyWeUF7ZVF0MlMkG5Cn2kJqDY/MApELTJASQ=; b=1BKBbQSQB4WgWEORCxi2yB2H6oKRf1r5EjpmI69FC25LQhOXS55fEehbpbzdRvww57 Ikh4V5+KMhKkmk3lqWJz6dxp+JeLSlnhYp/w7MVzN++SYD8xFB/QM6t6W8JycDtoxALE RgIZHvWzlGHT3NOslnf79V7pLn37d3RgK0hCq/eWytl5v524Y+ph5pQewiLDeSs7R0LH ZgoBErsAyAZv6FlCllb34RmpDi11PvLzNKgEqB6ajXBviaw492Rrl/7ZhdIm2X2PMD7V PmwnD6B5XjSn8Y1+XRB8nNt4DSDFC1NbB52NIIKMXWDg7ABBwx2ze1Tva2U4Jj5wGEk9 TKrA== X-Gm-Message-State: AO0yUKWTC2zX6pzHXHfPAa00I76XbsALZPPt+UGl592sg/DFvnIk6bsS SR05n19OWQDNV4RS50vUl/9AynEJATE= X-Google-Smtp-Source: AK7set8KfY8uTmbLwWvoC+sYG6rpJE+hmCGIl3f764PsBhEPkRnHgMtN+eroyh63yOyYI97d4EnuHw== X-Received: by 2002:a05:6214:27e5:b0:56b:eb95:9a52 with SMTP id jt5-20020a05621427e500b0056beb959a52mr26321463qvb.15.1678317659844; Wed, 08 Mar 2023 15:20:59 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::43? ([2600:1700:bd2c:b810::43]) by smtp.googlemail.com with ESMTPSA id l11-20020a37f90b000000b0071ddbe8fe23sm12181995qkj.24.2023.03.08.15.20.59 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 08 Mar 2023 15:20:59 -0800 (PST) Content-Type: multipart/alternative; boundary="------------1ZTuZrz89bVP8l6A96T48CAs" Message-ID: <94d5c746-60e8-3cb2-b500-1332e74a1cb4@gmail.com> Date: Wed, 8 Mar 2023 17:20:58 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <46DE0CE7-7E90-480D-8395-74E5309F7D26@yugabyte.com> <26A104A8-0B5F-421A-996E-226B4770F0BC@yugabyte.com> <121427.1678250955@sss.pgh.pa.us> <2DD444F9-4B17-4BDE-B735-E1E9EB7B2B45@yugabyte.com> From: Ron In-Reply-To: <2DD444F9-4B17-4BDE-B735-E1E9EB7B2B45@yugabyte.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------1ZTuZrz89bVP8l6A96T48CAs Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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. --------------1ZTuZrz89bVP8l6A96T48CAs Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit 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.
--------------1ZTuZrz89bVP8l6A96T48CAs--