Re: insert rule doesn't see id field - Mailing list pgsql-sql

From Tom Lane
Subject Re: insert rule doesn't see id field
Date
Msg-id 27958.1042174422@sss.pgh.pa.us
Whole thread Raw
In response to Re: insert rule doesn't see id field  (Ron Peterson <rpeterso@mtholyoke.edu>)
Responses Re: insert rule doesn't see id field  (Ron Peterson <rpeterso@mtholyoke.edu>)
List pgsql-sql
Ron Peterson <rpeterso@mtholyoke.edu> writes:
> On Thu, Jan 09, 2003 at 04:50:56PM -0500, Ron Peterson wrote:
>> colindices = (int *) malloc (ncols * sizeof (int));

> Of course we should verify that malloc succeeded...

Actually, the correct answer is "you should not be using malloc() in
backend functions".  You should be using palloc, or possibly
MemoryContextAlloc, either of which will elog if it can't get space.

> if (colindices == NULL) {
>     elog (ERROR, "noupcol: malloc failed\n");
>     SPI_finish();
>     return PointerGetDatum (NULL);
> }

This is even more pointless.  Control does not return from elog(ERROR),
so the two following lines are dead code.
        regards, tom lane


pgsql-sql by date:

Previous
From: Ron Peterson
Date:
Subject: Re: insert rule doesn't see id field
Next
From: Chad L
Date:
Subject: Table Design Questions