Re: [HACKERS] Tablefunc crosstab error messages

2012-10-03 Thread Noah Misch
On Mon, Aug 27, 2012 at 08:07:02PM -0400, Mali Akmanalp wrote: > Returning the type information to the caller seems like a pain > but compatCrosstabTupleDescs already has instances in it where it fails > with an error message, so I propose we just do that and tell the user the > expected and actual

[HACKERS] Tablefunc crosstab error messages

2012-08-27 Thread Mali Akmanalp
Hi All, I was recently struggling with getting a large crosstab ( http://www.postgresql.org/docs/current/static/tablefunc.html) query to work and noticed the error messages were not super helpful: "return and sql tuple descriptions are incompatible". I had to manually take the query into pieces a