[COMMITTERS] pgsql-server/ /HISTORY oc/src/sgml/release.sgml
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 03:07:00 Modified files: . : HISTORY doc/src/sgml : release.sgml Log message: Restore information schema upgrade instructions of Peter. ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgsql-server/ /Tag: /REL7_4_STABLE /HISTORY oc ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 03:07:47 Modified files: . : Tag: REL7_4_STABLE HISTORY doc/src/sgml : Tag: REL7_4_STABLE release.sgml Log message: Restore information schema upgrade instructions of Peter. ---(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-server/src/interfaces/ecpg ChangeLog pgt ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 11:23:45 Modified files: src/interfaces/ecpg: ChangeLog src/interfaces/ecpg/pgtypeslib: numeric.c src/interfaces/ecpg/preproc: extern.h preproc.y variable.c Log message: - Added just another patch by Dave that fixes a reversed order in variable listing for output variables in cursor definitions - Fixed incorrect if call in long=>numeric conversion. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql-server/src/interfaces/ecpg Tag: REL7_4_S ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 11:31:51 Modified files: src/interfaces/ecpg: Tag: REL7_4_STABLE ChangeLog src/interfaces/ecpg/compatlib: Tag: REL7_4_STABLE Makefile src/interfaces/ecpg/ecpglib: Tag: REL7_4_STABLE Makefile execute.c src/interfaces/ecpg/pgtypeslib: Tag: REL7_4_STABLE Makefile numeric.c src/interfaces/ecpg/preproc: Tag: REL7_4_STABLE Makefile extern.h preproc.y variable.c Log message: Applied all bug fixes from head also to 7.4. Just bugfixes, no new features. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgsql-server/src/backend/optimizer/path allpat ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 13:07:48 Modified files: src/backend/optimizer/path: allpaths.c joinrels.c Log message: Repair planner failure when there are multiple IN clauses, each with a join in its subselect. In this situation we *must* build a bushy plan because there are no valid left-sided or right-sided join trees. Accordingly, hoary sanity check needs an update. Per report from Alessandro Depase. ---(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-server/src/backend/optimizer/path Tag: R ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 13:08:06 Modified files: src/backend/optimizer/path: Tag: REL7_4_STABLE allpaths.c joinrels.c Log message: Repair planner failure when there are multiple IN clauses, each with a join in its subselect. In this situation we *must* build a bushy plan because there are no valid left-sided or right-sided join trees. Accordingly, hoary sanity check needs an update. Per report from Alessandro Depase. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql-server/src/bin Makefile initdb/initdb.c ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 14:44:09 Modified files: src/bin: Makefile src/bin/initdb : initdb.c Removed files: src/bin/pg_id : Makefile pg_id.c Log message: Remove pg_id. ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgsql-server/src/backend/parser parse_coerce.c
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED] 03/12/17 15:49:40
Modified files:
src/backend/parser: parse_coerce.c
Log message:
Reorder tests in parse_coerce so that ANY/ANYELEMENT/ANYARRAY coercion
does not affect UNKNOWN-type literals or Params. This fixes the recent
complaint about count('x') being broken, and improves consistency in
a few other respects too.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql-server/src/backend/parser Tag: REL7_4_ST ...
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED] 03/12/17 15:49:52
Modified files:
src/backend/parser: Tag: REL7_4_STABLE parse_coerce.c
Log message:
Reorder tests in parse_coerce so that ANY/ANYELEMENT/ANYARRAY coercion
does not affect UNKNOWN-type literals or Params. This fixes the recent
complaint about count('x') being broken, and improves consistency in
a few other respects too.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgsql-server/contrib/ltree ltree_io.c
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 16:15:41 Modified files: contrib/ltree : ltree_io.c Log message: Repair badly broken estimation of output buffer size in lquery_out(). ---(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-server/contrib/ltree Tag: REL7_4_STABLE ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 16:15:53 Modified files: contrib/ltree : Tag: REL7_4_STABLE ltree_io.c Log message: Repair badly broken estimation of output buffer size in lquery_out(). ---(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-server/src/backend/utils/adt datetime.c
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 17:45:44 Modified files: src/backend/utils/adt: datetime.c Log message: Fix DecodeInterval to handle '-0.1' sanely, per gripe from Tilo Schwarz. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] pgsql-server/src/backend/utils/adt Tag: REL7_4 ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 17:45:51 Modified files: src/backend/utils/adt: Tag: REL7_4_STABLE datetime.c Log message: Fix DecodeInterval to handle '-0.1' sanely, per gripe from Tilo Schwarz. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pgsql-server/src/backend/catalog information_s ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 18:11:31 Modified files: src/backend/catalog: information_schema.sql Log message: information_schema.constraint_column_usage and key_column_usage should not discriminate against system columns, since we support constraints on system columns, and in fact constraints on OID are moderately useful. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgsql-server/src/backend/catalog Tag: REL7_4_S ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 18:11:42 Modified files: src/backend/catalog: Tag: REL7_4_STABLE information_schema.sql Log message: information_schema.constraint_column_usage and key_column_usage should not discriminate against system columns, since we support constraints on system columns, and in fact constraints on OID are moderately useful. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pgsql-server/src/backend/optimizer/path indxpath.c
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 20:22:12 Modified files: src/backend/optimizer/path: indxpath.c Log message: Be a little smarter in group_clauses_by_indexkey_for_join: detect cases where a joinclause is redundant with a restriction clause. Original coding believed this was impossible and didn't need to be checked for, but that was a thinko ... ---(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-server/src/test/regress/expected rules.out
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 21:48:54 Modified files: src/test/regress/expected: rules.out Log message: Adjust rules output for unknown-vs-any change (affects expected contents of pg_stats view definition). ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[COMMITTERS] pgsql-server/src/test/regress/expected Tag: RE ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 21:48:59 Modified files: src/test/regress/expected: Tag: REL7_4_STABLE rules.out Log message: Adjust rules output for unknown-vs-any change (affects expected contents of pg_stats view definition). ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] pgsql-server/src/backend/optimizer/path costsize.c
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED] 03/12/17 23:46:45
Modified files:
src/backend/optimizer/path: costsize.c
Log message:
Here is the definition of relation_byte_size() in optimizer/path/costsize.c:
--
/*
* relation_byte_size
*Estimate the storage space in bytes for a given number of tuples
*of a given width (size in bytes).
*/
static double
relation_byte_size(double tuples, int width)
{
return tuples * (MAXALIGN(width) + MAXALIGN(sizeof(HeapTupleData)));
}
--
Shouldn't this be HeapTupleHeaderData and not HeapTupleData ?
(Of course, from a costing perspective these shouldn't be very different but
...)
Sailesh Krishnamurthy
---(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-server/doc/src/sgml func.sgml
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/17 23:59:08 Modified files: doc/src/sgml : func.sgml Log message: Please find enclosed a patch exemplifying typical use of the ARE Class-Shorthand Escapes. I believe it will help intrepid regex users. :) David Fetter ---(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
