Re: empty array can crash backend using int_array_enum from contrib. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: empty array can crash backend using int_array_enum from contrib.
Date
Msg-id 11932.1114279018@sss.pgh.pa.us
Whole thread Raw
In response to Re: empty array can crash backend using int_array_enum from contrib.  (Andrew - Supernews <andrew+nonews@supernews.com>)
List pgsql-bugs
Andrew - Supernews <andrew+nonews@supernews.com> writes:
> We were discussing this one on irc while it was presumably waiting in the
> moderation queue, and I suggested to the poster an alternative patch that
> allowed empty arrays to actually be treated as empty (your version will
> error out on int_array_enum('{}') rather than producing 0 rows, which seems
> unhelpful).

Done, but not back-patched since this seems more in the nature of a new
feature than a crash preventative.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: V2 protocol -> 8.1 server
Next
From: Tom Lane
Date:
Subject: Re: BUG #1608: integer negative limit in plpgsql function arguments