Skip site navigation (1) Skip section navigation (2)

PL/php 1.1 released

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: pgsql-announce(at)postgresql(dot)org
Subject: PL/php 1.1 released
Date: 2005-12-05 17:46:43
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-announce
I'm pleased to announce the release of PL/php version 1.1, the PHP
procedural language for PostgreSQL.

What's in the 1.1 release:

- The build system no longer requires the PHP nor PostgreSQL sources.
  It uses PGXS, making it all much easier to build compared to the
  original 1.0 release.

- Rudimentary SPI support, meaning you can send queries to the server
  and get/process the results.

- Trigger support: you can write trigger functions, including the
  ability to abort or skip an operation, or modifying the tuple before

- Function validation: PL/php will tell you right away if the function
  you are creating has a syntax error, and abort the creation, so no
  invalid functions make it into the database.

- You will receive any errors and warnings that PHP generates while
  executing your function.

PL/php 1.1 only works with PostgreSQL 8.0 and 8.1.  It has been tested
with PHP 4.4.1 only, but it should work with PHP 5 as well.

PL/php 1.1 can be downloaded from the Trac page.  The documentation
lives there as well, as a Wiki.

Differences from the original 1.0 release include:

- Error messages and warnings are passed from PHP to Postgres instead of
  being silently dropped.
- No more memory leaks in SPI functions.
- SPI results are now an opaque PHP resource, so it's no longer possible
  to crash the server by modifying it.
- Memory handling has been overhauled.  There are no known memory leaks.
  Huge SPI results can be processed.
- SRF support has been removed.  It will be added again in the next
  release.  The previous version was found to be too buggy and poorly
- A private symbol table is created for each function, which facilitates
  the process of releasing memory used by the function.  This symbol
  table is cleared after each call.

For a quick glance of (to? into?) our release plan, please have a look
at the Roadmap in our Trac page:

Please report any issues as a Ticket in the Trac page:

Expect a 1.2 release shortly, which will include SRF support.

Alvaro Herrera                      
"I'm always right, but sometimes I'm more right than other times."
                                                  (Linus Torvalds)

pgsql-announce by date

Next:From: Greg Sabino MullaneDate: 2005-12-09 13:01:54
Subject: GnuPG / PGP signed MD5 and SHA1 checksums for PostgreSQL 8.1.0
Previous:From: Tim AllenDate: 2005-12-05 10:18:35
Subject: Re: [ANNOUNCE] == PostgreSQL Weekly News - December 05 2005 ==

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group