Commit graph

  • d7d3977c2f This commit fixes two issues 1. Saves from race condition while doing table scan in object acess hook, which arises when the current drop object is pg_ivm_immv's toast table, which looks up for primary key which already got dropped earlier. 2. Use RangeVarGetRelidExtended(... AccessShareLock ...) instead of get_relname_relid(). That way, DROP EXTENSION can't cause errors in concurrent sessions that are in the middle of running the hook. ibhaskar2 2024-08-23 01:55:51 +0530
  • 85b11c359a
    Add a note for create_immv in README.md Yugo Nagata 2024-08-06 04:11:25 +0900
  • bb3c999c05 Add a missing file v1.9.1 v1.9 Yugo Nagata 2024-08-06 02:24:43 +0900
  • 12a0120d45 Prepare 1.9 Yugo Nagata 2024-07-31 13:00:31 +0900
  • 65a2d36b22
    Add support for PostgreSQL 17 (#92) Yugo Nagata 2024-07-31 12:37:43 +0900
  • d702c8099d Add support for PostgreSQL 17 for_pg17 Yugo Nagata 2024-07-31 11:39:02 +0900
  • 7dff2f5402
    Add support for PostgreSQL 17 (#84) thoshiai 2024-03-27 15:28:39 +0900
  • ff19b21d10 Add support for PostgreSQL 17 Takuma Hoshiai 2024-03-25 13:20:55 +0900
  • 76888cd975
    Fix compile with PG17 (#76) reshke 2024-03-25 05:25:27 +0500
  • 9736c8c832 Prepare 1.8 v1.8 Yugo Nagata 2024-03-01 23:28:28 +0900
  • fc2339e16c
    Fix checking for expressions containing an EXISTS subquery (#71) thoshiai 2024-03-01 20:33:56 +0900
  • 980c4be338 Fix typo in the previous commit Yugo Nagata 2024-03-01 19:56:05 +0900
  • 71deafdc9e
    Merge branch 'main' into fix_exists Yugo Nagata 2024-03-01 19:45:34 +0900
  • 6b9df6a8d5 clean up codes Takuma Hoshiai 2024-03-01 17:01:54 +0900
  • b3603c776d Change restriction handling and flags for EXISTS subquery Takuma Hoshiai 2024-03-01 16:48:16 +0900
  • d67995c0ab Fix an error raised when dropping pg_ivm extension Yugo Nagata 2024-03-01 14:48:55 +0900
  • 8f5bb5300a Check if PgIvmImmvRelationId is invalid before open it (#78) Colin Zhao 2024-03-01 13:13:38 +0800
  • 01f0ea0eb1 Fix for view using both DISTINCT and EXISTS Yugo Nagata 2024-02-27 19:32:45 +0900
  • 8c3b4ba9d7 Consider tuple duplicity in maintenance of EXISTS views Yugo Nagata 2024-02-27 17:09:34 +0900
  • 6634f5f253 Fix for view using both DISTINCT and EXISTS Yugo Nagata 2024-02-27 19:32:45 +0900
  • eb0e4400fe Consider tuple duplicity in maintenance of EXISTS views Yugo Nagata 2024-02-27 17:09:34 +0900
  • aab9db3605
    Fix typo in README heading (#81) Éric Redon 2024-02-20 08:37:14 +0100
  • 4656489c58
    Fix typo in README heading Éric Redon 2024-02-12 07:49:40 +0100
  • 7eb8a1da38 fix a expression including EXISTS condition under AND condition thoshiai 2024-01-15 03:28:29 +0900
  • 6f5ae0ee22 Merge branch 'main' into fix_exists thoshiai 2024-01-15 02:46:06 +0900
  • c888c1aee7 Check if PgIvmImmvRelationId is invalid before open it Colin Zhao 2023-11-07 16:44:17 +0800
  • 7bbbce9fd8 Fix compile with PG17 reshke 2023-09-30 17:08:13 +0300
  • 8f87d0914a Prepare 1.7 v1.7 Yugo Nagata 2023-09-13 11:13:40 +0900
  • 71f9d268b0
    Add support for PostgreSQL 16 (#69) (#70) Yugo Nagata 2023-09-11 15:23:51 +0900
  • 5c3705703b Remov a unnecessary counter variable Yugo Nagata 2023-09-11 15:03:02 +0900
  • cf821d7850 Fix EXISTS restriction thoshiai 2023-09-09 17:38:29 +0900
  • f8760ec95e Add support for PostgreSQL 16 (#69) Yugo Nagata 2023-09-07 11:28:59 +0900
  • 6f99049848 Prepare 1.6 v1.6 Yugo Nagata 2023-08-31 21:11:36 +0900
  • 1b4fb57774
    Prohibit types without default btree opclass in the target list (#67) Yugo Nagata 2023-08-31 21:06:23 +0900
  • 07f0bd41bd Prohibit types without default btree opclass in the target list Yugo Nagata 2023-08-31 20:41:50 +0900
  • c355f4003b
    Support exists_subquery (#53) thoshiai 2023-08-31 11:51:36 +0900
  • 3a35f22c81 Summarize the process of sublink restriction thoshiai 2023-08-25 17:49:49 +0900
  • 0ad579f339 Add README.md thoshiai 2023-08-08 18:20:27 +0900
  • d5bfa72a4a Add restriction of SubLink in pg_ivm thoshiai 2023-08-08 17:32:16 +0900
  • 60e6a358b5 Fix segmentation fault and add some spaces thoshiai 2023-08-08 05:56:32 +0900
  • 01bc0111f7 Fix some comments and error messages hoshiai 2023-07-26 06:57:15 +0900
  • c0f8a22fa1 Fix and cleanup source code thoshiai 2023-06-25 05:18:49 +0900
  • 1f729c842a
    Update README.md (#55) 64-more-details-for-the-immutable-functions-error-message Valentino 2023-03-20 09:44:21 +0100
  • a81c657223 Bump up version number to 1.5.1 v1.5.1 Yugo Nagata 2023-02-17 11:36:37 +0900
  • aaaa6cff66 Rebuild the query for recalculating min/max after search_path change Yugo Nagata 2023-02-24 14:56:05 +0900
  • 14bb84c599 Fix to use qualified function names during maintenance Yugo Nagata 2023-02-14 02:19:59 +0900
  • 99a176ab97 Fix row level security checks during view maintenance Yugo Nagata 2023-02-14 01:47:05 +0900
  • 12737a7a8e Bump up version number to 1.5.1 Yugo Nagata 2023-02-17 11:36:37 +0900
  • 440d8ec3b1 Rebuild the query for recalculating min/max after search_path change Yugo Nagata 2023-02-24 14:56:05 +0900
  • 6669c2b870
    Update README.md Valentino 2023-02-21 13:58:03 +0100
  • 37cc423128 Fix to use qualified function names during maintenance Yugo Nagata 2023-02-14 02:19:59 +0900
  • c4197970dc Fix row level security checks during view maintenance Yugo Nagata 2023-02-14 01:47:05 +0900
  • f29aa802b8 Support exists_subquery hoshiai 2023-01-26 11:20:50 +0900
  • 0587e78651
    Update README.md v1.5 Yugo Nagata 2023-01-30 19:04:54 +0900
  • f0e5467281 Prepare 1.5 Yugo Nagata 2023-01-30 12:28:53 +0900
  • b928e32774
    Add CTE support (#47) Yugo Nagata 2023-01-30 11:28:27 +0900
  • 7997f3e260 Remove a unnecessary function call Yugo Nagata 2023-01-27 15:25:58 +0900
  • 8b564de029 Prohibit unreferenced CTE Yugo Nagata 2023-01-27 11:02:06 +0900
  • 61eca8c30c Add some tests for CTE and remove unnecessary one Yugo Nagata 2023-01-23 18:29:23 +0900
  • 9972f279c4 Add CTE support in IVM Yugo Nagata 2023-01-12 15:11:48 +0900
  • b4b5ea28fd
    Add some qeury checks on subqueries (#49) Yugo Nagata 2023-01-26 16:59:15 +0900
  • e00ff9dd32
    Fix to allow generate_sereis in FROM clause (#50) Yugo Nagata 2023-01-26 16:58:20 +0900
  • e712da5bed Fix to allow generate_sereis in FROM clause Yugo Nagata 2023-01-25 11:58:57 +0900
  • 8dfc6d8b3d Fix regression tests on subqueries Yugo Nagata 2023-01-25 11:40:23 +0900
  • 0e581c16e7 Fix automatic index creation to support subqueries Yugo Nagata 2023-01-12 16:04:15 +0900
  • 3ee64ef4a6 Fix automatic index creation to support subqueries Yugo Nagata 2023-01-12 16:04:15 +0900
  • 138eb19254
    Fix Makefile to install pg_ivm--1.3--1.4.sql (#45) v1.4.1 Yugo Nagata 2023-01-10 18:41:50 +0900
  • 21f7049c30 Fix Makefile to install pg_ivm--1.3--1.4.sql Yugo Nagata 2023-01-10 18:37:30 +0900
  • 65b2e4937e
    Fix small typos in README.md (#44) 0xflotus 2023-01-10 10:20:27 +0100
  • cc233a330f
    fix: small errors 0xflotus 2023-01-02 13:42:23 +0100
  • 992fc538c8 Bump up version number to 1.4 v1.4 Yugo Nagata 2022-12-16 23:34:06 +0900
  • 5db54f4669
    Use exclusive lock for view maintenance caused by UPDATE or DELETE (#42) Yugo Nagata 2022-12-16 23:31:00 +0900
  • 6431dd7cb2 Use exclusive lock for view maintenance caused by UPDATE or DELETE Yugo Nagata 2022-12-16 22:47:59 +0900
  • 26f0b03b58
    Fix bugs of IVM that occur when column names are specified in aggregate views (#41) Yugo Nagata 2022-12-16 19:13:08 +0900
  • ac87b74cbd Fix bugs of IVM that occur when column names are specified in aggregate views Yugo Nagata 2022-12-16 19:01:09 +0900
  • 326720874e
    Fix a bug of automatic index creation (#40) Yugo Nagata 2022-12-16 12:42:35 +0900
  • 3ea7c0b594 Fix a bug of automatic index creation Yugo Nagata 2022-12-15 19:28:47 +0900
  • 59081de628
    Fix segmentation fault in incorrect view def (#39) thoshiai 2022-12-15 19:03:49 +0900
  • 9d51897aaa Fix to use ereport func instead of elog func Takuma Hoshiai 2022-12-15 17:26:55 +0900
  • 9ac5a2c42e Fix segmentation fault in incorrect view def Takuma Hoshiai 2022-12-15 02:16:02 +0900
  • e857213281 Allow to variable PG_CONFIG together with make command Yugo Nagata 2022-11-25 18:33:27 +0900
  • 24dc053659
    Fix not to create IMMV including other IMMV(#30) (#31) thoshiai 2022-10-18 15:51:41 +0900
  • f17710dcf8 Fix not to create IMMV icluding other IMMV(#30) Takuma Hoshiai 2022-10-18 00:44:25 +0900
  • 6eddcd2a63 Merge branch 'main' of https://github.com/sraoss/pg_ivm into main v1.3 1.3 Yugo Nagata 2022-09-30 23:57:01 +0900
  • 5e69211d7b Bump up version number to 1.3 Yugo Nagata 2022-09-30 23:56:33 +0900
  • 78b8ac2e68
    Add description of get_immv_def to README Yugo Nagata 2022-09-30 23:55:01 +0900
  • e31dc21eaa
    Use object_access_hook to drop an IMMV entry from pg_ivm_immv (#29) Yugo Nagata 2022-09-30 23:49:51 +0900
  • 405196e07e Use object_access_hook to drop an IMMV entry from pg_ivm_immv Yugo Nagata 2022-09-30 23:37:42 +0900
  • 1d21409321
    Add get_immv_def func (#23) thoshiai 2022-09-30 18:59:51 +0900
  • a556c444bd Revert NOTICE message Takuma Hoshiai 2022-09-30 17:19:58 +0900
  • b2e357612d Fix for get_immv_def() Takuma Hoshiai 2022-09-30 17:08:51 +0900
  • bd6776c7ff fix an irregular case of get_immv_def() Takuma Hoshiai 2022-09-18 06:14:19 +0900
  • 2d9abee78c Add function of get_immv_def() Takuma Hoshiai 2022-09-18 05:36:43 +0900
  • 5bd2670002 Fix NOTICE messages and result of regression test Takuma Hoshiai 2022-09-18 05:15:17 +0900
  • b6702f9a3a
    Use snapshot to check tuple visibility in pre-update state (#28) Yugo Nagata 2022-09-30 11:53:12 +0900
  • 2d210e5da6 Use snapshot to check tuple visibility in pre-update state Yugo Nagata 2022-09-29 22:34:57 +0900
  • 5f584e54c3 Fix a typo in Makefile Yugo Nagata 2022-09-30 01:22:23 +0900
  • fbbd86d825
    Prepare 1.3 (#27) Yugo Nagata 2022-09-29 23:20:41 +0900
  • cb2742d677 Prepare 1.3 Yugo Nagata 2022-09-29 23:18:30 +0900
  • 4c6016999d
    Fix to get view definition string with correct column names (#26) Yugo Nagata 2022-09-29 22:24:28 +0900