Re: [PATCH] Support for foreign keys with arrays - Mailing list pgsql-hackers

(I reply to an older message but I did use the newest patch, version 3)

I wanted to have a look at v3 of this patch today, but it seems it won't apply and compile anymore.


Here are the protestations of patch:

patching file src/include/catalog/pg_proc.h
Hunk #1 FAILED at 868.
Hunk #2 FAILED at 1985.
2 out of 2 hunks FAILED -- saving rejects to file src/include/catalog/pg_proc.h.rej


and in case it's any use, a cat of src/include/catalog/pg_proc.h.rej:


***************
*** 868,873 **** DATA(insert OID = 2335 (  array_agg           PGNSP PGUID 12 1 0 0 0 t f f f f i 1 0 2277 "2283"
_null_ _null_ _null_ _null_ aggregate_dummy _null_ _null_ _null_ )); DESCR("concatenate aggregate input into an
array");
 DATA(insert OID = 760 (  smgrin               PGNSP PGUID 12 1 0 0 0 f f f t f s 1 0 210 "2275" _null_
_null_ _null_ _null_    smgrin _null_ _null_ _null_ )); DESCR("I/O"); DATA(insert OID = 761 (  smgrout           PGNSP
PGUID12 1 0 0 0 f f f t f s 1 0 2275 "210" _null_
 
_null_ _null_ _null_    smgrout _null_ _null_ _null_ ));
--- 868,878 ---- DATA(insert OID = 2335 (  array_agg           PGNSP PGUID 12 1 0 0 0 t f f f f i 1 0 2277 "2283"
_null_ _null_ _null_ _null_ aggregate_dummy _null_ _null_ _null_ )); DESCR("concatenate aggregate input into an
array");

+ DATA(insert OID = 3157 (  array_remove       PGNSP PGUID 12 1 0 0 0 f f f f f i 2 0 2277 "2277
2283" _null_ _null_ _null_ _null_ array_remove _null_ _null_ _null_ ));
+ DESCR("remove any occurrence of an element from an array");
+ DATA(insert OID = 3158 (  array_replace       PGNSP PGUID 12 1 0 0 0 f f f f f i 3 0 2277 "2277
2283 2283" _null_ _null_ _null_ _null_ array_replace _null_ _null_ _null_ ));
+ DESCR("replace any occurrence of an element in an array");
+ DATA(insert OID = 760 (  smgrin               PGNSP PGUID 12 1 0 0 0 f f f t f s 1 0 210 "2275" _null_
_null_ _null_ _null_    smgrin _null_ _null_ _null_ )); DESCR("I/O"); DATA(insert OID = 761 (  smgrout           PGNSP
PGUID12 1 0 0 0 f f f t f s 1 0 2275 "210" _null_
 
_null_ _null_ _null_    smgrout _null_ _null_ _null_ ));
***************
*** 1980,1985 **** DATA(insert OID = 1655 (  RI_FKey_noaction_upd PGNSP PGUID 12 1 0 0 0 f f f t f v 0 0 2279 ""
_null_ _null_ _null_ _null_ RI_FKey_noaction_upd _null_ _null_ _null_ )); DESCR("referential integrity ON UPDATE NO
ACTION");
 DATA(insert OID = 1666 (  varbiteq            PGNSP PGUID 12 1 0 0 0 f f f t f i 2 0 16 "1562 1562"
_null_ _null_ _null_ _null_ biteq _null_ _null_ _null_ )); DATA(insert OID = 1667 (  varbitne            PGNSP PGUID 12
10 0 0 f f f t f i 2 0 16 "1562 1562"
 
_null_ _null_ _null_ _null_ bitne _null_ _null_ _null_ )); DATA(insert OID = 1668 (  varbitge            PGNSP PGUID 12
10 0 0 f f f t f i 2 0 16 "1562 1562"
 
_null_ _null_ _null_ _null_ bitge _null_ _null_ _null_ ));
--- 1985,1999 ---- DATA(insert OID = 1655 (  RI_FKey_noaction_upd PGNSP PGUID 12 1 0 0 0 f f f t f v 0 0 2279 ""
_null_ _null_ _null_ _null_ RI_FKey_noaction_upd _null_ _null_ _null_ )); DESCR("referential integrity ON UPDATE NO
ACTION");

+ DATA(insert OID = 3159 (  RI_FKey_eachcascade_del    PGNSP PGUID 12 1 0 0 0 f f f t f v 0 0 2279 ""
_null_ _null_ _null_ _null_ RI_FKey_eachcascade_del _null_ _null_ _null_ ));
+ DESCR("referential integrity ON DELETE EACH CASCADE");
+ DATA(insert OID = 3160 (  RI_FKey_eachcascade_upd    PGNSP PGUID 12 1 0 0 0 f f f t f v 0 0 2279 ""
_null_ _null_ _null_ _null_ RI_FKey_eachcascade_upd _null_ _null_ _null_ ));
+ DESCR("referential integrity ON UPDATE EACH CASCADE");
+ DATA(insert OID = 3161 (  RI_FKey_eachsetnull_del    PGNSP PGUID 12 1 0 0 0 f f f t f v 0 0 2279 ""
_null_ _null_ _null_ _null_ RI_FKey_eachsetnull_del _null_ _null_ _null_ ));
+ DESCR("referential integrity ON DELETE EACH SET NULL");
+ DATA(insert OID = 3162 (  RI_FKey_eachsetnull_upd    PGNSP PGUID 12 1 0 0 0 f f f t f v 0 0 2279 ""
_null_ _null_ _null_ _null_ RI_FKey_eachsetnull_upd _null_ _null_ _null_ ));
+ DESCR("referential integrity ON UPDATE EACH SET NULL");
+ DATA(insert OID = 1666 (  varbiteq            PGNSP PGUID 12 1 0 0 0 f f f t f i 2 0 16 "1562 1562"
_null_ _null_ _null_ _null_ biteq _null_ _null_ _null_ )); DATA(insert OID = 1667 (  varbitne            PGNSP PGUID 12
10 0 0 f f f t f i 2 0 16 "1562 1562"
 
_null_ _null_ _null_ _null_ bitne _null_ _null_ _null_ )); DATA(insert OID = 1668 (  varbitge            PGNSP PGUID 12
10 0 0 f f f t f i 2 0 16 "1562 1562"
 
_null_ _null_ _null_ _null_ bitge _null_ _null_ _null_ ));



I'd like to try this out a bit; could you see if you can fix it?

thanks,

Erik Rijkers