Re: [COMMITTERS] pgsql: Use unsigned into for slock_t for pre-sparcv8plus.

2006-05-18 Thread Kris Jurka
Bruce Momjian wrote: Log Message: --- Use unsigned into for slock_t for pre-sparcv8plus. This breaks x86. http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=kudu&dt=2006-05-19%2004:30:01 Kris Jurka ---(end of broadcast)--- TIP 2: Don't

[COMMITTERS] pgsql: Back out \' change for tsearch2, broke regression tests.

2006-05-18 Thread Bruce Momjian
Log Message: --- Back out \' change for tsearch2, broke regression tests. Tags: REL8_1_STABLE Modified Files: -- pgsql/contrib/tsearch2: query.c (r1.18.2.2 -> r1.18.2.3) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/query.c.diff?r

[COMMITTERS] pgsql: Back out \' change for tsearch2, broke regression tests.

2006-05-18 Thread Bruce Momjian
Log Message: --- Back out \' change for tsearch2, broke regression tests. Modified Files: -- pgsql/contrib/tsearch2: query.c (r1.25 -> r1.26) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/query.c.diff?r1=1.25&r2=1.26) tsvector.c

[COMMITTERS] dbsamples - pagila: update the notes on pagila

2006-05-18 Thread User Xzilla
Log Message: --- update the notes on pagila Modified Files: -- pagila: README (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/README.diff?r1=1.1&r2=1.2) ---(end of broadcast)--- T

[COMMITTERS] dbsamples - pagila: add rewards_report function, give up on holdable

2006-05-18 Thread User Xzilla
Log Message: --- add rewards_report function, give up on holdable cursor to emulate @count var for now Modified Files: -- pagila: pagila-schema.sql (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-schema.sql.diff?r1=1.2&r

[COMMITTERS] pgsql: Stamp 8.1.4, except configure/configure.in.

2006-05-18 Thread Bruce Momjian
Log Message: --- Stamp 8.1.4, except configure/configure.in. Tags: REL8_1_STABLE Modified Files: -- pgsql/doc: FAQ (r1.362.2.9 -> r1.362.2.10) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.362.2.9&r2=1.362.2.10) FAQ_AIX (

[COMMITTERS] pgsql: Mention packager bumps configure.in/configure.

2006-05-18 Thread Bruce Momjian
Log Message: --- Mention packager bumps configure.in/configure. Modified Files: -- pgsql/src/tools: RELEASE_CHANGES (r1.64 -> r1.65) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/tools/RELEASE_CHANGES.diff?r1=1.64&r2=1.65) -

[COMMITTERS] pgsql: Stamp 8.1.4, except configure/configure.in.

2006-05-18 Thread Bruce Momjian
Log Message: --- Stamp 8.1.4, except configure/configure.in. Modified Files: -- pgsql/doc/src/sgml: release.sgml (r1.426 -> r1.427) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release.sgml.diff?r1=1.426&r2=1.427)

[COMMITTERS] pgsql: Update for version 8.1.4.

2006-05-18 Thread Bruce Momjian
Log Message: --- Update for version 8.1.4. Modified Files: -- pgsql/doc: FAQ (r1.385 -> r1.386) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.385&r2=1.386) pgsql/doc/src/FAQ: FAQ.html (r1.341 -> r1.342) (http://dev

[COMMITTERS] pgsql: Update release notes for 8.1.4.

2006-05-18 Thread Bruce Momjian
Log Message: --- Update release notes for 8.1.4. Tags: REL8_1_STABLE Modified Files: -- pgsql/doc/src/sgml: release.sgml (r1.400.2.24 -> r1.400.2.25) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release.sgml.diff?r1=1.400.2.24&r2=1.4

[COMMITTERS] pgsql: Update release notes for 8.1.4.

2006-05-18 Thread Bruce Momjian
Log Message: --- Update release notes for 8.1.4. Modified Files: -- pgsql/doc/src/sgml: release.sgml (r1.425 -> r1.426) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release.sgml.diff?r1=1.425&r2=1.426) ---(end of b

[COMMITTERS] pgsql: Backpatch FAQs to 8.1.X.

2006-05-18 Thread Bruce Momjian
Log Message: --- Backpatch FAQs to 8.1.X. Tags: REL8_1_STABLE Modified Files: -- pgsql/doc: FAQ (r1.362.2.8 -> r1.362.2.9) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.362.2.8&r2=1.362.2.9) FAQ_AIX (r1.14.2.15 -> r1.14.2

[COMMITTERS] pgsql: Use SQL standard '' rather than \' in /contrib.

2006-05-18 Thread Bruce Momjian
Log Message: --- Use SQL standard '' rather than \' in /contrib. Backpatch to 8.1.X. Tags: REL8_1_STABLE Modified Files: -- pgsql/contrib/dbmirror: DBMirror.pl (r1.10 -> r1.10.6.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dbmirror/DB

[COMMITTERS] pgsql: Use SQL standard '' rather than \' in /contrib.

2006-05-18 Thread Bruce Momjian
Log Message: --- Use SQL standard '' rather than \' in /contrib. Backpatch to 8.1.X. Modified Files: -- pgsql/contrib/dbmirror: DBMirror.pl (r1.10 -> r1.11) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dbmirror/DBMirror.pl.diff?r1=1.10&r2=1.11

[COMMITTERS] dbsamples - pagila: Some general information on pagila

2006-05-18 Thread User Xzilla
Log Message: --- Some general information on pagila Added Files: --- pagila: README (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/README?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)

[COMMITTERS] dbsamples - pagila: tsearch2 support, based on Chris's original port.

2006-05-18 Thread User Xzilla
Log Message: --- tsearch2 support, based on Chris's original port. initdb in C is recommended Added Files: --- pagila: pagila-fulltext.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-fulltext.sql?rev=1.1&content-type=text/x-cvsw

[COMMITTERS] dbsamples - pagila: typo in coalesce statement

2006-05-18 Thread User Xzilla
Log Message: --- typo in coalesce statement Modified Files: -- pagila: pagila-schema.sql (r1.1.1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-schema.sql.diff?r1=1.1.1.1&r2=1.2) ---(end of broadcast

Re: [COMMITTERS] pgsql: Add simplified sparc8 ASM for solaris_sparc.s,

2006-05-18 Thread Bruce Momjian
Tom Lane wrote: > [EMAIL PROTECTED] (Bruce Momjian) writes: > > Add simplified sparc8 ASM for solaris_sparc.s, from Alan Stange. > > Has this actually been tested at all? > > The reason I don't think it works is that ldstub and cas are not > interchangeable; they don't even work on the same data

[COMMITTERS] pgsql: Use unsigned into for slock_t for pre-sparcv8plus.

2006-05-18 Thread Bruce Momjian
Log Message: --- Use unsigned into for slock_t for pre-sparcv8plus. Modified Files: -- pgsql/src/include/storage: s_lock.h (r1.154 -> r1.155) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/s_lock.h.diff?r1=1.154&r2=1.155) ---

Re: [COMMITTERS] pgsql: Add simplified sparc8 ASM for solaris_sparc.s, from Alan Stange.

2006-05-18 Thread Tom Lane
[EMAIL PROTECTED] (Bruce Momjian) writes: > Add simplified sparc8 ASM for solaris_sparc.s, from Alan Stange. Has this actually been tested at all? The reason I don't think it works is that ldstub and cas are not interchangeable; they don't even work on the same data width. Surely there need to be

[COMMITTERS] dbsamples - pagila: Imported Sources

2006-05-18 Thread User Xzilla
Update of /cvsroot/dbsamples/pagila In directory pgfoundry.org:/tmp/cvs-serv25235 Log Message: 3rd Time is The Charm Status: Vendor Tag: pagila Release Tags: start N pagila/pagila-data.sql N pagila/pagila-schema.sql No conflicts created by this import --

[COMMITTERS] pgsql: Fix choose_bitmap_and() so that partial index predicates are

2006-05-18 Thread Tom Lane
Log Message: --- Fix choose_bitmap_and() so that partial index predicates are considered when deciding whether a potential additional indexscan is redundant or not. As now coded, any use of a partial index that was already used in a previous AND arm will be rejected as redundant. This mig

[COMMITTERS] pgsql: Fix choose_bitmap_and() so that partial index predicates are

2006-05-18 Thread Tom Lane
Log Message: --- Fix choose_bitmap_and() so that partial index predicates are considered when deciding whether a potential additional indexscan is redundant or not. As now coded, any use of a partial index that was already used in a previous AND arm will be rejected as redundant. This mig

[COMMITTERS] dbsamples - pagila: re-org file layout to what I actually wanted to do

2006-05-18 Thread User Xzilla
Log Message: --- re-org file layout to what I actually wanted to do Added Files: --- pagila: pagila-data.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-data.sql?rev=1.1&content-type=text/x-cvsweb-markup) pagila-schema.sq

[COMMITTERS] dbsamples - pagila: Imported Sources

2006-05-18 Thread User Xzilla
Update of /cvsroot/dbsamples/pagila In directory pgfoundry.org:/tmp/cvs-serv18959 Log Message: Imported pagila, hopefully correctly this time Status: Vendor Tag: pagila Release Tags: start N pagila/pagila/pagila-data.sql N pagila/pagila/pagila-schema.sql No conflicts crea

[COMMITTERS] pgsql: When a bitmap indexscan is using a partial index, it is necessary

2006-05-18 Thread Tom Lane
Log Message: --- When a bitmap indexscan is using a partial index, it is necessary to include the partial index predicate in the scan's "recheck condition". Otherwise, if the scan becomes lossy for lack of bitmap memory, we would fail to enforce that returned rows satisfy the predicate. N

[COMMITTERS] pgsql: When a bitmap indexscan is using a partial index, it is necessary

2006-05-18 Thread Tom Lane
Log Message: --- When a bitmap indexscan is using a partial index, it is necessary to include the partial index predicate in the scan's "recheck condition". Otherwise, if the scan becomes lossy for lack of bitmap memory, we would fail to enforce that returned rows satisfy the predicate. N

[COMMITTERS] pgsql: Allow sparcv8plus to use "cas".

2006-05-18 Thread Bruce Momjian
Log Message: --- Allow sparcv8plus to use "cas". Theo Schlossnagle Modified Files: -- pgsql/src/backend/port/tas: solaris_sparc.s (r1.10 -> r1.11) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/port/tas/solaris_sparc.s.diff?r1=1.10&r2=1.11)

[COMMITTERS] dbsamples - pgfoundry: Imported Sources

2006-05-18 Thread User Xzilla
Update of /cvsroot/dbsamples/pgfoundry/pagila In directory pgfoundry.org:/tmp/cvs-serv13839 Log Message: Imported pagila Status: Vendor Tag: pagila Release Tags: start N pgfoundry/pagila/pagila-schema.sql N pgfoundry/pagila/pagila-data.sql No conflicts created by this imp

[COMMITTERS] pgsql: Code alignment fix.

2006-05-18 Thread Bruce Momjian
Log Message: --- Code alignment fix. Modified Files: -- pgsql/src/interfaces/libpq: fe-misc.c (r1.125 -> r1.126) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/libpq/fe-misc.c.diff?r1=1.125&r2=1.126) ---(end of bro

[COMMITTERS] pgsql: Fix thinko in recent changes to handle ScalarArrayOpExpr as an

2006-05-18 Thread Tom Lane
Log Message: --- Fix thinko in recent changes to handle ScalarArrayOpExpr as an indexable condition: when there are multiple possible index paths involving ScalarArrayOpExprs, they are logically to be ANDed together not ORed. This thinko was a direct consequence of trying to put the process

[COMMITTERS] pgsql: Remove canonicalize_path() call for .pgpass socket directory

2006-05-18 Thread Bruce Momjian
Log Message: --- Remove canonicalize_path() call for .pgpass socket directory comparison; not worth adding path.c to libpq. Modified Files: -- pgsql/src/interfaces/libpq: fe-connect.c (r1.329 -> r1.330) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/

[COMMITTERS] pgsql: Mention that gcc/sparc generates sparcv7 binaries.

2006-05-18 Thread Bruce Momjian
Log Message: --- Mention that gcc/sparc generates sparcv7 binaries. Modified Files: -- pgsql/src/include/storage: s_lock.h (r1.153 -> r1.154) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/s_lock.h.diff?r1=1.153&r2=1.154) ---

Re: [COMMITTERS] pgsql: GIN: Generalized Inverted iNdex.

2006-05-18 Thread Teodor Sigaev
Ok, I can look into this now... Good, thank you. I'm not sure really where to being though. What are all the new operators? What does it even mean to use a GIN over an int[] column? Patch introduces three new operators over one-dimensional arrays (left and rights args should have the sam