[COMMITTERS] nagiosplugins - nagiosplugins: clean up some perl warnings, still not

2007-03-21 Thread User Xzilla
Log Message:
---
clean up some perl warnings, still not 100% though

Modified Files:
--
nagiosplugins:
check_pg_waiting_queries.pl (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/nagiosplugins/nagiosplugins/check_pg_waiting_queries.pl.diff?r1=1.2&r2=1.3)

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


[COMMITTERS] nagiosplugins - nagiosplugins: make install a little more legible for

2007-03-21 Thread User Xzilla
Log Message:
---
make install a little more legible for crappy editors, clean up a few links and 
clarify some warnings

Modified Files:
--
nagiosplugins:
INSTALL (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/nagiosplugins/nagiosplugins/INSTALL.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] nagiosplugins - nagiosplugins: Make README a bit more legible

2007-03-21 Thread User Xzilla
Log Message:
---
Make README a bit more legible

Modified Files:
--
nagiosplugins:
README (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/nagiosplugins/nagiosplugins/README.diff?r1=1.2&r2=1.3)

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


[COMMITTERS] dbsamples - pagila: convert payment to partitioned tables using rules

2007-03-28 Thread User Xzilla
Log Message:
---
convert payment to partitioned tables using rules

Modified Files:
--
pagila:
pagila-schema.sql (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-schema.sql.diff?r1=1.4&r2=1.5)
pagila-data.sql (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-data.sql.diff?r1=1.2&r2=1.3)

---(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] dbsamples - pagila: sequences are now decoupled.

2007-03-29 Thread User Xzilla
Log Message:
---
sequences are now decoupled. update readme with info on constraint_exclusion

Modified Files:
--
pagila:
pagila-data.sql (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-data.sql.diff?r1=1.3&r2=1.4)
README (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/README.diff?r1=1.3&r2=1.4)

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


[COMMITTERS] dbsamples - pagila: dont try to force C locale

2007-03-29 Thread User Xzilla
Log Message:
---
dont try to force C locale

Modified Files:
--
pagila:
pagila-fulltext.sql (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-fulltext.sql.diff?r1=1.1&r2=1.2)

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[COMMITTERS] dbsamples - dbsamples: New Directory

2007-06-11 Thread User Xzilla
Update of /cvsroot/dbsamples/dbsamples/us-state-county-city-zip
In directory pgfoundry.org:/tmp/cvs-serv95260/us-state-county-city-zip

Log Message:
Directory /cvsroot/dbsamples/dbsamples/us-state-county-city-zip added to the 
repository


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


[COMMITTERS] dbsamples - dbsamples: New Directory

2007-06-11 Thread User Xzilla
Update of /cvsroot/dbsamples/dbsamples/us-state-county-city-zip/state_flags
In directory pgfoundry.org:/tmp/cvs-serv95634/state_flags

Log Message:
Directory /cvsroot/dbsamples/dbsamples/us-state-county-city-zip/state_flags 
added to the repository


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


[COMMITTERS] dbsamples - dbsamples: New sample database consisting of U.S.

2007-06-12 Thread User Xzilla
Log Message:
---
New sample database consisting of U.S. state, county, city, and zip 
information. Submitted by David Blewett

Added Files:
---
dbsamples/us-state-county-city-zip:
README (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/README?rev=1.1&content-type=text/x-cvsweb-markup)
us-state-county-city-zip-1.0.sql (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/us-state-county-city-zip-1.0.sql?rev=1.1&content-type=text/x-cvsweb-markup)

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[COMMITTERS] dbsamples - dbsamples: Graphical State Flags for use with U.S.

2007-06-12 Thread User Xzilla
Log Message:
---
Graphical State Flags for use with U.S. state, county, city, zipcode data. See 
README for source information.

Added Files:
---
dbsamples/us-state-county-city-zip/state_flags:
Flag_of_Alabama.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Alabama.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Alaska.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Alaska.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_American_Samoa.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_American_Samoa.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Arizona.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Arizona.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Arkansas.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Arkansas.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_California.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_California.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Colorado.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Colorado.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Connecticut.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Connecticut.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Delaware.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Delaware.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Florida.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Florida.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Georgia_(U.S._state).svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Georgia_(U.S._state).svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Guam.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Guam.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Hawaii.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Hawaii.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Idaho.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Idaho.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Illinois.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Illinois.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Indiana.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Indiana.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Iowa.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Iowa.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Kansas.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Kansas.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Kentucky.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Kentucky.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Louisiana.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Louisiana.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Maine.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Maine.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Maryland.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/state_flags/Flag_of_Maryland.svg?rev=1.1&content-type=text/x-cvsweb-markup)
Flag_of_Massachusetts.svg (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/sta

[COMMITTERS] dbsamples - pagila: Update pagila schema for 8.3.

2007-09-10 Thread User Xzilla
Log Message:
---
Update pagila schema for 8.3. Convert fulltext search to use built in 
functionality. Switch film rating column to use an enum type rather than 
text with constraints.

Modified Files:
--
pagila:
README (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/README.diff?r1=1.4&r2=1.5)
pagila-data.sql (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-data.sql.diff?r1=1.4&r2=1.5)
pagila-schema.sql (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-schema.sql.diff?r1=1.5&r2=1.6)

Removed Files:
-
pagila:
pagila-fulltext.sql

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-fulltext.sql)

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


[COMMITTERS] dbsamples - pagila: remove references to rob role.

2007-09-14 Thread User Xzilla
Log Message:
---
remove references to rob role. per report from ioguix

Modified Files:
--
pagila:
pagila-schema.sql (r1.6 -> r1.7)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-schema.sql.diff?r1=1.6&r2=1.7)

---(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] dbsamples - dbsamples: New Directory

2007-10-04 Thread User Xzilla
Update of /cvsroot/dbsamples/dbsamples/iso-639-3
In directory pgfoundry.org:/tmp/cvs-serv5712/iso-639-3

Log Message:
Directory /cvsroot/dbsamples/dbsamples/iso-639-3 added to the repository


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


[COMMITTERS] dbsamples - dbsamples: ISO-639-3 Language Code Database.

2007-10-04 Thread User Xzilla
Log Message:
---
ISO-639-3 Language Code Database. Based on Sample from David Fetter. See 
http://en.wikipedia.org/wiki/ISO_639-3 for more info.

Added Files:
---
dbsamples/iso-639-3:
README (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/iso-639-3/README?rev=1.1&content-type=text/x-cvsweb-markup)
iso-639-3.sql (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/iso-639-3/iso-639-3.sql?rev=1.1&content-type=text/x-cvsweb-markup)

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


[COMMITTERS] dbsamples - dbsamples: let's install into the db we created for it

2007-10-04 Thread User Xzilla
Log Message:
---
let's install into the db we created for it

Modified Files:
--
dbsamples/us-state-county-city-zip:
README (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/dbsamples/us-state-county-city-zip/README.diff?r1=1.1&r2=1.2)

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


[COMMITTERS] mysqlcompat - mysqlcompat: the 1 and 0 need to be quoted in 8.3, lest

2007-11-09 Thread User Xzilla
Log Message:
---
the 1 and 0 need to be quoted in 8.3, lest they be interpreted as integers by 
replace

Modified Files:
--
mysqlcompat:
string.sql (r1.11 -> r1.12)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/mysqlcompat/mysqlcompat/string.sql.diff?r1=1.11&r2=1.12)

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


[COMMITTERS] mysqlcompat - mysqlcompat: we also need a version for int vars for oct()

2007-11-09 Thread User Xzilla
Log Message:
---
we also need a version for int vars for oct() to work

Modified Files:
--
mysqlcompat:
string.sql (r1.13 -> r1.14)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/mysqlcompat/mysqlcompat/string.sql.diff?r1=1.13&r2=1.14)

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

   http://archives.postgresql.org


[COMMITTERS] mysqlcompat - mysqlcompat: Another 8.3 data type issue...

2007-11-09 Thread User Xzilla
Log Message:
---
Another 8.3 data type issue... using '0' allows comparison 
against int or text, since the type isnt determined until 
compare time.

Modified Files:
--
mysqlcompat:
string.sql (r1.12 -> r1.13)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/mysqlcompat/mysqlcompat/string.sql.diff?r1=1.12&r2=1.13)

---(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] mysqlcompat - mysqlcompat: drop the new conv(i,i,i) version of the

2007-11-11 Thread User Xzilla
Log Message:
---
drop the new conv(i,i,i) version of the function

Modified Files:
--
mysqlcompat:
uninstall.sql (r1.11 -> r1.12)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/mysqlcompat/mysqlcompat/uninstall.sql.diff?r1=1.11&r2=1.12)

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


[COMMITTERS] mysqlcompat - mysqlcompat: i've tested it on 8.2 and 8.3 now

2007-11-11 Thread User Xzilla
Log Message:
---
i've tested it on 8.2 and 8.3 now

Modified Files:
--
mysqlcompat:
README (r1.10 -> r1.11)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/mysqlcompat/mysqlcompat/README.diff?r1=1.10&r2=1.11)

---(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] dbsamples - pagila: update readme for pagila-0.10

2008-01-05 Thread User Xzilla
Log Message:
---
update readme for pagila-0.10

Modified Files:
--
pagila:
README (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/README.diff?r1=1.5&r2=1.6)

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[COMMITTERS] dbsamples - pagila: add data file using insert statements

2008-03-23 Thread User Xzilla
Log Message:
---
add data file using insert statements

Added Files:
---
pagila:
pagila-insert-data.sql (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-insert-data.sql?rev=1.1&content-type=text/x-cvsweb-markup)

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


[COMMITTERS] dbsamples - pagila: add note about pagila-data* files, add articles

2008-03-23 Thread User Xzilla
Log Message:
---
add note about pagila-data* files, add articles section

Modified Files:
--
pagila:
README (r1.6 -> r1.7)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/README.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] dbsamples - pagila: add unique indexes to partitions to match primary

2008-04-23 Thread User Xzilla
Log Message:
---
add unique indexes to partitions to match primary key on parent

Modified Files:
--
pagila:
pagila-schema.sql (r1.7 -> r1.8)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-schema.sql.diff?r1=1.7&r2=1.8)

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


[COMMITTERS] press - pr: attempt to integrate simons changes, with a few modifcation

2005-09-30 Thread User Xzilla
Log Message:
---
attempt to integrate simons changes, with a few modifcation i listed on the list

Modified Files:
--
pr/releases/8.1/en:
release.txt (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/press/pr/releases/8.1/en/release.txt.diff?r1=1.3&r2=1.4)

---(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] press - pr: re-order the three man features to roles -> inout -> 2pc,

2005-09-30 Thread User Xzilla
Log Message:
---
 re-order the three man features to roles -> inout -> 2pc, based on roles being 
something everyone will use, inout being something highly desirable for people 
migrating to pg from oracle/m$/firebird/etc... and 2pc being much more niche 
than the other two (especially given the current xa contreversy).

Modified Files:
--
pr/releases/8.1/en:
release.txt (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/press/pr/releases/8.1/en/release.txt.diff?r1=1.4&r2=1.5)

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


[COMMITTERS] wikipedia - wikipgedia: LocalSettings is generated by the install

2005-10-12 Thread User Xzilla
Log Message:
---
LocalSettings is generated by the install program. the patch file was an after 
effect of developement, remove them and add a cvsignore to prevent 
localsettings from coming back

Added Files:
---
wikipgedia/config:
.cvsignore (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/config/.cvsignore?rev=1.1&content-type=text/x-cvsweb-markup)

Removed Files:
-
wikipgedia/config:
LocalSettings.php

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/config/LocalSettings.php)
index.php.patch

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/config/index.php.patch)

---(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] wikipedia - wikipgedia: Add a plac e for postgresql specific notes.

2005-10-14 Thread User Xzilla
Log Message:
---
Add a plac e for postgresql specific notes.

Added Files:
---
wikipgedia:
README.postgresql (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/README.postgresql?rev=1.1&content-type=text/x-cvsweb-markup)

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


[COMMITTERS] wikipedia - wikipgedia: remove obsolete files

2005-10-18 Thread User Xzilla
Log Message:
---
remove obsolete files

Removed Files:
-
wikipgedia/maintenance/postgresql:
pg_tables.sql

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/maintenance/postgresql/pg_tables.sql)
pg_users.sql

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/maintenance/postgresql/pg_users.sql)

---(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] wikipedia - wikipgedia: cleanup another obsolete file

2005-10-18 Thread User Xzilla
Log Message:
---
cleanup another obsolete file

Removed Files:
-
wikipgedia:
install-utils.inc.patch

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/install-utils.inc.patch)

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


[COMMITTERS] wikipedia - wikipgedia: last of the spurious patch files

2005-10-18 Thread User Xzilla
Log Message:
---
last of the spurious patch files

Removed Files:
-
wikipgedia/maintenance:
tables.sql.patch

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/maintenance/tables.sql.patch)
wikipgedia/maintenance/oracle:
tables.sql.patch

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/maintenance/oracle/tables.sql.patch)

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


[COMMITTERS] wikipedia - wikipgedia: Uber merge of upstream package changes and pg

2005-10-18 Thread User Xzilla
Log Message:
---
Uber merge of upstream package changes and pg specific changes from Denis

Modified Files:
--
wikipgedia:
RELEASE-NOTES (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/RELEASE-NOTES.diff?r1=1.1.1.1&r2=1.2)
UPGRADE (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/UPGRADE.diff?r1=1.1.1.1&r2=1.2)
index.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/index.php.diff?r1=1.1.1.1&r2=1.2)
install-utils.inc (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/install-utils.inc.diff?r1=1.1.1.1&r2=1.2)
wikipgedia/config:
index.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/config/index.php.diff?r1=1.1.1.1&r2=1.2)
wikipgedia/includes:
Article.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/Article.php.diff?r1=1.1.1.1&r2=1.2)
BagOStuff.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/BagOStuff.php.diff?r1=1.1.1.1&r2=1.2)
Database.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/Database.php.diff?r1=1.1.1.1&r2=1.2)
DatabaseOracle.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/DatabaseOracle.php.diff?r1=1.1.1.1&r2=1.2)
DatabasePostgreSQL.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/DatabasePostgreSQL.php.diff?r1=1.1.1.1&r2=1.2)
DefaultSettings.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/DefaultSettings.php.diff?r1=1.1.1.1&r2=1.2)
EditPage.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/EditPage.php.diff?r1=1.1.1.1&r2=1.2)
Export.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/Export.php.diff?r1=1.1.1.1&r2=1.2)
GlobalFunctions.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/GlobalFunctions.php.diff?r1=1.1.1.1&r2=1.2)
Hooks.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/Hooks.php.diff?r1=1.1.1.1&r2=1.2)
Image.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/Image.php.diff?r1=1.1.1.1&r2=1.2)
ImagePage.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/ImagePage.php.diff?r1=1.1.1.1&r2=1.2)
Linker.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/Linker.php.diff?r1=1.1.1.1&r2=1.2)
Math.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/Math.php.diff?r1=1.1.1.1&r2=1.2)
MimeMagic.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/MimeMagic.php.diff?r1=1.1.1.1&r2=1.2)
OutputPage.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/OutputPage.php.diff?r1=1.1.1.1&r2=1.2)
QueryPage.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/QueryPage.php.diff?r1=1.1.1.1&r2=1.2)
Revision.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/Revision.php.diff?r1=1.1.1.1&r2=1.2)
SearchEngine.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/SearchEngine.php.diff?r1=1.1.1.1&r2=1.2)
SearchTsearch2.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/SearchTsearch2.php.diff?r1=1.1.1.1&r2=1.2)
Skin.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/Skin.php.diff?r1=1.1.1.1&r2=1.2)
SkinTemplate.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/SkinTemplate.php.diff?r1=1.1.1.1&r2=1.2)
SpecialAllmessages.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/SpecialAllmessages.php.diff?r1=1.1.1.1&r2=1.2)
SpecialAllpages.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/SpecialAllpages.php.diff?r1=1.1.1.1&r2=1.2)
SpecialAncientpages.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/c

[COMMITTERS] wikipedia - wikipgedia: Update some notes for cvs users

2005-10-27 Thread User Xzilla
Log Message:
---
Update some notes for cvs users

Modified Files:
--
wikipgedia:
README.postgresql (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/README.postgresql.diff?r1=1.1&r2=1.2)

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


[COMMITTERS] wikipedia - wikipgedia: change objectcache back to text.

2005-11-02 Thread User Xzilla
Log Message:
---
change objectcache back to text. this may break some encodings, but makes it 
work for the rest of us for now.

Modified Files:
--
wikipgedia/maintenance/postgresql:
tables.sql (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/maintenance/postgresql/tables.sql.diff?r1=1.2&r2=1.3)

---(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] wikipedia - wikipgedia: add missing tsearch2 based table for schema,

2005-11-02 Thread User Xzilla
Log Message:
---
add missing tsearch2 based table for schema, this gets us back to a basically 
working pg

Modified Files:
--
wikipgedia/maintenance/postgresql:
tables.sql (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/maintenance/postgresql/tables.sql.diff?r1=1.3&r2=1.4)

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

   http://archives.postgresql.org


[COMMITTERS] wikipedia - wikipgedia: Unfortunatly the original porters just decided

2005-11-06 Thread User Xzilla
Log Message:
---
Unfortunatly the original porters just decided to make the errnum
function always return one (since php doesnt provide pg err nums), 
which causes problems because some places check this value to 
determine if an error has occured. Instead make this return conditional
on an actual error having been tossed.

Modified Files:
--
wikipgedia/includes:
DatabasePostgreSQL.php (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/DatabasePostgreSQL.php.diff?r1=1.2&r2=1.3)

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


[COMMITTERS] wikipedia - wikipgedia: port 2 pieces of the upgrade script to pg

2005-11-09 Thread User Xzilla
Log Message:
---
port 2 pieces of the upgrade script to pg comptaible syntax

Modified Files:
--
wikipgedia/maintenance/archives:
patch-trackbacks.sql (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/maintenance/archives/patch-trackbacks.sql.diff?r1=1.1.1.1&r2=1.2)
patch-transcache.sql (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/maintenance/archives/patch-transcache.sql.diff?r1=1.1.1.1&r2=1.2)

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


[COMMITTERS] wikipedia - wikipgedia: BUG#1000415 -- Temporary fix, will discuss a

2005-11-13 Thread User Xzilla
Log Message:
---
BUG#1000415 -- Temporary fix, will discuss a more comprehensive work around for 
next release.

Modified Files:
--
wikipgedia/maintenance/postgresql:
tables.sql (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/maintenance/postgresql/tables.sql.diff?r1=1.4&r2=1.5)

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


[COMMITTERS] wikipedia - wikipgedia: BUG#1000473 - Make the check on rc_timestamp

2005-12-07 Thread User Xzilla
Log Message:
---
BUG#1000473 - Make the check on rc_timestamp conditional to handle when days = 
0.  timestamp = '' is a my$qlism.

Modified Files:
--
wikipgedia/includes:
SpecialWatchlist.php (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/SpecialWatchlist.php.diff?r1=1.2&r2=1.3)

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


[COMMITTERS] wikipedia - wikipgedia: fix the remote code execution vulnerability

2005-12-10 Thread User Xzilla
Log Message:
---
fix the remote code execution vulnerability found in Mediawiki <= 1.5.3.
from the upstream project by way of Sven Klemm

Modified Files:
--
wikipgedia/includes:
Setup.php (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/Setup.php.diff?r1=1.1.1.1&r2=1.2)

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[COMMITTERS] wikipedia - wikipgedia: Add wikipgedia specific information

2005-12-26 Thread User Xzilla
Log Message:
---
Add wikipgedia specific information

Modified Files:
--
wikipgedia:
README.postgresql (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/README.postgresql.diff?r1=1.2&r2=1.3)
RELEASE-NOTES (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/RELEASE-NOTES.diff?r1=1.2&r2=1.3)

---(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] wikipedia - wikipgedia: Update version information to reference

2005-12-26 Thread User Xzilla
Log Message:
---
Update version information to reference wikipgedia rather than mediawiki

Modified Files:
--
wikipgedia/includes:
DefaultSettings.php (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/DefaultSettings.php.diff?r1=1.3&r2=1.4)
SpecialVersion.php (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/wikipedia/wikipgedia/includes/SpecialVersion.php.diff?r1=1.2&r2=1.3)

---(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] 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 import


---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[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 created by this import


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


[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.sql (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-schema.sql?rev=1.1&content-type=text/x-cvsweb-markup)

Removed Files:
-
pagila/pagila:
pagila-data.sql

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila/pagila-data.sql)
pagila-schema.sql

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila/pagila-schema.sql)

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


[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


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


[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)---
TIP 5: don't forget to increase your free space map settings


[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-cvsweb-markup)

---(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] 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)---
TIP 6: explain analyze is your friend


[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&r2=1.3)

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


[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)---
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] dbsamples - pagila: Keep rating as text to show off check constraints

2006-05-23 Thread User Xzilla
Log Message:
---
Keep rating as text to show off check constraints
convert release year to "year" domain to show off domains
convert special features to text[] for array use. 
clean up readme, prepare to tag and package

Modified Files:
--
pagila:
README (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/README.diff?r1=1.2&r2=1.3)
pagila-data.sql (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-data.sql.diff?r1=1.1.1.1&r2=1.2)
pagila-schema.sql (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbsamples/pagila/pagila-schema.sql.diff?r1=1.3&r2=1.4)

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq