Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Probably want bulk function compilation #206

Open
workingjubilee opened this issue Feb 14, 2023 · 2 comments
Open

Probably want bulk function compilation #206

workingjubilee opened this issue Feb 14, 2023 · 2 comments
Labels
enhancement New feature or request

Comments

@workingjubilee
Copy link
Contributor

Considering the pg_dump and pg_restore use case: By the time we get to large suites of thousands of functions, we're gonna want to have the ability to rebuild everything in one go.

@JohnHVancouver
Copy link
Contributor

OOC what would be the use case? To attempt to compile everything with the latest set of lints? I think you could create a plpgsql wrapper around the information in pg_proc technically. There use to be a recompile_function in earlier versions that I think the intent was to be used by read replicas backed when things were stored on disk?

@workingjubilee
Copy link
Contributor Author

Yes. Our current assumption is that the contents of the pg_dump someone uses pg_restore on should not be trusted, and may not match the current environment, nor configuration, nor etc., and we should rerun the compilation process from the top.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants