[COMMITTERS] pgsql: Remove pg_buffercache_pages.h -- patch from Mark Kirkwood.

2005-04-01 Thread Neil Conway
Log Message:
---
Remove pg_buffercache_pages.h -- patch from Mark Kirkwood.

Modified Files:
--
pgsql/contrib/pg_buffercache:
pg_buffercache_pages.c (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_buffercache/pg_buffercache_pages.c.diff?r1=1.2&r2=1.3)

Removed Files:
-
pgsql/contrib/pg_buffercache:
pg_buffercache_pages.h

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_buffercache/pg_buffercache_pages.h)

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


[COMMITTERS] pgsql: Update pgcvslog examples.

2005-04-01 Thread Bruce Momjian
Log Message:
---
Update pgcvslog examples.

Modified Files:
--
pgsql/src/tools:
pgcvslog (r1.20 -> r1.21)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/tools/pgcvslog.diff?r1=1.20&r2=1.21)

---(end of broadcast)---
TIP 3: 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] pgsql: Fix wrong week returnded by date_trunc('week') for early dates in

2005-04-01 Thread Bruce Momjian
Log Message:
---
Fix wrong week returnded by date_trunc('week') for early dates in
January --- would return wrong year for 2005-01-01 and 2006-01-01.

per report from Robert Creager.

Backpatch to 8.0.X.

Modified Files:
--
pgsql/doc/src/sgml:
func.sgml (r1.243 -> r1.244)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.243&r2=1.244)
pgsql/src/backend/utils/adt:
timestamp.c (r1.117 -> r1.118)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c.diff?r1=1.117&r2=1.118)

---(end of broadcast)---
TIP 3: 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] pgsql: Fix wrong week returnded by date_trunc('week') for early dates in

2005-04-01 Thread Bruce Momjian
Log Message:
---
Fix wrong week returnded by date_trunc('week') for early dates in
January --- would return wrong year for 2005-01-01 and 2006-01-01.

per report from Robert Creager.

Backpatch to 8.0.X.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/doc/src/sgml:
func.sgml (r1.234.4.4 -> r1.234.4.5)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.234.4.4&r2=1.234.4.5)
pgsql/src/backend/utils/adt:
timestamp.c (r1.117 -> r1.117.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c.diff?r1=1.117&r2=1.117.4.1)

---(end of broadcast)---
TIP 3: 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] pgsql: Update pgcvslog examples.

2005-04-01 Thread Bruce Momjian
Log Message:
---
Update pgcvslog examples.

Modified Files:
--
pgsql/src/tools:
pgcvslog (r1.21 -> r1.22)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/tools/pgcvslog.diff?r1=1.21&r2=1.22)

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


[COMMITTERS] pgsql: Backpatch FAQ's to 8.0.X.

2005-04-01 Thread Bruce Momjian
Log Message:
---
Backpatch FAQ's to 8.0.X.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/doc:
FAQ (r1.292.4.10 -> r1.292.4.11)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.292.4.10&r2=1.292.4.11)
FAQ_DEV (r1.81.4.1 -> r1.81.4.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ_DEV.diff?r1=1.81.4.1&r2=1.81.4.2)
pgsql/doc/src/FAQ:
FAQ.html (r1.248.4.11 -> r1.248.4.12)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ.html.diff?r1=1.248.4.11&r2=1.248.4.12)
FAQ_DEV.html (r1.85.4.1 -> r1.85.4.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ_DEV.html.diff?r1=1.85.4.1&r2=1.85.4.2)

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


[COMMITTERS] pgsql: Teach pg_dump about OUT parameters.

2005-04-01 Thread Tom Lane
Log Message:
---
Teach pg_dump about OUT parameters.

Modified Files:
--
pgsql/src/bin/pg_dump:
pg_dump.c (r1.404 -> r1.405)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c.diff?r1=1.404&r2=1.405)

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


[COMMITTERS] pgsql: Minor improvements in the really-pretty-ad-hoc test scripts for

2005-04-01 Thread Tom Lane
Log Message:
---
Minor improvements in the really-pretty-ad-hoc test scripts for the
PL languages.

Modified Files:
--
pgsql/src/pl/plperl/test:
runtest (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plperl/test/runtest.diff?r1=1.1&r2=1.2)
pgsql/src/pl/tcl/test:
runtest (r1.5 -> r1.6)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/tcl/test/runtest.diff?r1=1.5&r2=1.6)
pgsql/src/pl/plpython:
test.sh (r1.5 -> r1.6)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpython/test.sh.diff?r1=1.5&r2=1.6)

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


[COMMITTERS] pgsql: Make plperl work with OUT parameters.

2005-04-01 Thread Tom Lane
Log Message:
---
Make plperl work with OUT parameters.

Modified Files:
--
pgsql/src/pl/plperl:
plperl.c (r1.70 -> r1.71)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plperl/plperl.c.diff?r1=1.70&r2=1.71)
pgsql/src/pl/plperl/test:
test.expected (r1.3 -> r1.4)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plperl/test/test.expected.diff?r1=1.3&r2=1.4)
test_queries.sql (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plperl/test/test_queries.sql.diff?r1=1.2&r2=1.3)

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql: Second try at making examine_variable and friends behave sanely

2005-04-01 Thread Tom Lane
Log Message:
---
Second try at making examine_variable and friends behave sanely in
cases with binary-compatible relabeling.  My first try was implicitly
assuming that all operators scalarineqsel is used for have binary-
compatible datatypes on both sides ... which is very wrong of course.
Per report from Michael Fuhr.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/src/backend/utils/adt:
selfuncs.c (r1.169.4.3 -> r1.169.4.4)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c.diff?r1=1.169.4.3&r2=1.169.4.4)

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


[COMMITTERS] pgsql: Second try at making examine_variable and friends behave sanely

2005-04-01 Thread Tom Lane
Log Message:
---
Second try at making examine_variable and friends behave sanely in
cases with binary-compatible relabeling.  My first try was implicitly
assuming that all operators scalarineqsel is used for have binary-
compatible datatypes on both sides ... which is very wrong of course.
Per report from Michael Fuhr.

Modified Files:
--
pgsql/src/backend/utils/adt:
selfuncs.c (r1.175 -> r1.176)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c.diff?r1=1.175&r2=1.176)

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] newsysviews - newsysview: First cut at tables and table_columns views.

2005-04-01 Thread User Andrewsn
Log Message:
---
First cut at tables and table_columns views.

Added Files:
---
newsysview/sql:
_funcs.sql (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/_funcs.sql?rev=1.1&content-type=text/x-cvsweb-markup)
_typefuncs.sql (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/_typefuncs.sql?rev=1.1&content-type=text/x-cvsweb-markup)
table_columns.sql (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/table_columns.sql?rev=1.1&content-type=text/x-cvsweb-markup)
tables.sql (r1.1)

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

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql: Update release notes for 8.0.2.

2005-04-01 Thread Bruce Momjian
Log Message:
---
Update release notes for 8.0.2.

Modified Files:
--
pgsql/doc/src/sgml:
release.sgml (r1.329 -> r1.330)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release.sgml.diff?r1=1.329&r2=1.330)

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


[COMMITTERS] pgsql: Update release notes for 8.0.2.

2005-04-01 Thread Bruce Momjian
Log Message:
---
Update release notes for 8.0.2.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/doc/src/sgml:
release.sgml (r1.321.4.7 -> r1.321.4.8)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release.sgml.diff?r1=1.321.4.7&r2=1.321.4.8)

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


[COMMITTERS] newsysviews - newsysview: fix estimated_mb for tables with no TOAST.

2005-04-01 Thread User Andrewsn
Log Message:
---
fix estimated_mb for tables with no TOAST.

Modified Files:
--
newsysview/sql:
tables.sql (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/tables.sql.diff?r1=1.1&r2=1.2)

---(end of broadcast)---
TIP 3: 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] pgsql: Fix release not typo.

2005-04-01 Thread Bruce Momjian
Log Message:
---
Fix release not typo.

Modified Files:
--
pgsql/doc/src/sgml:
release.sgml (r1.330 -> r1.331)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release.sgml.diff?r1=1.330&r2=1.331)

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

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


[COMMITTERS] pgsql: Fix release not typo.

2005-04-01 Thread Bruce Momjian
Log Message:
---
Fix release not typo.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/doc/src/sgml:
release.sgml (r1.321.4.8 -> r1.321.4.9)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release.sgml.diff?r1=1.321.4.8&r2=1.321.4.9)

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

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