Age | Commit message (Collapse) | Author |
|
> * Add support for public SYNONYMS
>
> http://archives.postgresql.org/pgsql-hackers/2006-03/msg00519.php
|
|
>
> http://archives.postgresql.org/pgsql-patches/2006-02/msg00288.php
|
|
> o Fix problems with RETURN NEXT on tables with
> dropped/added columns after function creation
>
> http://archives.postgresql.org/pgsql-patches/2006-02/msg00165.php
|
|
> * Allow protocol-level BIND parameter values to be logged
>
> http://archives.postgresql.org/pgsql-hackers/2006-02/msg00165.php
|
|
>
> http://archives.postgresql.org/pgsql-hackers/2006-01/msg00250.php
>
|
|
Magnus Hagander
|
|
|
|
< get_employee_salary(emp_id AS 12345, tax_year AS 2001)
> get_employee_salary(12345 AS emp_id, 2001 AS tax_year)
|
|
|
|
less than one row is returned by the SELECT, for Oracle PL/SQL
compatibility.
Improve SELECT INTO documentation.
Matt Miller
|
|
|
|
non-PostgreSQL libraries cannot be loaded using this capability.
|
|
< get_employee_salary(emp_id => 12345, tax_year => 2001)
> get_employee_salary(emp_id AS 12345, tax_year AS 2001)
|
|
description.
Nis Jorgensen
|
|
>
> o Fix memory leak from exceptions
>
> http://archives.postgresql.org/pgsql-performance/2006-06/msg00305.php
|
|
section into PL/pgSQL and non-PL/pgSQL sections:
< o Fix PL/pgSQL RENAME to work on variables other than OLD/NEW
< o Allow function parameters to be passed by name,
< get_employee_salary(emp_id => 12345, tax_year => 2001)
< o Add Oracle-style packages
< o Add table function support to pltcl, plpython
< o Add capability to create and call PROCEDURES
< o Allow PL/pgSQL to handle %TYPE arrays, e.g. tab.col%TYPE[]
< o Allow function argument names to be statements from PL/PgSQL
< o Add MOVE to PL/pgSQL
< o Add support for polymorphic arguments and return types to
< languages other than PL/PgSQL
< o Add support for OUT and INOUT parameters to languages other
< than PL/PgSQL
< o Add single-step debugging of PL/PgSQL functions
< o Allow PL/PgSQL to support WITH HOLD cursors
< o Allow PL/PgSQL RETURN to return row or record functions
<
< http://archives.postgresql.org/pgsql-patches/2005-11/msg00045.php
> o PL/pgSQL
> o Fix RENAME to work on variables other than OLD/NEW
> o Allow function parameters to be passed by name,
> get_employee_salary(emp_id => 12345, tax_year => 2001)
> o Add Oracle-style packages
> o Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]
> o Allow listing of record column names, and access to
> record columns via variables, e.g. columns := r.(*),
> tval2 := r.(colname)
>
> http://archives.postgresql.org/pgsql-patches/2005-07/msg00458.php
> http://archives.postgresql.org/pgsql-patches/2006-05/msg00302.php
> http://archives.postgresql.org/pgsql-patches/2006-06/msg00031.php
>
> o Add MOVE
> o Add single-step debugging of functions
> o Add support for WITH HOLD cursors
> o Allow PL/RETURN to return row or record functions
>
> http://archives.postgresql.org/pgsql-patches/2005-11/msg00045.php
>
>
> o Other
> o Add table function support to pltcl, plpython
> o Add support for polymorphic arguments and return types to
> languages other than PL/PgSQL
> o Add capability to create and call PROCEDURES
> o Add support for OUT and INOUT parameters to languages other
> than PL/PgSQL
|
|
> o Allow PL/PgSQL RETURN to return row or record functions
>
> http://archives.postgresql.org/pgsql-patches/2005-11/msg00045.php
|
|
<
< * Consider padding the spinlock structure to have spinlock registers
< on different CPU cache line
<
< http://archives.postgresql.org/pgsql-hackers/2005-10/msg00498.php
|
|
<
< * Add support for WIN1253 (Greek) encoding
<
< http://archives.postgresql.org/pgsql-bugs/2005-12/msg00000.php
|
|
>
> * Add support for WIN1253 (Greek) encoding
>
> http://archives.postgresql.org/pgsql-bugs/2005-12/msg00000.php
|
|
> http://archives.postgresql.org/pgsql-patches/2005-11/msg00173.php
|
|
>
> * Consider increasing internal areas when shared buffers is increased
>
> http://archives.postgresql.org/pgsql-hackers/2005-10/msg01419.php
|
|
<
< o Properly mark all libpq-exported functions with "PQ"
<
< http://archives.postgresql.org/pgsql-hackers/2005-10/msg00696.php
|
|
< * Improve the information schema to be more standards-compliant:
<
< http://archives.postgresql.org/pgsql-bugs/2005-10/msg00028.php
|
|
>
> o Properly mark all libpq-exported functions with "PQ"
>
> http://archives.postgresql.org/pgsql-hackers/2005-10/msg00696.php
|
|
>
> * Consider padding the spinlock structure to have spinlock registers
> on different CPU cache line
>
> http://archives.postgresql.org/pgsql-hackers/2005-10/msg00498.php
|
|
>
> * Fix ILIKE and regular expressions to handle case insensitivity
> properly in multibyte encodings
>
> http://archives.postgresql.org/pgsql-bugs/2005-10/msg00001.php
|
|
<
< o Add new version of PQescapeString() that doesn't double backslashes
< that are part of a client-only multibyte sequence
<
< Single-quote is not a valid byte in any supported client-only
< encoding. This requires using mblen() to determine if the
< backslash is inside or outside a multi-byte sequence.
<
< o Add new version of PQescapeString() that doesn't double
< backslashes when standard_conforming_strings is true and
< non-E strings are used
|
|
> o -Port contrib/xml2
|
|
> * Improve the information schema to be more standards-compliant:
>
> http://archives.postgresql.org/pgsql-bugs/2005-10/msg00028.php
> * Add URL to more complete multi-byte regression tests
>
> http://archives.postgresql.org/pgsql-hackers/2005-07/msg00272.php
< * Add URL to more complete multi-byte regression tests
<
< http://archives.postgresql.org/pgsql-hackers/2005-07/msg00272.php
|
|
> http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php
|
|
>
> o Add API for 64-bit large object access
>
> http://archives.postgresql.org/pgsql-hackers/2005-09/msg00781.php
|
|
< o %Allow pg_dump to use multiple -t and -n switches
> o %Allow pg_dump to use multiple -t and -n switches [pg_dump]
|
|
< o %Allow pg_dump to use multiple -t and -n switches [pg_dump]
> o %Allow pg_dump to use multiple -t and -n switches
>
> http://archives.postgresql.org/pgsql-patches/2006-01/msg00190.php
>
|
|
< Right now only one encoding is allowed per database.
> Right now only one encoding is allowed per database. [locale]
> * Add CREATE COLLATE? [locale]
|
|
< o Check WSACancelBlockingCall() for interrupts (win32intr)
> o Check WSACancelBlockingCall() for interrupts [win32intr]
|
|
> o Fix problem when cascading referential triggers make changes on
> cascaded tables, seeing the tables in an intermediate state
>
> http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php
> http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php
|
|
>
> * Add URL to more complete multi-byte regression tests
>
> http://archives.postgresql.org/pgsql-hackers/2005-07/msg00272.php
|
|
> * Allow user-defined types to accept 'typmod' parameters
> http://archives.postgresql.org/pgsql-hackers/2005-08/msg01142.php
> http://archives.postgresql.org/pgsql-hackers/2005-09/msg00012.php
|
|
< o %Add CSV output format
|
|
Jaime Casanova
|
|
> http://archives.postgresql.org/pgsql-patches/2005-07/msg00512.php
|
|
< pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef(), and
< make use of them in pg_dump
> pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef()
|
|
< pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef()
> pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef(), and
> make use of them in pg_dump
|
|
< * Allow a database in tablespace t1 with tables created in
> o Allow a database in tablespace t1 with tables created in
125c125
< * Allow reporting of which objects are in which tablespaces
> o Allow reporting of which objects are in which tablespaces
593c593
< * Allow GRANT/REVOKE permissions to be inherited by objects based on
> o Allow GRANT/REVOKE permissions to be inherited by objects based on
596c596
< * Allow SERIAL sequences to inherit permissions from the base table?
> o Allow SERIAL sequences to inherit permissions from the base table?
|
|
< * -%Allow pooled connections to list all prepared statements
> * -Allow pooled connections to list all prepared statements
|
|
< the insert.
> the insert.
> http://archives.postgresql.org/pgsql-patches/2005-07/msg00568.php
|
|
< * Add SQL99 WITH RECURSIVE (hierarchical) queries to SELECT
> * Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SELECT
|
|
< * Rename some /contrib modules from pg* to pg_*
|
|
>
> http://archives.postgresql.org/pgsql-patches/2006-06/msg00096.php
>
|