Re: Crosstab Problems - Mailing list pgsql-general

From Joe Conway
Subject Re: Crosstab Problems
Date
Msg-id 4717A807.1030209@joeconway.com
Whole thread Raw
In response to Re: Crosstab Problems  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Crosstab Problems  (Jorge Godoy <jgodoy@gmail.com>)
List pgsql-general
Tom Lane wrote:
> so it's trying to pstrdup a null result from SPI_getvalue.
>
> Obviously it shouldn't crash, but I'm not sure what it *should* do in
> this case.  Joe?

The row is pretty useless without a rowid in this context -- it seems
like the best thing to do would be to skip those rows entirely. Of
course you could argue I suppose that it ought to throw an ERROR and
bail out entirely. Maybe a good compromise would be to skip the row but
throw a NOTICE?

Joe


pgsql-general by date:

Previous
From: Lothar Behrens
Date:
Subject: Re: Am I overseen ?
Next
From: Steve Crawford
Date:
Subject: Abbreviation list