moving aggregate bad error message - Mailing list pgsql-hackers

From Jeff Janes
Subject moving aggregate bad error message
Date
Msg-id CAMkU=1x808LH=LPhZp9mNSP0Xd1xDqEd+XeGcvEe48dfE6xV=A@mail.gmail.com
Whole thread Raw
Responses Re: moving aggregate bad error message  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I was wondering if I could just add minvfunc, and have the rest of the m* functions be assumed to be the same as their non-moving counterparts.  Apparently the answer is 'no'.  But in the process, I found a bad error message.  When omitting mfinalfunc when there is a finalfunc, I get the error:

"ERROR:  moving-aggregate implementation returns type jj_state, but plain implementation returns type jj_state."  A rather peculiar complaint, analogous to the infamous "something failed: Success".

Looking at the code, it seems we are testing rettype != finaltype, but reporting aggmTransType and aggTransType.  Why aren't we reporting what we are testing?

With the attached patch, it gives the more sensible "ERROR:  moving-aggregate implementation returns type jj_state, but plain implementation returns type numeric."

Cheers,

Jeff
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dubious code in pg_rewind's process_target_file()
Next
From: Tom Lane
Date:
Subject: Re: moving aggregate bad error message