A bug in the array expression parsing causes some queries involving arrays to core dump.
Thanks to Scott Capdevielle (scott@andromedia.com) for finding the problem AND supplying the fix!
This patch also includes a RELEASE.patchlevel file that is used from now on to help maintain patch sequencing.
Apply this patch.
===================================================================
RCS file: /usr/local/devel/pglite/cvs/src/backend/parser/analyze.c,v
retrieving revision 1.38
diff -c -r1.38 analyze.c
*** 1.38 1995/08/01 20:24:20
--- src/backend/parser/analyze.c 1995/10/11 00:53:35
***************
*** 552,558 ****
if (exprType(uexpr) != INT4OID)
elog(WARN, "array index expressions must be int4's");
if (ai->lidx != NULL) {
! uexpr = transformExpr(pstate, ai->lidx);
if (exprType(lexpr) != INT4OID)
elog(WARN, "array index expressions must be int4's");
}
--- 552,558 ----
if (exprType(uexpr) != INT4OID)
elog(WARN, "array index expressions must be int4's");
if (ai->lidx != NULL) {
! lexpr = transformExpr(pstate, ai->lidx);
if (exprType(lexpr) != INT4OID)
elog(WARN, "array index expressions must be int4's");
}
*** RELEASE.patchlevel Tue Oct 10 17:56:01 1995
--- src/RELEASE.patchlevel Tue Oct 10 17:59:08 1995
***************
*** 0 ****
--- 1,9 ----
+ ## Postgres95
+ ##
+ ## This file is used to maintain sequencing of patches
+
+ version: 1.0
+ patch level: 11
+ patch date: 1995/10/10 17:59:03
+
+