|The PostgreSQL 9.0 Reference Manual - Volume 2 - Programming Guide
by The PostgreSQL Global Development Group
Paperback (6"x9"), 478 pages
RRP £14.95 ($19.95)
Sales of this book support the PostgreSQL project! Get a printed copy>>>
11.7.2 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.
- 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.
When a session ends normally, not due to a fatal error, any
ENDblocks that have been defined are executed. Currently no other actions are performed. Specifically, file handles are not automatically flushed and objects are not automatically destroyed.
|ISBN 9781906966065||The PostgreSQL 9.0 Reference Manual - Volume 2 - Programming Guide||See the print edition|