summaryrefslogtreecommitdiff
path: root/src/pl/plpython/expected/plpython_trigger.out
Commit message (Collapse)AuthorAgeFilesLines
* Table function support for PL/PythonPeter Eisentraut2011-02-261-0/+18
| | | | | | | This allows functions with multiple OUT parameters returning both one or multiple records (RECORD or SETOF RECORD). Jan UrbaƄski, reviewed by Hitoshi Harada
* Remove useless whitespace at end of linesPeter Eisentraut2010-11-231-1/+1
|
* Fix plpython so that it again honors typmod while assigning to tuple fields.Tom Lane2010-10-111-0/+26
| | | | | This was broken in 9.0 while improving plpython's conversion behavior for bytea and boolean. Per bug report from maizi.
* Support triggers on views.Tom Lane2010-10-101-4/+74
| | | | | | | | | | | | | | | This patch adds the SQL-standard concept of an INSTEAD OF trigger, which is fired instead of performing a physical insert/update/delete. The trigger function is passed the entire old and/or new rows of the view, and must figure out what to do to the underlying tables to implement the update. So this feature can be used to implement updatable views using trigger programming style rather than rule hacking. In passing, this patch corrects the names of some columns in the information_schema.triggers view. It seems the SQL committee renamed them somewhere between SQL:99 and SQL:2003. Dean Rasheed, reviewed by Bernd Helmle; some additional hacking by me.
* Python 3 support in PL/PythonPeter Eisentraut2009-12-151-1/+1
| | | | | | Behaves more or less unchanged compared to Python 2, but the new language variant is called plpython3u. Documentation describing the naming scheme is included.
* Improve PL/Python elog outputPeter Eisentraut2009-11-031-100/+100
| | | | | When the elog functions (plpy.info etc.) get a single argument, just print that argument instead of printing the single-member tuple like ('foo',).
* Add Unicode support in PL/PythonPeter Eisentraut2009-09-121-0/+27
| | | | | | | | | | | | PL/Python now accepts Unicode objects where it previously only accepted string objects (for example, as return value). Unicode objects are converted to the PostgreSQL server encoding as necessary. This change is also necessary for future Python 3 support, which treats all strings as Unicode objects. Since this removes the error conditions that the plpython_unicode test file tested for, the alternative result files are no longer necessary.
* Enhanced error context support in PL/PythonPeter Eisentraut2009-08-251-4/+8
| | | | | | | Extract the "while creating return value" and "while modifying trigger row" parts of some error messages into another layer of error context. This will simplify the upcoming patch to improve data type support, but it can stand on its own.
* Make PL/Python tests more compatible with Python 3Peter Eisentraut2009-08-241-2/+2
| | | | | | This changes a bunch of incidentially used constructs in the PL/Python regression tests to equivalent constructs in cases where Python 3 no longer supports the old syntax. Support for older Python versions is unchanged.
* Augment test coverage in PL/Python, especially for error conditions.Peter Eisentraut2009-08-131-8/+279
|
* Split the plpython regression test into test cases arranged by topic, insteadPeter Eisentraut2009-08-121-0/+153
of the previous monolithic setup-create-run sequence, that was apparently inherited from a previous test infrastructure, but makes working with the tests and adding new ones weird.