提交 · 91fc80d0d35877e665b1741a6a46c46145a9aad6 · Greenplum / Gpdb

16 6月, 2006 5 次提交

Fix: · 91fc80d0

由 Bruce Momjian 提交于 6月 16, 2006

< 		  get_employee_salary(emp_id AS 12345, tax_year AS 2001)
> 		  get_employee_salary(12345 AS emp_id, 2001 AS tax_year)

91fc80d0

Update syntax suggestion: · 6241f464

由 Bruce Momjian 提交于 6月 15, 2006

< 		  get_employee_salary(emp_id => 12345, tax_year => 2001)
> 		  get_employee_salary(emp_id AS 12345, tax_year AS 2001)

6241f464

Add: · fe8c1165

由 Bruce Momjian 提交于 6月 15, 2006

>
> 		o Fix memory leak from exceptions
>
> 		  http://archives.postgresql.org/pgsql-performance/2006-06/msg00305.php

fe8c1165

Clarify dynamic pl/pgsql item and add URLs. Restructure server-side · 653fa217

由 Bruce Momjian 提交于 6月 15, 2006

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

653fa217

Add: · fce5033b

由 Bruce Momjian 提交于 6月 15, 2006

> 	o Allow PL/PgSQL RETURN to return row or record functions
>
> 	  http://archives.postgresql.org/pgsql-patches/2005-11/msg00045.php

fce5033b

15 6月, 2006 22 次提交

Done, removed: · f8cdc265

由 Bruce Momjian 提交于 6月 15, 2006

<
< * Consider padding the spinlock structure to have spinlock registers
<   on different CPU cache line
<
<   http://archives.postgresql.org/pgsql-hackers/2005-10/msg00498.php

f8cdc265

Remove, done: · a9d2cc4d

由 Bruce Momjian 提交于 6月 14, 2006

<
< * Add support for WIN1253 (Greek) encoding
<
<   http://archives.postgresql.org/pgsql-bugs/2005-12/msg00000.php

a9d2cc4d

Add: · d5ddb876

由 Bruce Momjian 提交于 6月 14, 2006

>
> * Add support for WIN1253 (Greek) encoding
>
>   http://archives.postgresql.org/pgsql-bugs/2005-12/msg00000.php

d5ddb876

B
Add URL to ILIKE encoding fix: · ca2bb275
由 Bruce Momjian 提交于 6月 14, 2006
```
>   http://archives.postgresql.org/pgsql-patches/2005-11/msg00173.php
```
ca2bb275

Add: · 8d21abd7

由 Bruce Momjian 提交于 6月 14, 2006

>
> * Consider increasing internal areas when shared buffers is increased
>
>   http://archives.postgresql.org/pgsql-hackers/2005-10/msg01419.php

8d21abd7

Already done: · cda6a5a5

由 Bruce Momjian 提交于 6月 14, 2006

<
< 	o Properly mark all libpq-exported functions with "PQ"
<
< 	  http://archives.postgresql.org/pgsql-hackers/2005-10/msg00696.php

cda6a5a5

Done by Peter: · 6894d695

由 Bruce Momjian 提交于 6月 14, 2006

< * Improve the information schema to be more standards-compliant:
<
<   http://archives.postgresql.org/pgsql-bugs/2005-10/msg00028.php

6894d695

Add: · 456a852d

由 Bruce Momjian 提交于 6月 14, 2006

>
> 	o Properly mark all libpq-exported functions with "PQ"
>
> 	  http://archives.postgresql.org/pgsql-hackers/2005-10/msg00696.php

456a852d

Add: · 2f8ea027

由 Bruce Momjian 提交于 6月 14, 2006

>
> * Consider padding the spinlock structure to have spinlock registers
>   on different CPU cache line
>
>   http://archives.postgresql.org/pgsql-hackers/2005-10/msg00498.php

2f8ea027

Add item, not fixed: · 3c8c3ccf

由 Bruce Momjian 提交于 6月 14, 2006

>
> * Fix ILIKE and regular expressions to handle case insensitivity
>   properly in multibyte encodings
>
>   http://archives.postgresql.org/pgsql-bugs/2005-10/msg00001.php

3c8c3ccf

Remove, already in back branches: · ca3d2c31

由 Bruce Momjian 提交于 6月 14, 2006

<
< 	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

ca3d2c31

B
Done: · bcc97255
由 Bruce Momjian 提交于 6月 14, 2006
```
> 	o -Port contrib/xml2
```
bcc97255

Add information schema item: · c135db1d

由 Bruce Momjian 提交于 6月 14, 2006

> * 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

c135db1d

B
Add COPY views patch URL: · 63b35a8c
由 Bruce Momjian 提交于 6月 14, 2006
```
> 	  http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php
```
63b35a8c

Add: · 74469731

由 Bruce Momjian 提交于 6月 14, 2006

>
> 	o Add API for 64-bit large object access
>
> 	  http://archives.postgresql.org/pgsql-hackers/2005-09/msg00781.php

74469731

Keep TODO.detail until item is done: · 82009572

由 Bruce Momjian 提交于 6月 14, 2006

< 	o %Allow pg_dump to use multiple -t and -n switches
> 	o %Allow pg_dump to use multiple -t and -n switches  [pg_dump]

82009572

Add URL, remove TODO.detail: · 22fd9a0f

由 Bruce Momjian 提交于 6月 14, 2006

< 	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
>

22fd9a0f

Add locale/encoding references: · 5b50ede6

由 Bruce Momjian 提交于 6月 14, 2006

<   Right now only one encoding is allowed per database.
>   Right now only one encoding is allowed per database.  [locale]
> * Add CREATE COLLATE?  [locale]

5b50ede6

Update link to TODO.detail: · 9ae8690a

由 Bruce Momjian 提交于 6月 14, 2006

< 	o Check WSACancelBlockingCall() for interrupts (win32intr)
> 	o Check WSACancelBlockingCall() for interrupts [win32intr]

9ae8690a

Add: · f944f880

由 Bruce Momjian 提交于 6月 14, 2006

> 	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

f944f880

Added: · 1e52c5eb

由 Bruce Momjian 提交于 6月 14, 2006

>
> * Add URL to more complete multi-byte regression tests
>
>   http://archives.postgresql.org/pgsql-hackers/2005-07/msg00272.php

1e52c5eb

Add entry: · b6f5676c

由 Bruce Momjian 提交于 6月 14, 2006

> * 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

b6f5676c

14 6月, 2006 1 次提交
- B
  Remove: · aa30e0e5
  由 Bruce Momjian 提交于 6月 13, 2006
```
< 	o %Add CSV output format
```
  aa30e0e5
13 6月, 2006 1 次提交
- B
  Add URL for bitmap AM: · 11a0c1de
  由 Bruce Momjian 提交于 6月 12, 2006
```
>   http://archives.postgresql.org/pgsql-patches/2005-07/msg00512.php
```
  11a0c1de
11 6月, 2006 2 次提交

Remove pg_dump wording: · 807bfa58

由 Bruce Momjian 提交于 6月 10, 2006

<   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()

807bfa58

Add: · 0d001c86

由 Bruce Momjian 提交于 6月 10, 2006

<   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

0d001c86

10 6月, 2006 2 次提交

Cleanups: · 91431449

由 Bruce Momjian 提交于 6月 09, 2006

< 	* 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?

91431449

Cleanup: · c0ba4829

由 Bruce Momjian 提交于 6月 09, 2006

< * -%Allow pooled connections to list all prepared statements
> * -Allow pooled connections to list all prepared statements

c0ba4829

09 6月, 2006 5 次提交

Add URL. · 1a1326d6

由 Bruce Momjian 提交于 6月 09, 2006

< 	  the insert.
> 	  the insert.
> 	  http://archives.postgresql.org/pgsql-patches/2005-07/msg00568.php

1a1326d6

Update: · fa23204c

由 Bruce Momjian 提交于 6月 09, 2006

< * Add SQL99 WITH RECURSIVE (hierarchical) queries to SELECT
> * Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SELECT

fa23204c

B
Remove: · 2f12903e
由 Bruce Momjian 提交于 6月 09, 2006
```
< * Rename some /contrib modules from pg* to pg_*
```
2f12903e

Add URL. · e4725e35

由 Bruce Momjian 提交于 6月 08, 2006

>
>   http://archives.postgresql.org/pgsql-patches/2006-06/msg00096.php
>

e4725e35

Use simple URL's rather than text and a URL: · 51aa05a4

由 Bruce Momjian 提交于 6月 08, 2006

< 	    recovery.  See http://archives.postgresql.org/pgsql-patches/2005-04/msg00121.php.
> 	    recovery.
> 	    http://archives.postgresql.org/pgsql-patches/2005-04/msg00121.php
<   Right now only one encoding is allowed per database.  For a partial
<   patch, see http://archives.postgresql.org/pgsql-hackers/2005-03/msg00932.php.
>   Right now only one encoding is allowed per database.
>   http://archives.postgresql.org/pgsql-hackers/2005-03/msg00932.php
459c460
<   notify the protocol when a RESET CONNECTION command is used.  See
>   notify the protocol when a RESET CONNECTION command is used.
461d461
<   for a partial implementation.
515c515
< 	  See http://archives.postgresql.org/pgsql-patches/2006-02/msg00168.php.
> 	  http://archives.postgresql.org/pgsql-patches/2006-02/msg00168.php
535c535
< 	  See http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php.
> 	  http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php
821c821
<   See http://archives.postgresql.org/pgsql-patches/2005-07/msg00107.php.
>   http://archives.postgresql.org/pgsql-patches/2005-07/msg00107.php
877c877
<   Details at http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php.
>   http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php
<   See partially completed patch and additional work required at
<   http://archives.postgresql.org/pgsql-patches/2006-06/msg00025.php.
>   http://archives.postgresql.org/pgsql-patches/2006-06/msg00025.php
1297c1296
<   See http://archives.postgresql.org/pgsql-patches/2006-05/msg00040.php.
>   http://archives.postgresql.org/pgsql-patches/2006-05/msg00040.php
1311c1310,1311
< 	o Improve signal handling,
> 	o Improve signal handling
>
1312a1313
>

51aa05a4

08 6月, 2006 2 次提交

Add URL. · 2b5b4760

由 Bruce Momjian 提交于 6月 08, 2006

< * Support triggers on columns (Greg Sabino Mullane)
> * Support triggers on columns
>
>   See http://archives.postgresql.org/pgsql-patches/2005-07/msg00107.php.
>

2b5b4760

Done: · 4369b0b5

由 Bruce Momjian 提交于 6月 08, 2006

> * -Allow server logs to be remotely read and removed using SQL commands

4369b0b5