From: PABLO ANDRES IBARRA DUPRAT <Pablo.Ibarra@itau.cl>
To: Tom Lane <tgl@sss.pgh.pa.us>, "David G. Johnston"
	<david.g.johnston@gmail.com>
CC: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: RE: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
Thread-Topic: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
Thread-Index: AdrBtc8Wa3jKK7C+QuS+qp3e08m42QAAdLMAAALJdwAAADkTgAAAMUMg
Date: Tue, 18 Jun 2024 21:14:09 +0000
Message-ID: 
 <CPUP152MB4018C1DFC4FA4E667DA2758A87CE2@CPUP152MB4018.LAMP152.PROD.OUTLOOK.COM>
References: 
 <CPUP152MB401802939E39B07A3BD264A887CE2@CPUP152MB4018.LAMP152.PROD.OUTLOOK.COM>
 <CAKFQuwY0zN14+czWopnT3cZtK2vasrH08XCpXv_u84ejUU2u-g@mail.gmail.com>
 <CAKFQuwY4xtq=M6x2g2BLTgnjvgO=_7ORDF4gnuYX8w4J7eLLcA@mail.gmail.com>
 <4191919.1718744911@sss.pgh.pa.us>
In-Reply-To: <4191919.1718744911@sss.pgh.pa.us>
Accept-Language: es-ES, en-US
Content-Language: es-ES
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?h1i7siHEmFbPfPMp0s1EjdZ+ZSX1/62q5Gi4S8UskPyEbPCU+Y0ME/rLaGdk?=
 =?us-ascii?Q?b9egCqCj0xZm+KBVhF4eLi7Tyl5I6LI7iQrZAjhF+hTyYcbcBxKkKIxt5ov5?=
 =?us-ascii?Q?Zw8t2uHBzkn6SGKq7FbFsSJWE63b3FNYxq8x9RgV0oSdGD2RmsGFDRHQ0x5n?=
 =?us-ascii?Q?l+TIUxCVG8ty6WWifAToP5zf6rcwij3IK4XjpnfRZPvmFGci7IiuhKRuBkq2?=
 =?us-ascii?Q?6Q5nGSpcRXXPvV9IIygPKL9deyEcFoHffAcapHiOvw0JTNvP0qIgrDy6oBUs?=
 =?us-ascii?Q?g8Jo6xbJdMoutasR29216EwGlMKxHpqjeCxlCWhbhUWe0opt9dd5FRFhWQkY?=
 =?us-ascii?Q?lgDv1G8m+C/kITTf/s4irsdVGBfl6KElRud6BOuvmKcgimLLJH2YpG50+SAf?=
 =?us-ascii?Q?+bdJHbTEghY/2UNzYSyKSAky/ba53y07vl5fPyso2bdFO29U2s3yv0HSPE2Q?=
 =?us-ascii?Q?aLbo+BbDax1Xu0arRG77vuWqvhFksLRbZM4lYXUGAyFKSLdAjJP+nBbbwpm2?=
 =?us-ascii?Q?3IAK1M6Alrztquu9AlXgCmqvoiRWl7qsO+JzwnKfaWgPQ6tjglzmXC/DXS/S?=
 =?us-ascii?Q?OWgSaB29ZShlT4dRYRGB7T/mtbgNfXAmZN95P2CPxi/DqPUnxoB/4RtfE+SX?=
 =?us-ascii?Q?1CaV5pA57Ndn0a6/1qWPEm91gPFPTUXgvTkJXqtxyZlR65f//hVSncMSb1WM?=
 =?us-ascii?Q?CVQE0WW8co5IdvyrB5jrN04zoQrK4G08DGNM0OfEiSZAop6sLvmQHX0BBJu5?=
 =?us-ascii?Q?MWIYkJz3ccACtTu8zy50NzYwl6MySJCoVowCZJBIkDugS8A04gZxx1IOQ6jd?=
 =?us-ascii?Q?CGq881AjhuWbBD1SgJrWZ9SVTJWim3xZizUch8x0Uk56c5emb2kZsf3D6PcB?=
 =?us-ascii?Q?HyX8FU6KCQOt7Tcu24e6M7Rsw4s5N8dA3vfi0Z0+9W98yP9wMPpb1VOjBHDz?=
 =?us-ascii?Q?wNVQOArVLwzs8Nf0Z/R0xl41R07Md/XwSP0sfK0cCpHv8tMoZFMhWnybFIoQ?=
 =?us-ascii?Q?XNu0i1hXI5eq/ieSNcnfzxAW4xAOAXnYcyUwEljXS0Wlm6YvKLkzPH4WSW2l?=
 =?us-ascii?Q?gPpd62BrAUa9J/0w6XP95bDxSOE0Zh2/uINqOCi2R8y96j+46E+5Ncp2dtVa?=
 =?us-ascii?Q?MzKCWpNX1PnkG6iR4GaLPvILFqSBv+X0M6sVlpCKww8psy4DSA9R4v/eTPgI?=
 =?us-ascii?Q?Cp2anld7ooaAO2Mw2oqknmhtpYkpACCHZ5Jysuk2bpp6yXBdfAoHQuqU6Taz?=
 =?us-ascii?Q?yU38vq2G48euk8Z8OfTMQikiHgjZSz7qCLJaVm5aJ8BvFw/+reI9KmpWFmVO?=
 =?us-ascii?Q?5eVvUMZWb/Rj13Q2TGYTykblHEZYY796xF3v5pB6o+3nEPJaFGZwPxgQuIN+?=
 =?us-ascii?Q?iEzQcM8v7BIruCkhdBuVOsn/GZfJ1NGQvkMQxeCK0uEvHaUJdJlUDDmzf9Hi?=
 =?us-ascii?Q?IuZIbT1NK2rJTpzJsJQfzfyDBtrOBkDipdas5GhuFno8dURDXe85HGi59YEW?=
 =?us-ascii?Q?UqfvBX/Dgz4DbaUka6EPDXBEk56UzsnuHw3iiomTeUhmlcA9pXE/UOw0TfuM?=
 =?us-ascii?Q?3/ip6DCQI/B58sy1ZJE=3D?=
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: 
 Kc2zph9AVDzuW3VWCgBFU4uLOcUWNfAKSNUjIUutIgn6G0tlcpSvppuUPhx/nxL5HsJysKBWHBWlG8H5fGGBjNm8okL8pA6MJJceH7HcljwMJ9+JytPZM2ZFQ9jOPmWpEuPYk80WP7LziU3wS1BY17lyb5j2HW2P88+zJWrwRUXBBUy69P1HzGhkYREadcWzaFWWxyVpI4JN0sxRZL3kBRu4Q0mG72/VxR79wzRccaI6LJDYle035HNrpMqhhbb9TAIuaXX9E9vR4lXj60+QpjU0Nbz3EpKhb0q7SYTQNo5+KFsnEbCzhif8+/b4SYJne0L7MFKF8NZNwjdwNlb1Zllrv5hzFxkms2jJYtEQncxwu7t75+NthIXWDMZ1KZDIfQUOgNBZibums4ipF5MXFlWv040gbDlJHkKl8Pf4J4HhiQkpL/mEUVWrB6UM6LjeqdHsEFFRtZFekfqAuaBDr41Sbk3/XRpQfAJha4+v5l1BBD29jky9wOJO1O/a7dteS538a9O3D81Q7Ko/sbncrTjEcngW5UUHETmgSEvcIB6JWXoRCRQvIVA0EdGLegXeHeq2xAxAEukMGl6UG+Y6dm93YMKzlqDpvrgD0Y17TR/fpXwS5Fvi1shqXFJgseJt
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: CPUP152MB4018.LAMP152.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 6ffe9a24-8d3d-4490-6d06-08dc8fdb9889
X-MS-Exchange-CrossTenant-originalarrivaltime: 18 Jun 2024 21:14:09.9192
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 9f4ba6d4-caa0-4b65-bbc9-687b3123882b
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 SuU6pyQZxJwhQo2mWNrLn8rExcxrIy5GzrtCRluBsMt6KfqLET9yMVNzyYRWIiCFk3bt+5njW1KrpSAqdeHuBQ==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: CPVP152MB5231
Content-Transfer-Encoding: quoted-printable
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/CPUP152MB4018C1DFC4FA4E667DA2758A87CE2%40CPUP152MB4018.LAMP152.PROD.OUTLOOK.COM>
Precedence: bulk

Thanks in advance


-----Mensaje original-----
De: Tom Lane <tgl@sss.pgh.pa.us> =

Enviado el: martes, 18 de junio de 2024 17:09
Para: David G. Johnston <david.g.johnston@gmail.com>
CC: PABLO ANDRES IBARRA DUPRAT <Pablo.Ibarra@itau.cl>; pgsql-admin@lists.po=
stgresql.org
Asunto: Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> Specifically:

> select id.*, pg_proc.*, tableoid from pg_proc,
> pg_identify_object(1255,oid,0) as id;

Personally, I'd cast the procedure's OID to regprocedure instead.
More or less the same output, doesn't require magic numbers.

(Although I think you could write "pg_proc.tableoid" instead of "1255", if =
you're intent on using pg_identify_object.)

			regards, tom lane
Para asegurar la adecuada lectura en todo tipo de correos electronicos, se =
han omitido intencionalmente los signos y acentos diacriticos del idioma ca=
stellano. La informacion contenida en este mensaje y cualquier archivo adju=
nto es confidencial y no puede ser usada por mas personas que sus destinata=
rios. El uso no autorizado de esta informacion puede ser sancionado de conf=
ormidad con el Codigo Penal chileno. Si ha recibido este correo por error, =
por favor notifique al remitente respondiendo este mismo mensaje y elimine =
el mensaje y todos los archivos adjuntos. Internet no puede garantizar la i=
ntegridad de este mensaje, por lo que el Banco no se hace responsable si el=
 contenido del mismo ha sido alterado.