Re: Avoid orphaned objects dependencies, take 3

Поиск
Список
Период
Сортировка
Искать
От
Bertrand Drouvot
Тема
Re: Avoid orphaned objects dependencies, take 3
Дата
Msg-id
aD2v88PeJ4WzhUOX@ip-10-97-1-34.eu-west-3.compute.internal
Ответ на
Список
Дерево обсуждения
Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Alexander Lakhin <exclusion@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Alexander Lakhin <exclusion@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Alexander Lakhin <exclusion@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Alexander Lakhin <exclusion@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Alexander Lakhin <exclusion@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Alexander Lakhin <exclusion@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Michael Paquier <michael@paquier.xyz>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Alexander Lakhin <exclusion@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Jeff Davis <pgsql@j-davis.com>
Re: Avoid orphaned objects dependencies, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Jeff Davis <pgsql@j-davis.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Jeff Davis <pgsql@j-davis.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Roman Eskin <r.eskin@arenadata.io>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Jeff Davis <pgsql@j-davis.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Ashutosh Sharma <ashu.coek88@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Ashutosh Sharma <ashu.coek88@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Avoid orphaned objects dependencies, take 3 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Hi,

On Thu, May 22, 2025 at 12:38:50PM -0700, Jeff Davis wrote:
> Which
> call sites are the most interesting ones that need special attention?

I think the ones that need special attention are the ones that check for
the permissions on the referenced objects *after* recordMultipleDependencies is
called (see [1]).

Does that make sense to you? 

[1]: https://www.postgresql.org/message-id/aD2u/GR/yaRkBJdJ%40ip-10-97-1-34.eu-west-3.compute.internal

Regards,

-- 
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com


В списке pgsql-hackers по дате отправления
От: Bertrand Drouvot
Дата:
От: Nathan Bossart
Дата:
FAQ