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

Documentation example to list/delete an IMMV #109

Open
adamguo0 opened this issue Dec 20, 2024 · 0 comments
Open

Documentation example to list/delete an IMMV #109

adamguo0 opened this issue Dec 20, 2024 · 0 comments
Labels
documentation Improvements or additions to documentation enhancement New feature or request

Comments

@adamguo0
Copy link

Hi, I'm wondering if we can add a documentation example on how to list/delete an IMMV? I think it will help new users to spell it out in the docs.

Something like this to list IMMVs and their queries:

SELECT immvrelid AS immv_oid, get_immv_def(immvrelid) AS immv_def FROM pg_catalog.pg_ivm_immv;

If I understand correctly, to drop an IMMV you just need to drop the table.

DROP TABLE immv;
@adamguo0 adamguo0 changed the title Function/documentation example to list/delete an IMMV Documentation example to list/delete an IMMV Dec 20, 2024
@yugo-n yugo-n added enhancement New feature or request documentation Improvements or additions to documentation labels Feb 17, 2025
yugo-n added a commit that referenced this issue Mar 11, 2025
- Added an example demonstrating an IMMV with aggregate functions
 (Issue #105)

- Added examples for listing and deleting an IMMV. (Issue #109)

- Noted that IMMVs must be manually dropped and recreated after
  restoring data from pg_dump or performing pg_upgrade. (Issue #118)

- Added a reinder to set session_preload_libraries or
  shared_preload_libraries during instlation. (Issue #119)
yugo-n added a commit that referenced this issue Mar 11, 2025
- Added an example demonstrating an IMMV with aggregate functions
 (Issue #105)

- Added examples for listing and deleting an IMMV. (Issue #109)

- Noted that IMMVs must be manually dropped and recreated after
  restoring data from pg_dump or performing pg_upgrade. (Issue #118)

- Added a reinder to set session_preload_libraries or
  shared_preload_libraries during instlation. (Issue #119)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
documentation Improvements or additions to documentation enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants