Re: Remove support in ri_triggers.c for zero-column foreign keys? - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Remove support in ri_triggers.c for zero-column foreign keys?
Date
Msg-id 201206202324.14994.andres@2ndquadrant.com
Whole thread Raw
In response to Remove support in ri_triggers.c for zero-column foreign keys?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Remove support in ri_triggers.c for zero-column foreign keys?
List pgsql-hackers
On Wednesday, June 20, 2012 11:15:44 PM Tom Lane wrote:
> There is a nontrivial amount of code in ri_triggers.c that is concerned
> with supporting foreign key constraints having zero columns.  ...
> 
> I think we should rip all that code out and instead put one test into
> ri_FetchConstraintInfo insisting that the number of keys be > 0.
+1. I really find that a strange concept and I have a hard time finding useful 
use-cases.

Thanks for improving that code btw, I tried to read/patch it before and its 
not exactly accessible...

Andres

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Remove support in ri_triggers.c for zero-column foreign keys?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Remove support in ri_triggers.c for zero-column foreign keys?