On Thu, Oct 12, 2023 at 1:31 PM Nikita Malakhov <huku...@gmail.com> wrote:
> About using surrogate key - this feature is more for data generated by > the DBMS itself, i.e. data processed by some extension and saved > and re-processed automatically or by user's request, but without bothering > user with these internal keys. > Then what does it matter whether you spell it: 12345 or my_ext.do_something(int) ? Why do you require us to redefine the scope for which pg_proc.oid is useful in order to implement this behavior? Your extension breaks if your user uses logical backups or we otherwise get into a position where pg_upgrade cannot be used to migrate in the future. Is avoiding the textual representation so necessary that you need to add another dependency to the system? That just seems unwise regardless of how easy it may be to accomplish. David J.
