of transaction isolation level changed from uppercase to lower case between 7.3 and 7.4.  In testing, a regression was also fixed in this area when talking to
a 7.2 server due to changes in how notice messages are processed in the current
code.

 Modified Files:
 	jdbc/build.xml jdbc/org/postgresql/core/BaseStatement.java
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java

yet, though).  Avoid using nth() to fetch tlist entries; provide a
common routine get_tle_by_resno() to search a tlist for a particular
resno.  This replaces a couple uses of nth() and a dozen hand-coded
search loops.  Also, replace a few uses of nth(length-1, list) with
llast().

of thread-safety comments.

index pages: when _bt_getbuf asks the FSM for a free index page, it is
possible (and, in some cases, even moderately likely) that the answer
will be the same page that _bt_split is trying to split.  _bt_getbuf
already knew that the returned page might not be free, but it wasn't
prepared for the possibility that even trying to lock the page could
be problematic.  Fix by doing a conditional rather than unconditional
grab of the page lock.

(doubtless these are hangovers from the old separate-books days).

This is Joe Conway's patch of 7-Aug plus further editorializing
of my own.

gcc -pipe -g -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../src/include   -c -o pg_id.o pg_id.c -MMD
pg_id.c: In function `main':
pg_id.c:35: warning: unused variable `optarg'

The attached trivial patch fixes the warning by removing the variable.

Neil Conway

extra line break in to improve formatting.

Christopher Kings-Lynne

> * Allow clients to query WITH HOLD cursors and prepared statements
503d503
<

They had the old versions anyway.

some debugging malloc packages do.

Per report from Mendola Gaetano.

< 	o -Implement SQLDA
> 	o Implement SQLDA

< * Allow easy display of usernames in a group
> * -Allow easy display of usernames in a group
88,89d87
< * -Delay resolution of array expression type so assignment coercion
<   can be performed on empty array expressions (Joe)
94c92,94
< 	o Support construction of array result values in expressions
> 	o -Support construction of array result values in expressions (Joe)
> 	o Delay resolution of array expression type so assignment coercion
> 	  can be performed on empty array expressions (Joe)
148c148
< * Allow LIKE indexing optimization for non-ASCII locales
> * -Allow LIKE indexing optimization for non-ASCII locales using special index
173c173
< * Return proper effected tuple count from complex commands [return]
> * -Return proper effected tuple count from complex commands [return]
236c236
< 	o Allow SHOW of non-modifiable variables, like pg_controldata
>  	o -Allow SHOW of some non-modifiable variables, like pg_controldata
257a258
> 	o Add capability to create and call PROCEDURES
272c273
<
> * Allow psql \du to show groups, and add \dg for groups
424c425
< * Improve Subplan list handling
> * -Improve Subplan list handling

< 	o Allow array declarations and other data types in PL/PgSQL DECLARE
> 	o -Allow array declarations and other data types in PL/PgSQL DECLARE
254c254
< 	o Allow PL/PgSQL to support array element assignment
> 	o -Allow PL/PgSQL to support array element assignment (Joe)

< 	o Add PL/PgSQL PROCEDURES that can return multiple values

mode.

from Dave Cramer

NULL for it.