[COMMITTERS] pgsql: Add a caveat pointing out that constraint exclusion doesn't work

2007-06-20 Thread Tom Lane
Log Message: --- Add a caveat pointing out that constraint exclusion doesn't work with constraints the planner is unable to disprove, hence simple btree-compatible conditions should be used. We've seen people try to get cute with stuff like date_part(something) = something at least twice n

[COMMITTERS] pgsql: Remove some empty columns from a few system catalog tables in the

2007-06-20 Thread Neil Conway
Log Message: --- Remove some empty columns from a few system catalog tables in the SGML docs. Modified Files: -- pgsql/doc/src/sgml: catalogs.sgml (r2.154 -> r2.155) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/catalogs.sgml.diff?r1=2.154&

[COMMITTERS] pgsql: Restrict deadlock_timeout to the range for which the

2007-06-20 Thread Tom Lane
Log Message: --- Restrict deadlock_timeout to the range for which the implementation actually works sanely, viz not 0 and not more than INT_MAX/1000 (else TimestampTzPlusMilliseconds can overflow). Per discussion with Greg Stark. Since this is a superuser-only setting and there was not pr

[COMMITTERS] pgsql: transformColumnDefinition failed to complain about create table

2007-06-20 Thread Tom Lane
Log Message: --- transformColumnDefinition failed to complain about create table foo (bar int default null default 3); due to not thinking about the special-case handling of DEFAULT NULL. Problem noticed while investigating bug #3396. Tags: REL7_3_STABLE Modified Files: -

[COMMITTERS] pgsql: transformColumnDefinition failed to complain about create table

2007-06-20 Thread Tom Lane
Log Message: --- transformColumnDefinition failed to complain about create table foo (bar int default null default 3); due to not thinking about the special-case handling of DEFAULT NULL. Problem noticed while investigating bug #3396. Tags: REL7_4_STABLE Modified Files: -

[COMMITTERS] pgsql: transformColumnDefinition failed to complain about create table

2007-06-20 Thread Tom Lane
Log Message: --- transformColumnDefinition failed to complain about create table foo (bar int default null default 3); due to not thinking about the special-case handling of DEFAULT NULL. Problem noticed while investigating bug #3396. Tags: REL8_0_STABLE Modified Files: -

[COMMITTERS] pgsql: transformColumnDefinition failed to complain about create table

2007-06-20 Thread Tom Lane
Log Message: --- transformColumnDefinition failed to complain about create table foo (bar int default null default 3); due to not thinking about the special-case handling of DEFAULT NULL. Problem noticed while investigating bug #3396. Tags: REL8_1_STABLE Modified Files: -

[COMMITTERS] pgsql: transformColumnDefinition failed to complain about create table

2007-06-20 Thread Tom Lane
Log Message: --- transformColumnDefinition failed to complain about create table foo (bar int default null default 3); due to not thinking about the special-case handling of DEFAULT NULL. Problem noticed while investigating bug #3396. Modified Files: -- pgsql/src/ba

[COMMITTERS] pgsql: transformColumnDefinition failed to complain about create table

2007-06-20 Thread Tom Lane
Log Message: --- transformColumnDefinition failed to complain about create table foo (bar int default null default 3); due to not thinking about the special-case handling of DEFAULT NULL. Problem noticed while investigating bug #3396. Tags: REL8_2_STABLE Modified Files: -

[COMMITTERS] pgsql: CREATE DOMAIN ...

2007-06-20 Thread Tom Lane
Log Message: --- CREATE DOMAIN ... DEFAULT NULL failed because gram.y special-cases DEFAULT NULL and DefineDomain didn't. Bug goes all the way back to original coding of domains. Per bug #3396 from Sergey Burladyan. Tags: REL7_4_STABLE Modified Files: -- pgsql/src/b

[COMMITTERS] pgsql: CREATE DOMAIN ...

2007-06-20 Thread Tom Lane
Log Message: --- CREATE DOMAIN ... DEFAULT NULL failed because gram.y special-cases DEFAULT NULL and DefineDomain didn't. Bug goes all the way back to original coding of domains. Per bug #3396 from Sergey Burladyan. Tags: REL7_3_STABLE Modified Files: -- pgsql/src/b

[COMMITTERS] pgsql: CREATE DOMAIN ...

2007-06-20 Thread Tom Lane
Log Message: --- CREATE DOMAIN ... DEFAULT NULL failed because gram.y special-cases DEFAULT NULL and DefineDomain didn't. Bug goes all the way back to original coding of domains. Per bug #3396 from Sergey Burladyan. Modified Files: -- pgsql/src/backend/commands: t

[COMMITTERS] pgsql: CREATE DOMAIN ...

2007-06-20 Thread Tom Lane
Log Message: --- CREATE DOMAIN ... DEFAULT NULL failed because gram.y special-cases DEFAULT NULL and DefineDomain didn't. Bug goes all the way back to original coding of domains. Per bug #3396 from Sergey Burladyan. Tags: REL8_0_STABLE Modified Files: -- pgsql/src/b

[COMMITTERS] pgsql: CREATE DOMAIN ...

2007-06-20 Thread Tom Lane
Log Message: --- CREATE DOMAIN ... DEFAULT NULL failed because gram.y special-cases DEFAULT NULL and DefineDomain didn't. Bug goes all the way back to original coding of domains. Per bug #3396 from Sergey Burladyan. Tags: REL8_1_STABLE Modified Files: -- pgsql/src/b

[COMMITTERS] pgsql: CREATE DOMAIN ...

2007-06-20 Thread Tom Lane
Log Message: --- CREATE DOMAIN ... DEFAULT NULL failed because gram.y special-cases DEFAULT NULL and DefineDomain didn't. Bug goes all the way back to original coding of domains. Per bug #3396 from Sergey Burladyan. Tags: REL8_2_STABLE Modified Files: -- pgsql/src/b

[COMMITTERS] pgsql: Quiet warnings about redefined PGPORT macros for MSVC.

2007-06-20 Thread Andrew Dunstan
Log Message: --- Quiet warnings about redefined PGPORT macros for MSVC. Modified Files: -- pgsql/src/tools/msvc: Solution.pm (r1.26 -> r1.27) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/tools/msvc/Solution.pm.diff?r1=1.26&r2=1.27) ---

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/doc/org/pgfoundry/pgunittest/generators/class-use In directory pgfoundry.org:/tmp/cvs-serv31486/doc/org/pgfoundry/pgunittest/generators/class-use Log Message: Directory /cvsroot/pgunittest/pgUnitTest/doc/org/pgfoundry/pgunittest/generators/class-use add

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/usr/scripts In directory pgfoundry.org:/tmp/cvs-serv31486/usr/scripts Log Message: Directory /cvsroot/pgunittest/pgUnitTest/usr/scripts added to the repository ---(end of broadcast)--- TIP 3: Have you checke

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/usr/design/diagrams In directory pgfoundry.org:/tmp/cvs-serv31486/usr/design/diagrams Log Message: Directory /cvsroot/pgunittest/pgUnitTest/usr/design/diagrams added to the repository ---(end of broadcast)-

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/src/org/pgfoundry/pgunittest/generators/dict In directory pgfoundry.org:/tmp/cvs-serv31486/src/org/pgfoundry/pgunittest/generators/dict Log Message: Directory /cvsroot/pgunittest/pgUnitTest/src/org/pgfoundry/pgunittest/generators/dict added to the repos

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/files/rand In directory pgfoundry.org:/tmp/cvs-serv31486/files/rand Log Message: Directory /cvsroot/pgunittest/pgUnitTest/files/rand added to the repository ---(end of broadcast)--- TIP 5: don't forget to in

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/usr/design/pgUnitTest In directory pgfoundry.org:/tmp/cvs-serv31486/usr/design/pgUnitTest Log Message: Directory /cvsroot/pgunittest/pgUnitTest/usr/design/pgUnitTest added to the repository ---(end of broadcast)---

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/usr/schemas In directory pgfoundry.org:/tmp/cvs-serv31486/usr/schemas Log Message: Directory /cvsroot/pgunittest/pgUnitTest/usr/schemas added to the repository ---(end of broadcast)--- TIP 3: Have you checke

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/usr/help In directory pgfoundry.org:/tmp/cvs-serv31486/usr/help Log Message: Directory /cvsroot/pgunittest/pgUnitTest/usr/help added to the repository ---(end of broadcast)--- TIP 5: don't forget to increase

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/usr/design In directory pgfoundry.org:/tmp/cvs-serv31486/usr/design Log Message: Directory /cvsroot/pgunittest/pgUnitTest/usr/design added to the repository ---(end of broadcast)--- TIP 5: don't forget to in

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/files/xml/comparator In directory pgfoundry.org:/tmp/cvs-serv31486/files/xml/comparator Log Message: Directory /cvsroot/pgunittest/pgUnitTest/files/xml/comparator added to the repository ---(end of broadcast)--

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/usr/codestyle In directory pgfoundry.org:/tmp/cvs-serv31486/usr/codestyle Log Message: Directory /cvsroot/pgunittest/pgUnitTest/usr/codestyle added to the repository ---(end of broadcast)--- TIP 7: You can h

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/src/org/pgfoundry/pgunittest/generators In directory pgfoundry.org:/tmp/cvs-serv31486/src/org/pgfoundry/pgunittest/generators Log Message: Directory /cvsroot/pgunittest/pgUnitTest/src/org/pgfoundry/pgunittest/generators added to the repository

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/files/xml In directory pgfoundry.org:/tmp/cvs-serv31486/files/xml Log Message: Directory /cvsroot/pgunittest/pgUnitTest/files/xml added to the repository ---(end of broadcast)--- TIP 6: explain analyze is yo

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/files/dict In directory pgfoundry.org:/tmp/cvs-serv31486/files/dict Log Message: Directory /cvsroot/pgunittest/pgUnitTest/files/dict added to the repository ---(end of broadcast)--- TIP 4: Have you searched

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/usr/help/faq In directory pgfoundry.org:/tmp/cvs-serv31486/usr/help/faq Log Message: Directory /cvsroot/pgunittest/pgUnitTest/usr/help/faq added to the repository ---(end of broadcast)--- TIP 1: if posting/r

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/usr/help/tutorial In directory pgfoundry.org:/tmp/cvs-serv31486/usr/help/tutorial Log Message: Directory /cvsroot/pgunittest/pgUnitTest/usr/help/tutorial added to the repository ---(end of broadcast)--- TIP

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/files/xml/pgunit In directory pgfoundry.org:/tmp/cvs-serv31486/files/xml/pgunit Log Message: Directory /cvsroot/pgunittest/pgUnitTest/files/xml/pgunit added to the repository ---(end of broadcast)--- TIP 4:

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/files/xml/reader In directory pgfoundry.org:/tmp/cvs-serv31486/files/xml/reader Log Message: Directory /cvsroot/pgunittest/pgUnitTest/files/xml/reader added to the repository ---(end of broadcast)--- TIP 6:

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/files/pgu/reader In directory pgfoundry.org:/tmp/cvs-serv31486/files/pgu/reader Log Message: Directory /cvsroot/pgunittest/pgUnitTest/files/pgu/reader added to the repository ---(end of broadcast)--- TIP 6:

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/files/pgu In directory pgfoundry.org:/tmp/cvs-serv31486/files/pgu Log Message: Directory /cvsroot/pgunittest/pgUnitTest/files/pgu added to the repository ---(end of broadcast)--- TIP 1: if posting/reading th

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/doc/org/pgfoundry/pgunittest/generators In directory pgfoundry.org:/tmp/cvs-serv31486/doc/org/pgfoundry/pgunittest/generators Log Message: Directory /cvsroot/pgunittest/pgUnitTest/doc/org/pgfoundry/pgunittest/generators added to the repository

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/files In directory pgfoundry.org:/tmp/cvs-serv31486/files Log Message: Directory /cvsroot/pgunittest/pgUnitTest/files added to the repository ---(end of broadcast)--- TIP 5: don't forget to increase your fre

[COMMITTERS] pgunittest - GeneratorParser:

2007-06-20 Thread User Pgunittest
Log Message: --- Modified Files: -- GeneratorParser/doc: Generators.html (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/GeneratorParser/doc/Generators.html.diff?r1=1.2&r2=1.3) overview-tree.html (r1.2 -> r1.3) (http

[COMMITTERS] pgunittest - GeneratorParser: New Directory

2007-06-20 Thread User Pgunittest
Update of /cvsroot/pgunittest/GeneratorParser/dictionaries In directory pgfoundry.org:/tmp/cvs-serv4279/dictionaries Log Message: Directory /cvsroot/pgunittest/GeneratorParser/dictionaries added to the repository ---(end of broadcast)--- TIP 7: Yo