From ec497a5ad6a0849efa3fb2fd05988bd8e0c0865d Mon Sep 17 00:00:00 2001 From: Simon Riggs Date: Tue, 22 Mar 2011 23:10:35 +0000 Subject: Make FKs valid at creation when added as column constraints. Bug report from Alvaro Herrera --- src/backend/commands/tablecmds.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/backend/commands/tablecmds.c') diff --git a/src/backend/commands/tablecmds.c b/src/backend/commands/tablecmds.c index f677a8e8bd0..596cd864017 100644 --- a/src/backend/commands/tablecmds.c +++ b/src/backend/commands/tablecmds.c @@ -5595,7 +5595,7 @@ ATAddForeignKeyConstraint(AlteredTableInfo *tab, Relation rel, CONSTRAINT_FOREIGN, fkconstraint->deferrable, fkconstraint->initdeferred, - !fkconstraint->skip_validation, + fkconstraint->initially_valid, RelationGetRelid(rel), fkattnum, numfks, -- cgit v1.2.3