[COMMITTERS] pgsql: Improve hash_any() to use word-wide fetches when hashing suitably

2008-04-06 Thread Tom Lane
Log Message:
---
Improve hash_any() to use word-wide fetches when hashing suitably aligned
data.  This makes for a significant speedup at the cost that the results
now vary between little-endian and big-endian machines; which forces us
to add explicit ORDER BYs in a couple of regression tests to preserve
machine-independent comparison results.  Also, force initdb by bumping
catversion, since the contents of hash indexes will change (at least on
big-endian machines).

Kenneth Marshall and Tom Lane, based on work from Bob Jenkins.  This commit
does not adopt Bob's new faster mix() algorithm, however, since we still need
to convince ourselves that that doesn't degrade the quality of the hashing.

Modified Files:
--
pgsql/contrib/dblink/expected:
dblink.out (r1.22 -> r1.23)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/expected/dblink.out?r1=1.22&r2=1.23)
pgsql/contrib/dblink/sql:
dblink.sql (r1.19 -> r1.20)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/sql/dblink.sql?r1=1.19&r2=1.20)
pgsql/src/backend/access/hash:
hashfunc.c (r1.55 -> r1.56)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/hash/hashfunc.c?r1=1.55&r2=1.56)
pgsql/src/include/catalog:
catversion.h (r1.445 -> r1.446)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.445&r2=1.446)
pgsql/src/test/regress/expected:
portals.out (r1.16 -> r1.17)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/portals.out?r1=1.16&r2=1.17)
pgsql/src/test/regress/sql:
portals.sql (r1.13 -> r1.14)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/portals.sql?r1=1.13&r2=1.14)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Make plpgsql support FOR over a query specified by a cursor

2008-04-06 Thread Tom Lane
Log Message:
---
Make plpgsql support FOR over a query specified by a cursor declaration,
for improved compatibility with Oracle.

Pavel Stehule, with some fixes by me.

Modified Files:
--
pgsql/doc/src/sgml:
plpgsql.sgml (r1.126 -> r1.127)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/plpgsql.sgml?r1=1.126&r2=1.127)
pgsql/src/pl/plpgsql/src:
gram.y (r1.109 -> r1.110)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/gram.y?r1=1.109&r2=1.110)
pl_comp.c (r1.123 -> r1.124)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/pl_comp.c?r1=1.123&r2=1.124)
pl_exec.c (r1.208 -> r1.209)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/pl_exec.c?r1=1.208&r2=1.209)
pl_funcs.c (r1.68 -> r1.69)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/pl_funcs.c?r1=1.68&r2=1.69)
plpgsql.h (r1.96 -> r1.97)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/plpgsql.h?r1=1.96&r2=1.97)
pgsql/src/test/regress/expected:
plpgsql.out (r1.60 -> r1.61)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/plpgsql.out?r1=1.60&r2=1.61)
pgsql/src/test/regress/sql:
plpgsql.sql (r1.50 -> r1.51)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/plpgsql.sql?r1=1.50&r2=1.51)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Add documentation clarification for IS [NOT] NULL and row-valued

2008-04-06 Thread Bruce Momjian
Log Message:
---
Add documentation clarification for IS [NOT] NULL and row-valued
expressions.

Modified Files:
--
pgsql/doc/src/sgml:
func.sgml (r1.427 -> r1.428)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml?r1=1.427&r2=1.428)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Add to TODO: > > o Add ability to obfuscate function bodies >

2008-04-06 Thread Bruce Momjian
Log Message:
---
Add to TODO:

> 
>   o Add ability to obfuscate function bodies
> 
> http://archives.postgresql.org/pgsql-patches/2008-01/msg00125.php

Modified Files:
--
pgsql/doc:
TODO (r1.2409 -> r1.2410)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2409&r2=1.2410)
pgsql/doc/src/FAQ:
TODO.html (r1.915 -> r1.916)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html?r1=1.915&r2=1.916)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] npgsql - Npgsql2: Added SSPI patch from Brar Piening

2008-04-06 Thread User Jbcooley
Log Message:
---
Added SSPI patch from Brar Piening

Modified Files:
--
Npgsql2/src:
Npgsql2008.csproj (r1.10 -> r1.11)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql2008.csproj.diff?r1=1.10&r2=1.11)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] npgsql - Npgsql2: Added SSPI patch from Brar Piening

2008-04-06 Thread User Jbcooley
Log Message:
---
Added SSPI patch from Brar Piening

Modified Files:
--
Npgsql2/src/Npgsql:
NpgsqlConnection.cs (r1.20 -> r1.21)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql/NpgsqlConnection.cs.diff?r1=1.20&r2=1.21)
NpgsqlConnectionStringBuilder.cs (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql/NpgsqlConnectionStringBuilder.cs.diff?r1=1.4&r2=1.5)
NpgsqlConnector.cs (r1.17 -> r1.18)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql/NpgsqlConnector.cs.diff?r1=1.17&r2=1.18)
NpgsqlState.cs (r1.11 -> r1.12)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql/NpgsqlState.cs.diff?r1=1.11&r2=1.12)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] npgsql - Npgsql2: Change Integrated Security default to false.

2008-04-06 Thread User Jbcooley
Log Message:
---
Change Integrated Security default to false.  Fix Integrated Security property 
to store using the correct key.

Modified Files:
--
Npgsql2/src/Npgsql:
NpgsqlConnectionStringBuilder.cs (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql/NpgsqlConnectionStringBuilder.cs.diff?r1=1.5&r2=1.6)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] npgsql - Npgsql2: Added additional resources to project

2008-04-06 Thread User Jbcooley
Log Message:
---
Added additional resources to project

Modified Files:
--
Npgsql2/src:
Npgsql2008.csproj (r1.11 -> r1.12)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql2008.csproj.diff?r1=1.11&r2=1.12)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] npgsql - Npgsql2: Added documentation about integrated security.

2008-04-06 Thread User Fxjr
Log Message:
---
Added documentation about integrated security.

Modified Files:
--
Npgsql2/docs:
UserManual.html (r1.8 -> r1.9)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/docs/UserManual.html.diff?r1=1.8&r2=1.9)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] npgsql - Npgsql2: Updated release notes for Npgsql beta3 release

2008-04-06 Thread User Fxjr
Log Message:
---
Updated release notes for Npgsql beta3 release

Modified Files:
--
Npgsql2:
RELEASENOTES.txt (r1.6 -> r1.7)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/RELEASENOTES.txt.diff?r1=1.6&r2=1.7)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] npgsql - Npgsql2: Updated changelog for Npgsql Beta3 release

2008-04-06 Thread User Fxjr
Log Message:
---
Updated changelog for Npgsql Beta3 release

Modified Files:
--
Npgsql2:
ChangeLog (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/ChangeLog.diff?r1=1.4&r2=1.5)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers