Commits · 57ffc4d78b751c3d85ff869ad66c5a5c9d5ec967 · Abuhujair Javed / Postgres FD Implementation

16 Jun, 2006 1 commit
- Update magic block wording for preloaded libraries. · 57ffc4d7
  Bruce Momjian authored Jun 16, 2006
  
  57ffc4d7
15 Jun, 2006 11 commits

Use posix_fadvise() to avoid kernel caching of WAL contents on WAL file · 94a5c4a0
Bruce Momjian authored Jun 15, 2006
```
close.

ITAGAKI Takahiro
```
94a5c4a0

Add STRICT to PL/pgSQL SELECT INTO, so exceptions are thrown if more or · a584c124

Bruce Momjian authored Jun 15, 2006

less than one row is returned by the SELECT, for Oracle PL/SQL
compatibility.

Improve SELECT INTO documentation.

Matt Miller

a584c124

Fix to_ascii() markup error. · eb5558bc
Bruce Momjian authored Jun 15, 2006

eb5558bc
Add mention that preload_libraries check the magic block, so · 167c7bb4
Bruce Momjian authored Jun 15, 2006
```
non-PostgreSQL libraries cannot be loaded using this capability.
```
167c7bb4

Update syntax suggestion: · 6241f464

Bruce Momjian authored Jun 15, 2006

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

6241f464

Move list of supported to_ascii() encodings from footnote to main · 712e824f
Bruce Momjian authored Jun 15, 2006
```
description.

Nis Jorgensen
```
712e824f

Add: · fe8c1165

Bruce Momjian authored Jun 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 authored Jun 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 authored Jun 15, 2006

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

fce5033b

Done, removed: · f8cdc265

Bruce Momjian authored Jun 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 the limit on the number of entries allowed in catcaches, and · 8b9bc234

Tom Lane authored Jun 15, 2006

remove the infrastructure needed to enforce the limit, ie, the global
LRU list of cache entries. On small-to-middling databases this wins
because maintaining the LRU list is a waste of time. On large databases
this wins because it's better to keep more cache entries (we assume
such users can afford to use some more per-backend memory than was
contemplated in the Berkeley-era catcache design). This provides a
noticeable improvement in the speed of psql \d on a 10000-table
database, though it doesn't make it instantaneous.

While at it, use per-catcache settings for the number of hash buckets
per catcache, rather than the former one-size-fits-all value. It's a
bit silly to be using the same number of hash buckets for, eg, pg_am
and pg_attribute. The specific values I used might need some tuning,
but they seem to be in the right ballpark based on CATCACHE_STATS
results from the standard regression tests.

8b9bc234

14 Jun, 2006 27 commits

Add to locale TODO.detail. · e1e133f2
Bruce Momjian authored Jun 14, 2006

e1e133f2

Remove, done: · a9d2cc4d

Bruce Momjian authored Jun 14, 2006

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

a9d2cc4d

Add: · d5ddb876

Bruce Momjian authored Jun 14, 2006

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

d5ddb876

Add URL to ILIKE encoding fix: · ca2bb275
Bruce Momjian authored Jun 14, 2006
```
>   http://archives.postgresql.org/pgsql-patches/2005-11/msg00173.php
```
ca2bb275

Add: · 8d21abd7

Bruce Momjian authored Jun 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 authored Jun 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 authored Jun 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 authored Jun 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 authored Jun 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 authored Jun 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 authored Jun 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

Done: · bcc97255
Bruce Momjian authored Jun 14, 2006
```
> 	o -Port contrib/xml2
```
bcc97255

Add information schema item: · c135db1d

Bruce Momjian authored Jun 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

Add COPY views patch URL: · 63b35a8c
Bruce Momjian authored Jun 14, 2006
```
> 	  http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php
```
63b35a8c

Add: · 74469731

Bruce Momjian authored Jun 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 authored Jun 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 authored Jun 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 authored Jun 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

Add locale TODO.detail emails. · bc299572
Bruce Momjian authored Jun 14, 2006

bc299572

Update link to TODO.detail: · 9ae8690a

Bruce Momjian authored Jun 14, 2006

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

9ae8690a

Add: · f944f880

Bruce Momjian authored Jun 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 authored Jun 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 authored Jun 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

Further thoughts about lo_export/lo_import error handling: if one of · 2193beb7

Tom Lane authored Jun 14, 2006

the lower-level large object functions fails, it will have already set
a suitable error message --- probably something from the backend ---
and it is not useful to overwrite that with a generic 'error while
reading large object' message. So remove redundant messages.

2193beb7

Clean up psql's control-C handling to avoid longjmp'ing out of random · f3164c02

Tom Lane authored Jun 14, 2006

places --- that risks corrupting data structures, losing sync with the
backend, etc. We now longjmp only from calls to readline, fgets, and
fread, which we assume are coded to protect themselves against interrupts
at undesirable times. This requires adding explicit tests for
cancel_pressed in long-running loops, but on the whole it's far cleaner.
Martijn van Oosterhout and Tom Lane.

f3164c02

Improve error detection and recovery in lo_import()/lo_export(). · ace93353
Tom Lane authored Jun 14, 2006
```
Problems noted while experimenting with new control-C code for psql.
```
ace93353

Do a CHECK_FOR_INTERRUPTS immediately before terminating a fastpath · 067e40cc

Tom Lane authored Jun 14, 2006

function call. Previously, there may have been no CHECK_FOR_INTERRUPTS
at all in the fastpath code path, making it impossible to cancel an
operation such as \lo_import externally. This addition doesn't ensure
you can cancel, since your SIGINT may arrive while the backend is idle
waiting for the client, but it gives the largest window we can easily
provide. Noted while experimenting with new control-C code for psql.

067e40cc

13 Jun, 2006 1 commit
- Remove: · aa30e0e5
  Bruce Momjian authored Jun 13, 2006
```
< 	o %Add CSV output format
```
  aa30e0e5