pgpool2.git / summary / log / commit / refs

commit    d92a07cd3dff679b2930424851410061c33e1d71
Author:   Tatsuo Ishii <ishii at sraoss.co.jp>
Date:     Mon Oct 12 01:54:52 2009 +0000

    REINDEX DATABASE or SYSTEM should not be executed in a transaction
    block. See [pgpool-general-jp: 623] for more details.


 pool_process_query.c | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/pool_process_query.c b/pool_process_query.c
index 0a80b04f7..d2b59b2cd 100644
--- a/pool_process_query.c
+++ b/pool_process_query.c
@@ -4237,6 +4237,16 @@ static bool is_internal_transaction_needed(Node *node)
 				return false;
 		}
 
+		/*
+		 * REINDEX DATABASE or SYSTEM cannot be executed in a transaction block
+		 */
+		else if (IsA(node, ReindexStmt))
+		{
+			if (((ReindexStmt *)node)->kind == OBJECT_DATABASE ||
+				((ReindexStmt *)node)->do_system)
+				return false;
+		}
+
 		return true;
 
 	}


[parent: 26172fa219a1]