[COMMITTERS] pgsql: Log a warning instead of shutting down the system if we can't

2009-03-04 Thread Magnus Hagander
Log Message: --- Log a warning instead of shutting down the system if we can't load pg_hba.conf on reload (for example due to a permission error). Selena Deckelmann Modified Files: -- pgsql/src/backend/libpq: hba.c (r1.180 -> r1.181) (http://anoncvs.postgr

[COMMITTERS] pgsql: Don't actively violate the system limit of maximum open files

2009-03-04 Thread Peter Eisentraut
Log Message: --- Don't actively violate the system limit of maximum open files (RLIMIT_NOFILE). This avoids irritating kernel logs (if system overstep violations are enabled) and also the grsecurity alert when starting PostgreSQL. original patch by Jacek Drobiecki References: http://arc

[COMMITTERS] pgsql: Add new SQL:2008 error codes for invalid LIMIT and OFFSET values.

2009-03-04 Thread Peter Eisentraut
Log Message: --- Add new SQL:2008 error codes for invalid LIMIT and OFFSET values. Remove unused nonstandard error code that was perhaps intended for this but never used. Modified Files: -- pgsql/doc/src/sgml: errcodes.sgml (r1.26 -> r1.27) (http://anoncvs

[COMMITTERS] pgsql: Add some sanity checks to CREATE CAST ...

2009-03-04 Thread Heikki Linnakangas
Log Message: --- Add some sanity checks to CREATE CAST ... WITHOUT FUNCTION. Disallow composite, enum and array types, as those are surely not binary-compatible with anything else because of the embedded OIDs. Inspired by bug report by Oleg Serov. Modified Files: -- pgsql/

[COMMITTERS] pgsql: Provide some proper minimal documentation for the pg_dump(all)

2009-03-04 Thread Peter Eisentraut
Log Message: --- Provide some proper minimal documentation for the pg_dump(all) --binary-upgrade option. We don't want to commit to what it does, but hiding it will only cause confusion. Modified Files: -- pgsql/doc/src/sgml/ref: pg_dump.sgml (r1.111 -> r1.112)

[COMMITTERS] pgsql: Clarify to the translator that yyerror() deals with the

2009-03-04 Thread Peter Eisentraut
Log Message: --- Clarify to the translator that yyerror() deals with the translation of "syntax error", not the literal string. I was previously confused on this matter, but I have now verified that everything is translated properly. Modified Files: -- pgsql/src/backend/pa

[COMMITTERS] pgsql: Reload config file in startup process on SIGHUP.

2009-03-04 Thread Heikki Linnakangas
Log Message: --- Reload config file in startup process on SIGHUP. Fujii Masao Modified Files: -- pgsql/src/backend/postmaster: postmaster.c (r1.575 -> r1.576) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/postmaster.c?r1=1.575&r2=1

Re: [COMMITTERS] pgsql: Log a warning instead of shutting down the system if we can't

2009-03-04 Thread Tom Lane
[email protected] (Magnus Hagander) writes: > Log a warning instead of shutting down the system if we can't load > pg_hba.conf on reload (for example due to a permission error). This should be elog(LOG), not elog(WARNING). Compare the treatment of syntax errors within the file.

Re: [COMMITTERS] pgsql: Log a warning instead of shutting down the system if we can't

2009-03-04 Thread Tom Lane
Magnus Hagander writes: > Tom Lane wrote: >> This should be elog(LOG), not elog(WARNING). Compare the treatment >> of syntax errors within the file. > While I can agree that they should be the same, why should they not be > WARNING? Because the postmaster has no client to receive a WARNING, and

Re: [COMMITTERS] pgsql: Log a warning instead of shutting down the system if we can't

2009-03-04 Thread Magnus Hagander
Tom Lane wrote: > [email protected] (Magnus Hagander) writes: >> Log a warning instead of shutting down the system if we can't load >> pg_hba.conf on reload (for example due to a permission error). > > This should be elog(LOG), not elog(WARNING). Compare the treatment > of syntax errors within

[COMMITTERS] pgsql: Change hba load failure message to LOG instead of WARNING.

2009-03-04 Thread Magnus Hagander
Log Message: --- Change hba load failure message to LOG instead of WARNING. Per comment from Tom. Modified Files: -- pgsql/src/backend/libpq: hba.c (r1.181 -> r1.182) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/libpq/hba.c?r1=1.181&r2=1.182

[COMMITTERS] pgsql: Put back our old workaround for machines that declare cbrt() in

2009-03-04 Thread Tom Lane
Log Message: --- Put back our old workaround for machines that declare cbrt() in math.h but fail to provide the function itself. Not sure how we escaped testing anything later than 7.3 on such cases, but they still exist, as per André Volpato's report about AIX 5.3. Modified Files: --

[COMMITTERS] pgsql: Put back our old workaround for machines that declare cbrt() in

2009-03-04 Thread Tom Lane
Log Message: --- Put back our old workaround for machines that declare cbrt() in math.h but fail to provide the function itself. Not sure how we escaped testing anything later than 7.3 on such cases, but they still exist, as per André Volpato's report about AIX 5.3. Tags: REL8_3_STAB

[COMMITTERS] pgsql: Put back our old workaround for machines that declare cbrt() in

2009-03-04 Thread Tom Lane
Log Message: --- Put back our old workaround for machines that declare cbrt() in math.h but fail to provide the function itself. Not sure how we escaped testing anything later than 7.3 on such cases, but they still exist, as per André Volpato's report about AIX 5.3. Tags: REL8_2_STAB

[COMMITTERS] pgsql: Put back our old workaround for machines that declare cbrt() in

2009-03-04 Thread Tom Lane
Log Message: --- Put back our old workaround for machines that declare cbrt() in math.h but fail to provide the function itself. Not sure how we escaped testing anything later than 7.3 on such cases, but they still exist, as per André Volpato's report about AIX 5.3. Tags: REL8_1_STAB

[COMMITTERS] pgsql: Put back our old workaround for machines that declare cbrt() in

2009-03-04 Thread Tom Lane
Log Message: --- Put back our old workaround for machines that declare cbrt() in math.h but fail to provide the function itself. Not sure how we escaped testing anything later than 7.3 on such cases, but they still exist, as per André Volpato's report about AIX 5.3. Tags: REL8_0_STAB

[COMMITTERS] pgsql: Put back our old workaround for machines that declare cbrt() in

2009-03-04 Thread Tom Lane
Log Message: --- Put back our old workaround for machines that declare cbrt() in math.h but fail to provide the function itself. Not sure how we escaped testing anything later than 7.3 on such cases, but they still exist, as per André Volpato's report about AIX 5.3. Tags: REL7_4_STAB