NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitc4bc9a8

Hiroshi Inoue

committed

keep relations open until they are no longer needed.

1 parent93fcbd1 commitc4bc9a8Copy full SHA for c4bc9a8

File tree

1 file changed

-5

lines changed

src/backend/utils/adt
- ri_triggers.c

1 file changed

-5

lines changed

`‎src/backend/utils/adt/ri_triggers.c‎`

Lines changed: 9 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -6,7 +6,7 @@`
`6`	`6`	`*`
`7`	`7`	`*1999 Jan Wieck`
`8`	`8`	`*`
`9`		`- * $Header: /cvsroot/pgsql/src/backend/utils/adt/ri_triggers.c,v 1.18 2000/11/16 22:30:31 tgl Exp $`
	`9`	`+ * $Header: /cvsroot/pgsql/src/backend/utils/adt/ri_triggers.c,v 1.19 2000/11/21 04:01:09 inoue Exp $`
`10`	`10`	`*`
`11`	`11`	`* ----------`
`12`	`12`	`*/`
`@@ -247,7 +247,6 @@ RI_FKey_check(PG_FUNCTION_ARGS)`
`247`	`247`	`qplan=SPI_saveplan(qplan);`
`248`	`248`	`ri_HashPreparedPlan(&qkey,qplan);`
`249`	`249`	`}`
`250`		`-heap_close(pk_rel,NoLock);`
`251`	`250`
`252`	`251`	`/* ----------`
`253`	`252`	`* Execute the plan`
`@@ -257,6 +256,8 @@ RI_FKey_check(PG_FUNCTION_ARGS)`
`257`	`256`	`elog(NOTICE,"SPI_connect() failed in RI_FKey_check()");`
`258`	`257`
`259`	`258`	`SetUserId(RelationGetForm(pk_rel)->relowner);`
	`259`	`+/* pk_rel is no longer neede OK ? */`
	`260`	`+heap_close(pk_rel,NoLock);`
`260`	`261`
`261`	`262`	`if (SPI_execp(qplan,check_values,check_nulls,1)!=SPI_OK_SELECT)`
`262`	`263`	`elog(ERROR,"SPI_execp() failed in RI_FKey_check()");`
`@@ -353,7 +354,6 @@ RI_FKey_check(PG_FUNCTION_ARGS)`
`353`	`354`	`*/`
`354`	`355`	`break;`
`355`	`356`	`}`
`356`		`-heap_close(pk_rel,NoLock);`
`357`	`357`
`358`	`358`	`/* ----------`
`359`	`359`	`* Note:`
`@@ -445,6 +445,8 @@ RI_FKey_check(PG_FUNCTION_ARGS)`
`445`	`445`	`*/`
`446`	`446`
`447`	`447`	`SetUserId(RelationGetForm(pk_rel)->relowner);`
	`448`	`+/* pk_rel is no longer needed OK ? */`
	`449`	`+heap_close(pk_rel,NoLock);`
`448`	`450`
`449`	`451`	`if (SPI_execp(qplan,check_values,check_nulls,1)!=SPI_OK_SELECT)`
`450`	`452`	`elog(ERROR,"SPI_execp() failed in RI_FKey_check()");`
`@@ -2357,7 +2359,6 @@ RI_FKey_setdefault_del(PG_FUNCTION_ARGS)`
`2357`	`2359`	`*/`
`2358`	`2360`	`break;`
`2359`	`2361`	`}`
`2360`		`-heap_close(fk_rel,NoLock);`
`2361`	`2362`
`2362`	`2363`	`if (SPI_connect()!=SPI_OK_CONNECT)`
`2363`	`2364`	`elog(NOTICE,"SPI_connect() failed in RI_FKey_setdefault_del()");`
`@@ -2461,6 +2462,8 @@ RI_FKey_setdefault_del(PG_FUNCTION_ARGS)`
`2461`	`2462`	`}`
`2462`	`2463`	`}`
`2463`	`2464`	`}`
	`2465`	`+/* fk_rel is no longer needed OK ? */`
	`2466`	`+heap_close(fk_rel,NoLock);`
`2464`	`2467`
`2465`	`2468`	`/* ----------`
`2466`	`2469`	`* We have a plan now. Build up the arguments for SPI_execp()`
`@@ -2614,7 +2617,6 @@ RI_FKey_setdefault_upd(PG_FUNCTION_ARGS)`
`2614`	`2617`	`*/`
`2615`	`2618`	`break;`
`2616`	`2619`	`}`
`2617`		`-heap_close(fk_rel,NoLock);`
`2618`	`2620`
`2619`	`2621`	`/* ----------`
`2620`	`2622`	`* No need to do anything if old and new keys are equal`
`@@ -2743,6 +2745,8 @@ RI_FKey_setdefault_upd(PG_FUNCTION_ARGS)`
`2743`	`2745`	`}`
`2744`	`2746`	`}`
`2745`	`2747`	`}`
	`2748`	`+/* fk_rel is no longer needed OK ? */`
	`2749`	`+heap_close(fk_rel,NoLock);`
`2746`	`2750`
`2747`	`2751`	`/* ----------`
`2748`	`2752`	`* We have a plan now. Build up the arguments for SPI_execp()`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitc4bc9a8

File tree

1 file changed

1 file changed

`‎src/backend/utils/adt/ri_triggers.c‎`

0 commit comments