[COMMITTERS] pgsql: Add calcluation of bitmap storage capacity.

2005-12-01 Thread Bruce Momjian
Log Message: --- Add calcluation of bitmap storage capacity. < be cleared when a heap tuple is expired. Another idea is to maintain < a bitmap of heap pages where all rows are visible to all backends, < and allow index lookups to reference that bitmap to avoid heap < lookups, perh

[COMMITTERS] pgsql: Remove comment on errno=0 lines, but add mention to port/strtol.c

2005-12-01 Thread Bruce Momjian
Log Message: --- Remove comment on errno=0 lines, but add mention to port/strtol.c function. Modified Files: -- pgsql/src/backend/utils/adt: datetime.c (r1.164 -> r1.165) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c.dif

[COMMITTERS] mysqlcompat - mysqlcompat: Add a handy .sql file that loads all the

2005-12-01 Thread User Chriskl
Log Message: --- Add a handy .sql file that loads all the functions in one go. Added Files: --- mysqlcompat: all.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/mysqlcompat/mysqlcompat/all.sql?rev=1.1&content-type=text/x-cvsweb-markup)

[COMMITTERS] mysqlcompat - mysqlcompat: Add benchmark(), coercibility(), bit_count()

2005-12-01 Thread User Chriskl
Log Message: --- Add benchmark(), coercibility(), bit_count() and remove bit_length() Modified Files: -- mysqlcompat: README (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/mysqlcompat/mysqlcompat/README.diff?r1=1.3&r2=1.4) datetime.sql

[COMMITTERS] pgsql: Rearrange code in ExecInitBitmapHeapScan so that we don't

2005-12-01 Thread Tom Lane
Log Message: --- Rearrange code in ExecInitBitmapHeapScan so that we don't initialize the child plan nodes until we have acquired lock on the relation to scan. The relative order of initialization of plan nodes isn't real important in other cases, but it's critical here because one is suppo

[COMMITTERS] pgsql: Rearrange code in ExecInitBitmapHeapScan so that we don't

2005-12-01 Thread Tom Lane
Log Message: --- Rearrange code in ExecInitBitmapHeapScan so that we don't initialize the child plan nodes until we have acquired lock on the relation to scan. The relative order of initialization of plan nodes isn't real important in other cases, but it's critical here because one is suppo

[COMMITTERS] pgsql: Add all heap page rows visible bitmap idea: < the heap.

2005-12-01 Thread Bruce Momjian
Log Message: --- Add all heap page rows visible bitmap idea: < the heap. One way to allow this is to set a bit to index tuples > the heap. One way to allow this is to set a bit on index tuples < be cleared when a heap tuple is expired. < > be cleared when a heap tuple is expir

[COMMITTERS] pgsql: Add MERGE TODO.detail: > [merge] 378a380 > [merge]

2005-12-01 Thread Bruce Momjian
Log Message: --- Add MERGE TODO.detail: > [merge] 378a380 > [merge] Modified Files: -- pgsql/doc: TODO (r1.1707 -> r1.1708) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1707&r2=1.1708) pgsql/doc/src/FAQ: TODO.html (r

[COMMITTERS] pgsql: Add merge TODO.detail item.

2005-12-01 Thread Bruce Momjian
Log Message: --- Add merge TODO.detail item. Added Files: --- pgsql/doc/TODO.detail: merge (r1.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.detail/merge?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)--

[COMMITTERS] pgsql: Split out MERGE and REPLACE/UPSERT items.

2005-12-01 Thread Bruce Momjian
Log Message: --- Split out MERGE and REPLACE/UPSERT items. < * Add MERGE command that does UPDATE/DELETE, or on failure, INSERT (rules, < triggers?) > * Add SQL-standard MERGE command, typically used to merge two tables > > This is similar to UPDATE, then for unmatched rows, INSERT. >

[COMMITTERS] python - be: Implement text's sequence interface.

2005-12-01 Thread James William Pye
Log Message: --- Implement text's sequence interface. Use text_substring and textlen :) *_contains for text and bytea still needs to be implemented :( Modified Files: -- be/src/type: textual.c (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/py

[COMMITTERS] pgsql: Add comment to pg_atoi.

2005-12-01 Thread Bruce Momjian
Log Message: --- Add comment to pg_atoi. Modified Files: -- pgsql/src/backend/utils/adt: numutils.c (r1.70 -> r1.71) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/numutils.c.diff?r1=1.70&r2=1.71) ---(end of

[COMMITTERS] pgsql: Comment "errno = 0" in a more generic way.

2005-12-01 Thread Bruce Momjian
Log Message: --- Comment "errno = 0" in a more generic way. Modified Files: -- pgsql/src/backend/utils/adt: datetime.c (r1.163 -> r1.164) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c.diff?r1=1.163&r2=1.164) floa

Re: [COMMITTERS] pgsql: Add comments about why errno is set to zero.

2005-12-01 Thread Tom Lane
[EMAIL PROTECTED] (Bruce Momjian) writes: > Log Message: > --- > Add comments about why errno is set to zero. These comments seem a bit wrongheaded, since "checking LONG_MIN/LONG_MAX" is exactly not what we could do to detect an overflow error. regards, tom lane -

[COMMITTERS] pgsql: Retry in FileRead and FileWrite if Windows returns

2005-12-01 Thread Tom Lane
Log Message: --- Retry in FileRead and FileWrite if Windows returns ERROR_NO_SYSTEM_RESOURCES. Also add a retry for Unixen returning EINTR, which hasn't been reported as an issue but at least theoretically could be. Patch by Qingqing Zhou, some minor adjustments by me. Tags: REL8_0_S

[COMMITTERS] pgsql: Retry in FileRead and FileWrite if Windows returns

2005-12-01 Thread Tom Lane
Log Message: --- Retry in FileRead and FileWrite if Windows returns ERROR_NO_SYSTEM_RESOURCES. Also add a retry for Unixen returning EINTR, which hasn't been reported as an issue but at least theoretically could be. Patch by Qingqing Zhou, some minor adjustments by me. Tags: REL8_1_S

[COMMITTERS] pgsql: Retry in FileRead and FileWrite if Windows returns

2005-12-01 Thread Tom Lane
Log Message: --- Retry in FileRead and FileWrite if Windows returns ERROR_NO_SYSTEM_RESOURCES. Also add a retry for Unixen returning EINTR, which hasn't been reported as an issue but at least theoretically could be. Patch by Qingqing Zhou, some minor adjustments by me. Modified Files: ---

[COMMITTERS] pgsql: Add comments about why errno is set to zero.

2005-12-01 Thread Bruce Momjian
Log Message: --- Add comments about why errno is set to zero. Modified Files: -- pgsql/src/backend/utils/adt: datetime.c (r1.162 -> r1.163) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c.diff?r1=1.162&r2=1.163) fl

[COMMITTERS] python - be: Improve bytea accessors.

2005-12-01 Thread James William Pye
Log Message: --- Improve bytea accessors. Primarily, do not assume the Datum is not toasted. Use byteaoctetlen for length and DatumGetByteaPSlice() for slicing. (str() should probably return a raw string of the bytea instead of the typoutput as slicing now returns byteas instead Python St

[COMMITTERS] pgsql: - Made several variables "const char *" instead of "char *" as

2005-12-01 Thread Michael Meskes
Log Message: --- - Made several variables "const char *" instead of "char *" as proposed by Qingqing Zhou <[EMAIL PROTECTED]>. - Replaced all strdup() calls by ECPGstrdup(). - Set ecpg library version to 5.2. - Set ecpg version to 4.2.1. Modified Files: -- pgsql/src/interf

[COMMITTERS] pgsql: Fix typo in PL/PgSQL documentation, per Chris KL.

2005-12-01 Thread Neil Conway
Log Message: --- Fix typo in PL/PgSQL documentation, per Chris KL. Modified Files: -- pgsql/doc/src/sgml: plpgsql.sgml (r1.80 -> r1.81) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/plpgsql.sgml.diff?r1=1.80&r2=1.81) --

[COMMITTERS] pgsql: Fix typo in PL/PgSQL documentation, per Chris KL.

2005-12-01 Thread Neil Conway
Log Message: --- Fix typo in PL/PgSQL documentation, per Chris KL. Tags: REL8_1_STABLE Modified Files: -- pgsql/doc/src/sgml: plpgsql.sgml (r1.80 -> r1.80.2.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/plpgsql.sgml.diff?r1=1.80&r2

[COMMITTERS] pgsql: - Made several variables "const char *" instead of "char *" as

2005-12-01 Thread Michael Meskes
Log Message: --- - Made several variables "const char *" instead of "char *" as proposed by Qingqing Zhou <[EMAIL PROTECTED]>. - Replaced all strdup() calls by ECPGstrdup(). Tags: REL8_1_STABLE Modified Files: -- pgsql/src/interfaces/ecpg/ecpglib: connect.c (

[COMMITTERS] pgsql: - Made several variables "const char *" instead of "char *" as

2005-12-01 Thread Michael Meskes
Log Message: --- - Made several variables "const char *" instead of "char *" as proposed by Qingqing Zhou <[EMAIL PROTECTED]>. - Replaced all strdup() calls by ECPGstrdup(). Tags: REL8_0_STABLE Modified Files: -- pgsql/src/interfaces/ecpg/ecpglib: connect.c (

[COMMITTERS] pgsql: Check for overflow in strtol() while parsing datetime inputs.

2005-12-01 Thread Tom Lane
Log Message: --- Check for overflow in strtol() while parsing datetime inputs. Michael Fuhr. Tags: REL7_4_STABLE Modified Files: -- pgsql/src/backend/utils/adt: datetime.c (r1.118.2.6 -> r1.118.2.7) (http://developer.postgresql.org/cvsweb.cgi/pgsql/sr

[COMMITTERS] pgsql: Check for overflow in strtol() while parsing datetime inputs.

2005-12-01 Thread Tom Lane
Log Message: --- Check for overflow in strtol() while parsing datetime inputs. Michael Fuhr. Tags: REL8_0_STABLE Modified Files: -- pgsql/src/backend/utils/adt: datetime.c (r1.137.4.2 -> r1.137.4.3) (http://developer.postgresql.org/cvsweb.cgi/pgsql/sr

[COMMITTERS] pgsql: Check for overflow in strtol() while parsing datetime inputs.

2005-12-01 Thread Tom Lane
Log Message: --- Check for overflow in strtol() while parsing datetime inputs. Michael Fuhr. Tags: REL8_1_STABLE Modified Files: -- pgsql/src/backend/utils/adt: datetime.c (r1.160.2.1 -> r1.160.2.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/sr

[COMMITTERS] pgsql: Check for overflow in strtol() while parsing datetime inputs.

2005-12-01 Thread Tom Lane
Log Message: --- Check for overflow in strtol() while parsing datetime inputs. Michael Fuhr. Modified Files: -- pgsql/src/backend/utils/adt: datetime.c (r1.161 -> r1.162) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c.dif

[COMMITTERS] psqlodbc - psqlodbc: Post release version bump

2005-12-01 Thread User Dpage
Log Message: --- Post release version bump Modified Files: -- psqlodbc: configure.ac (r1.39 -> r1.40) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/configure.ac.diff?r1=1.39&r2=1.40) psqlodbc.rc (r1.69 -> r1.70) (http://cvs

[COMMITTERS] mysqlcompat - mysqlcompat: Add substring_index()

2005-12-01 Thread User Chriskl
Log Message: --- Add substring_index() Modified Files: -- mysqlcompat: string.sql (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/mysqlcompat/mysqlcompat/string.sql.diff?r1=1.6&r2=1.7) ---(end of broadcast)--

[COMMITTERS] mysqlcompat - mysqlcompat: New functions: CONV() from Gavin Sherry,

2005-12-01 Thread User Chriskl
Log Message: --- New functions: CONV() from Gavin Sherry, OCT() (depended on CONV() and UNHEX() (depended on CONV()) Modified Files: -- mysqlcompat: string.sql (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/mysqlcompat/mysqlcompat/string.sql.d