Commit582ec17

Jan Wieck

authored and

Jan Wieck

committed

Small bugfix for DROP TABLE if table is self-referenced by

a FOREIGN KEY constraint.Jan

1 parent7932f86 commit582ec17Copy full SHA for 582ec17

File tree

-1

lines changed

-1

lines changed

Lines changed: 9 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`* Portions Copyright (c) 1994, Regents of the University of California`
`8`	`8`	`*`
`9`	`9`	`* IDENTIFICATION`
`10`		`- * $Header: /cvsroot/pgsql/src/backend/commands/trigger.c,v 1.57 2000/02/0418:49:31 wieck Exp $`
	`10`	`+ * $Header: /cvsroot/pgsql/src/backend/commands/trigger.c,v 1.58 2000/02/0423:45:04 wieck Exp $`
`11`	`11`	`*`
`12`	`12`	`*-------------------------------------------------------------------------`
`13`	`13`	`*/`
`@@ -372,6 +372,13 @@ RelationRemoveTriggers(Relation rel)`
`372`	`372`
`373`	`373`	`heap_endscan(tgscan);`
`374`	`374`
	`375`	`+/* ----------`
	`376`	`+ * Need to bump it here so the following doesn't see`
	`377`	`+ * the already deleted triggers again for a self-referencing`
	`378`	`+ * table.`
	`379`	`+ * ----------`
	`380`	`+ */`
	`381`	`+CommandCounterIncrement();`
`375`	`382`
`376`	`383`	`/* ----------`
`377`	`384`	`* Also drop all constraint triggers referencing this relation`
`@@ -388,6 +395,7 @@ RelationRemoveTriggers(Relation rel)`
`388`	`395`	`DropTrigStmtstmt;`
`389`	`396`
`390`	`397`	`pg_trigger= (Form_pg_trigger)GETSTRUCT(tup);`
	`398`	`+`
`391`	`399`	`refrel=heap_open(pg_trigger->tgrelid,NoLock);`
`392`	`400`
`393`	`401`	`stmt.relname=pstrdup(RelationGetRelationName(refrel));`

Comments

(0)