[COMMITTERS] pgsql: Repair CLUSTER failure after ALTER TABLE SET WITHOUT OIDS.

2005-02-06 Thread Tom Lane
Log Message:
---
Repair CLUSTER failure after ALTER TABLE SET WITHOUT OIDS.  Turns out
there are corner cases involving dropping toasted columns in which the
previous coding would fail, too: the new version of the table might not
have any TOAST table, but we'd still propagate possibly-wide values of
dropped columns forward.

Modified Files:
--
pgsql/src/backend/commands:
cluster.c (r1.131 -> r1.132)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/cluster.c.diff?r1=1.131&r2=1.132)

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


[COMMITTERS] pgsql: Repair CLUSTER failure after ALTER TABLE SET WITHOUT OIDS.

2005-02-06 Thread Tom Lane
Log Message:
---
Repair CLUSTER failure after ALTER TABLE SET WITHOUT OIDS.  Turns out
there are corner cases involving dropping toasted columns in which the
previous coding would fail, too: the new version of the table might not
have any TOAST table, but we'd still propagate possibly-wide values of
dropped columns forward.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/src/backend/commands:
cluster.c (r1.131 -> r1.131.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/cluster.c.diff?r1=1.131&r2=1.131.4.1)

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


[COMMITTERS] pgsql: Back-port heap_deformtuple() into 7.4 branch; needed for planned

2005-02-06 Thread Tom Lane
Log Message:
---
Back-port heap_deformtuple() into 7.4 branch; needed for planned fix for
CLUSTER failure after ALTER TABLE SET WITHOUT OIDS.

Tags:

REL7_4_STABLE

Modified Files:
--
pgsql/src/include/access:
heapam.h (r1.85 -> r1.85.2.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/heapam.h.diff?r1=1.85&r2=1.85.2.1)
pgsql/src/backend/access/common:
heaptuple.c (r1.87 -> r1.87.2.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/common/heaptuple.c.diff?r1=1.87&r2=1.87.2.1)

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


[COMMITTERS] pgsql: Repair CLUSTER failure after ALTER TABLE SET WITHOUT OIDS.

2005-02-06 Thread Tom Lane
Log Message:
---
Repair CLUSTER failure after ALTER TABLE SET WITHOUT OIDS.  Turns out
there are corner cases involving dropping toasted columns in which the
previous coding would fail, too: the new version of the table might not
have any TOAST table, but we'd still propagate possibly-wide values of
dropped columns forward.

Tags:

REL7_4_STABLE

Modified Files:
--
pgsql/src/backend/commands:
cluster.c (r1.116.2.1 -> r1.116.2.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/cluster.c.diff?r1=1.116.2.1&r2=1.116.2.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: Document array behavior for out-of-range subscripts.

2005-02-06 Thread Tom Lane
Log Message:
---
Document array behavior for out-of-range subscripts.

Modified Files:
--
pgsql/doc/src/sgml:
array.sgml (r1.42 -> r1.43)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/array.sgml.diff?r1=1.42&r2=1.43)

---(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: Document array behavior for out-of-range subscripts.

2005-02-06 Thread Tom Lane
Log Message:
---
Document array behavior for out-of-range subscripts.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/doc/src/sgml:
array.sgml (r1.42 -> r1.42.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/array.sgml.diff?r1=1.42&r2=1.42.4.1)

---(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: Better late than never: document that the GiST API changed in 8.0

2005-02-06 Thread Neil Conway
Log Message:
---
Better late than never: document that the GiST API changed in 8.0 in the
"incompatibilities" section of the release notes.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/doc/src/sgml:
release.sgml (r1.321.4.5 -> r1.321.4.6)

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

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

   http://archives.postgresql.org


[COMMITTERS] pgsql: Better late than never: document that the GiST API changed in 8.0

2005-02-06 Thread Neil Conway
Log Message:
---
Better late than never: document that the GiST API changed in 8.0 in the
"incompatibilities" section of the release notes.

Modified Files:
--
pgsql/doc/src/sgml:
release.sgml (r1.326 -> r1.327)

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

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


[COMMITTERS] pgsql: Prevent 4 more buffer overruns in the PL/PgSQL parser.

2005-02-06 Thread Neil Conway
Log Message:
---
Prevent 4 more buffer overruns in the PL/PgSQL parser. This is just a
minimally-invasive fix for stable branches; a cleaner fix will be
committed to HEAD soon.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/src/pl/plpgsql/src:
gram.y (r1.64.4.1 -> r1.64.4.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/gram.y.diff?r1=1.64.4.1&r2=1.64.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: Prevent 4 more buffer overruns in the PL/PgSQL parser.

2005-02-06 Thread Neil Conway
Log Message:
---
Prevent 4 more buffer overruns in the PL/PgSQL parser. This is just a
minimally-invasive fix for stable branches; a cleaner fix will be
committed to HEAD soon.

Tags:

REL7_4_STABLE

Modified Files:
--
pgsql/src/pl/plpgsql/src:
gram.y (r1.48.2.1 -> r1.48.2.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/gram.y.diff?r1=1.48.2.1&r2=1.48.2.2)

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