|PostgreSQL Reference Manual - Volume 2 - Programming Guide|
by The PostgreSQL Global Development Group
Paperback (6"x9"), 408 pages
RRP £19.95 ($34.95)
Sales of this book support the PostgreSQL project! Get a printed copy>>>
11.7 Limitations and Missing Features
The following features are currently missing from PL/Perl, but they would make welcome contributions.
- PL/Perl functions cannot call each other directly (because they are anonymous subroutines inside Perl).
- SPI is not yet fully implemented.
If you are fetching very large data sets using
spi_exec_query, you should be aware that these will all go into memory. You can avoid this by using
spi_fetchrowas illustrated earlier. A similar problem occurs if a set-returning function passes a large set of rows back to PostgreSQL via
return. You can avoid this problem too by instead using
return_nextfor each row returned, as shown previously.
|ISBN 0954612035||PostgreSQL Reference Manual - Volume 2 - Programming Guide||See the print edition|