Commit8fed952

Artur Zakirov

committed

Fixed error: relation public.sr_plans does not exist

1 parentbbec89c commit8fed952Copy full SHA for 8fed952

File tree

+13

-2

lines changed

+13

-2

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -23,4 +23,4 @@ endif`
`23`	`23`
`24`	`24`	`genparser:`
`25`	`25`	`#test -d sr_plan_env \|\|`
`26`		-python gen_parser.py nodes.h `pg_config --includedir-server`
	`26`	+python gen_parser.py nodes.h `$(PG_CONFIG) --includedir-server`

Lines changed: 12 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -60,6 +60,7 @@ PlannedStmt sr_planner(Query parse,`
`60`	`60`	`boolfind_ok= false;`
`61`	`61`	`LOCKMODEheap_lock=AccessShareLock;`
`62`	`62`	`Oidquery_index_rel_oid;`
	`63`	`+Oidsr_plans_oid;`
`63`	`64`	`IndexScanDescquery_index_scan;`
`64`	`65`	`ScanKeyDatakey;`
`65`	`66`
`@@ -81,11 +82,21 @@ PlannedStmt sr_planner(Query parse,`
`81`	`82`	`sr_query_walker((Query*)parse,NULL);`
`82`	`83`
`83`	`84`	`sr_plans_table_rv=makeRangeVar("public","sr_plans",-1);`
`84`		`-sr_plans_heap=heap_openrv(sr_plans_table_rv,heap_lock);`
	`85`	`+/* First check existance of "sr_plans" table */`
	`86`	`+sr_plans_oid=RangeVarGetRelid(sr_plans_table_rv,heap_lock, true);`
	`87`	`+if (!OidIsValid(sr_plans_oid))`
	`88`	`+{`
	`89`	`+elog(WARNING,"Not found sr_plans table");`
	`90`	`+returnstandard_planner(parse,cursorOptions,boundParams);`
	`91`	`+}`
	`92`	`+`
	`93`	`+/* Table "sr_plans" exists */`
	`94`	`+sr_plans_heap=heap_open(sr_plans_oid,NoLock);`
`85`	`95`
`86`	`96`	`query_index_rel_oid=DatumGetObjectId(DirectFunctionCall1(to_regclass,PointerGetDatum(cstring_to_text("sr_plans_query_hash_idx"))));`
`87`	`97`	`if (query_index_rel_oid==InvalidOid)`
`88`	`98`	`{`
	`99`	`+heap_close(sr_plans_heap,heap_lock);`
`89`	`100`	`elog(WARNING,"Not found sr_plans_query_hash_idx index");`
`90`	`101`	`returnstandard_planner(parse,cursorOptions,boundParams);`
`91`	`102`	`}`

Comments

(0)