[COMMITTERS] pgsql: Fix typo noticed by Alvaro Herrera

2006-05-03 Thread Teodor Sigaev
Log Message:
---
Fix typo noticed by Alvaro Herrera

Modified Files:
--
pgsql/src/backend/access/gin:
ginxlog.c (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gin/ginxlog.c.diff?r1=1.1&r2=1.2)

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


[COMMITTERS] oledb - oledb: Force a thought out order on DBTYPE->PSQL types

2006-05-03 Thread User Shachar
Log Message:
---
Force a thought out order on DBTYPE->PSQL types conversion.
Problem reported by Victor Snezhko

Modified Files:
--
oledb:
PgSess.cpp (r1.38 -> r1.39)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/oledb/oledb/PgSess.cpp.diff?r1=1.38&r2=1.39)

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


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

2006-05-03 Thread Oleg Bartunov

On Tue, 2 May 2006, Tom Lane wrote:


[EMAIL PROTECTED] (Teodor Sigaev) writes:

Log Message:
---
GIN: Generalized Inverted iNdex.
text[], int4[], Tsearch2 support for GIN.


So ... where's the documentation?


Will submit soon. Christopher Kings-Lynne kindly agreed to help us
with SGML and wording.




regards, tom lane

---(end of broadcast)---
TIP 6: explain analyze is your friend



Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [email protected], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org


[COMMITTERS] pgsql: Make GIN opclass worked with intarray extensions

2006-05-03 Thread Teodor Sigaev
Log Message:
---
Make GIN opclass worked with intarray extensions

Modified Files:
--
pgsql/contrib/intarray:
Makefile (r1.13 -> r1.14)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/intarray/Makefile.diff?r1=1.13&r2=1.14)
_int.h (r1.8 -> r1.9)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/intarray/_int.h.diff?r1=1.8&r2=1.9)
_int.sql.in (r1.20 -> r1.21)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/intarray/_int.sql.in.diff?r1=1.20&r2=1.21)
_int_bool.c (r1.6 -> r1.7)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/intarray/_int_bool.c.diff?r1=1.6&r2=1.7)
uninstall__int.sql (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/intarray/uninstall__int.sql.diff?r1=1.2&r2=1.3)
pgsql/contrib/intarray/expected:
_int.out (r1.16 -> r1.17)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/intarray/expected/_int.out.diff?r1=1.16&r2=1.17)
pgsql/contrib/intarray/sql:
_int.sql (r1.8 -> r1.9)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/intarray/sql/_int.sql.diff?r1=1.8&r2=1.9)

Added Files:
---
pgsql/contrib/intarray:
_int_gin.c (r1.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/intarray/_int_gin.c?rev=1.1&content-type=text/x-cvsweb-markup)

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


[COMMITTERS] bizgres - bizgres: Oracle Metadata

2006-05-03 Thread User Nwakefield
Log Message:
---
Oracle Metadata

Added Files:
---
bizgres/KETL/setup:
KETL_MD_Schema_Oracle.ddl (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/setup/KETL_MD_Schema_Oracle.ddl?rev=1.1&content-type=text/x-cvsweb-markup)

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[COMMITTERS] bizgres - bizgres: Fixes 1.

2006-05-03 Thread User Nwakefield
Log Message:
---
Fixes
1. Resolved bug that causes LOADID parameter to be set to 0
2. Default value was missing from NIOFileReader

Enhancements:
1. Added support to override the load id when running in command line mode.

Modified Files:
--
bizgres/KETL/src/com/kni/etl:
ETLJobExecutor.java (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ETLJobExecutor.java.diff?r1=1.3&r2=1.4)
SQLJobExecutor.java (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/SQLJobExecutor.java.diff?r1=1.4&r2=1.5)
Metadata.java (r1.9 -> r1.10)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/Metadata.java.diff?r1=1.9&r2=1.10)
FieldLevelFastInputChannel.java (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/FieldLevelFastInputChannel.java.diff?r1=1.2&r2=1.3)
bizgres/KETL/src/com/kni/etl/dbutils:
ColumnDefinition.java (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/dbutils/ColumnDefinition.java.diff?r1=1.3&r2=1.4)
bizgres/KETL/src/com/kni/etl/ketl/reader:
NIOFileReader.java (r1.7 -> r1.8)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/reader/NIOFileReader.java.diff?r1=1.7&r2=1.8)

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


[COMMITTERS] pgsql: Create a syscache for pg_database-indexed-by-oid, and make use of

2006-05-03 Thread Tom Lane
Log Message:
---
Create a syscache for pg_database-indexed-by-oid, and make use of it
in various places that were previously doing ad hoc pg_database searches.
This may speed up database-related privilege checks a little bit, but
the main motivation is to eliminate the performance reason for having
ReverifyMyDatabase do such a lot of stuff (viz, avoiding repeat scans
of pg_database during backend startup).  The locking reason for having
that routine is about to go away, and it'd be good to have the option
to break it up.

Modified Files:
--
pgsql/src/backend/catalog:
aclchk.c (r1.127 -> r1.128)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/aclchk.c.diff?r1=1.127&r2=1.128)
pgsql/src/backend/commands:
dbcommands.c (r1.179 -> r1.180)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/dbcommands.c.diff?r1=1.179&r2=1.180)
vacuum.c (r1.328 -> r1.329)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacuum.c.diff?r1=1.328&r2=1.329)
pgsql/src/backend/postmaster:
autovacuum.c (r1.17 -> r1.18)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/autovacuum.c.diff?r1=1.17&r2=1.18)
pgsql/src/backend/utils/cache:
syscache.c (r1.102 -> r1.103)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/cache/syscache.c.diff?r1=1.102&r2=1.103)
pgsql/src/backend/utils/init:
postinit.c (r1.164 -> r1.165)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/init/postinit.c.diff?r1=1.164&r2=1.165)
pgsql/src/include/utils:
acl.h (r1.95 -> r1.96)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/acl.h.diff?r1=1.95&r2=1.96)
syscache.h (r1.62 -> r1.63)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/syscache.h.diff?r1=1.62&r2=1.63)

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


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

2006-05-03 Thread Christopher Kings-Lynne

[EMAIL PROTECTED] (Teodor Sigaev) writes:

Log Message:
---
GIN: Generalized Inverted iNdex.
text[], int4[], Tsearch2 support for GIN.


So ... where's the documentation?


Will submit soon. Christopher Kings-Lynne kindly agreed to help us
with SGML and wording.


Just gimme some time :)


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings