[COMMITTERS] pgsql: Fix psql crash while parsing SQL file whose encoding is differen

2012-12-02 Thread Tatsuo Ishii
Fix psql crash while parsing SQL file whose encoding is different from client encoding and the client encoding is not *safe* one. Such an example is, file encoding is UTF-8 and client encoding SJIS. Patch contributed by Jiang Guiqing. Branch -- master Details --- http://git.postgresql.org

[COMMITTERS] pgsql: Fix psql crash while parsing SQL file whose encoding is differen

2012-12-02 Thread Tatsuo Ishii
Fix psql crash while parsing SQL file whose encoding is different from client encoding and the client encoding is not *safe* one. Such an example is, file encoding is UTF-8 and client encoding SJIS. Patch contributed by Jiang Guiqing. Branch -- REL9_1_STABLE Details --- http://git.postgre

[COMMITTERS] pgsql: Fix psql crash while parsing SQL file whose encoding is differen

2012-12-02 Thread Tatsuo Ishii
Fix psql crash while parsing SQL file whose encoding is different from client encoding and the client encoding is not *safe* one. Such an example is, file encoding is UTF-8 and client encoding SJIS. Patch contributed by Jiang Guiqing. Branch -- REL9_0_STABLE Details --- http://git.postgre

[COMMITTERS] pgsql: Fix psql crash while parsing SQL file whose encoding is differen

2012-12-02 Thread Tatsuo Ishii
Fix psql crash while parsing SQL file whose encoding is different from client encoding and the client encoding is not *safe* one. Such an example is, file encoding is UTF-8 and client encoding SJIS. Patch contributed by Jiang Guiqing. Branch -- REL8_4_STABLE Details --- http://git.postgre

[COMMITTERS] pgsql: Fix psql crash while parsing SQL file whose encoding is differen

2012-12-02 Thread Tatsuo Ishii
Fix psql crash while parsing SQL file whose encoding is different from client encoding and the client encoding is not *safe* one. Such an example is, file encoding is UTF-8 and client encoding SJIS. Patch contributed by Jiang Guiqing. Branch -- REL9_2_STABLE Details --- http://git.postgre

[COMMITTERS] pgsql: Fix psql crash while parsing SQL file whose encoding is differen

2012-12-02 Thread Tatsuo Ishii
Fix psql crash while parsing SQL file whose encoding is different from client encoding and the client encoding is not *safe* one. Such an example is, file encoding is UTF-8 and client encoding SJIS. Patch contributed by Jiang Guiqing. Branch -- REL8_3_STABLE Details --- http://git.postgre

[COMMITTERS] pgsql: Clarify operation of online checkpoints.

2012-12-02 Thread Simon Riggs
Clarify operation of online checkpoints. Previous comments left, but were too obscure for such an important aspect of the system. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/9f98704b8229f75fb6ec6e379c23cfea51a8f1e4 Modified Files -- src/backend/access

[COMMITTERS] pgsql: XidEpoch++ if wraparound during checkpoint.

2012-12-02 Thread Simon Riggs
XidEpoch++ if wraparound during checkpoint. If wal_level = hot_standby we update the checkpoint nextxid, though in the case where a wraparound occurred half-way through a checkpoint we would neglect updating the epoch also. Updating the nextxid is arguably the wrong thing to do, but changing that m

[COMMITTERS] pgsql: XidEpoch++ if wraparound during checkpoint.

2012-12-02 Thread Simon Riggs
XidEpoch++ if wraparound during checkpoint. If wal_level = hot_standby we update the checkpoint nextxid, though in the case where a wraparound occurred half-way through a checkpoint we would neglect updating the epoch also. Updating the nextxid is arguably the wrong thing to do, but changing that m

[COMMITTERS] pgsql: XidEpoch++ if wraparound during checkpoint.

2012-12-02 Thread Simon Riggs
XidEpoch++ if wraparound during checkpoint. If wal_level = hot_standby we update the checkpoint nextxid, though in the case where a wraparound occurred half-way through a checkpoint we would neglect updating the epoch also. Updating the nextxid is arguably the wrong thing to do, but changing that m

[COMMITTERS] pgsql: XidEpoch++ if wraparound during checkpoint.

2012-12-02 Thread Simon Riggs
XidEpoch++ if wraparound during checkpoint. If wal_level = hot_standby we update the checkpoint nextxid, though in the case where a wraparound occurred half-way through a checkpoint we would neglect updating the epoch also. Updating the nextxid is arguably the wrong thing to do, but changing that m

[COMMITTERS] pgsql: Rearrange storage of data in xl_running_xacts.

2012-12-02 Thread Simon Riggs
Rearrange storage of data in xl_running_xacts. Previously we stored all xids mixed together. Now we store top-level xids first, followed by all subxids. Also skip logging any subxids if the snapshot is suboverflowed, since there are potentially large numbers of them and they are not useful in that

[COMMITTERS] pgsql: Don't advance checkPoint.nextXid near the end of a checkpoint se

2012-12-02 Thread Tom Lane
Don't advance checkPoint.nextXid near the end of a checkpoint sequence. This reverts commit c11130690d6dca64267201a169cfb38c1adec5ef in favor of actually fixing the problem: namely, that we should never have been modifying the checkpoint record's nextXid at this point to begin with. The nextXid sh

[COMMITTERS] pgsql: Don't advance checkPoint.nextXid near the end of a checkpoint se

2012-12-02 Thread Tom Lane
Don't advance checkPoint.nextXid near the end of a checkpoint sequence. This reverts commit c11130690d6dca64267201a169cfb38c1adec5ef in favor of actually fixing the problem: namely, that we should never have been modifying the checkpoint record's nextXid at this point to begin with. The nextXid sh

[COMMITTERS] pgsql: Don't advance checkPoint.nextXid near the end of a checkpoint se

2012-12-02 Thread Tom Lane
Don't advance checkPoint.nextXid near the end of a checkpoint sequence. This reverts commit c11130690d6dca64267201a169cfb38c1adec5ef in favor of actually fixing the problem: namely, that we should never have been modifying the checkpoint record's nextXid at this point to begin with. The nextXid sh

[COMMITTERS] pgsql: Don't advance checkPoint.nextXid near the end of a checkpoint se

2012-12-02 Thread Tom Lane
Don't advance checkPoint.nextXid near the end of a checkpoint sequence. This reverts commit c11130690d6dca64267201a169cfb38c1adec5ef in favor of actually fixing the problem: namely, that we should never have been modifying the checkpoint record's nextXid at this point to begin with. The nextXid sh

[COMMITTERS] pgsql: Reduce scope of changes for COPY FREEZE.

2012-12-02 Thread Simon Riggs
Reduce scope of changes for COPY FREEZE. Allow support only for freezing tuples by explicit command. Previous coding mistakenly extended slightly beyond what was agreed as correct on -hackers. So essentially a partial revoke of earlier work, leaving just the COPY FREEZE command. Branch -- mast

[COMMITTERS] pgsql: Recommend triggers, not rules, in the CREATE VIEW reference page

2012-12-02 Thread Tom Lane
Recommend triggers, not rules, in the CREATE VIEW reference page. We've generally recommended use of INSTEAD triggers over rules since that feature was added; but this old text in the CREATE VIEW reference page didn't get the memo. Noted by Thomas Kellerer. Branch -- REL9_1_STABLE Details -

[COMMITTERS] pgsql: Recommend triggers, not rules, in the CREATE VIEW reference page

2012-12-02 Thread Tom Lane
Recommend triggers, not rules, in the CREATE VIEW reference page. We've generally recommended use of INSTEAD triggers over rules since that feature was added; but this old text in the CREATE VIEW reference page didn't get the memo. Noted by Thomas Kellerer. Branch -- REL9_2_STABLE Details -

[COMMITTERS] pgsql: Recommend triggers, not rules, in the CREATE VIEW reference page

2012-12-02 Thread Tom Lane
Recommend triggers, not rules, in the CREATE VIEW reference page. We've generally recommended use of INSTEAD triggers over rules since that feature was added; but this old text in the CREATE VIEW reference page didn't get the memo. Noted by Thomas Kellerer. Branch -- master Details ---

[COMMITTERS] pgsql: Update time zone data files to tzdata release 2012j.

2012-12-02 Thread Tom Lane
Update time zone data files to tzdata release 2012j. DST law changes in Cuba, Israel, Jordan, Libya, Palestine, Western Samoa, and portions of Brazil. Branch -- REL8_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/150c26ad57955e008f7db120d24caaef527584c9 Modified Files

[COMMITTERS] pgsql: Update time zone data files to tzdata release 2012j.

2012-12-02 Thread Tom Lane
Update time zone data files to tzdata release 2012j. DST law changes in Cuba, Israel, Jordan, Libya, Palestine, Western Samoa, and portions of Brazil. Branch -- REL8_3_STABLE Details --- http://git.postgresql.org/pg/commitdiff/628a0c7e5e6bb5369eaf99e9759dbfc8be48dc33 Modified Files

[COMMITTERS] pgsql: Update time zone data files to tzdata release 2012j.

2012-12-02 Thread Tom Lane
Update time zone data files to tzdata release 2012j. DST law changes in Cuba, Israel, Jordan, Libya, Palestine, Western Samoa, and portions of Brazil. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/fc75d4f81c1b2f27d1954c4b9aac29370c00a0c8 Modified Files ---

[COMMITTERS] pgsql: Update time zone data files to tzdata release 2012j.

2012-12-02 Thread Tom Lane
Update time zone data files to tzdata release 2012j. DST law changes in Cuba, Israel, Jordan, Libya, Palestine, Western Samoa, and portions of Brazil. Branch -- REL9_0_STABLE Details --- http://git.postgresql.org/pg/commitdiff/194bb37ebac43c5b5782dd32bcf45c64434a172d Modified Files

[COMMITTERS] pgsql: Update time zone data files to tzdata release 2012j.

2012-12-02 Thread Tom Lane
Update time zone data files to tzdata release 2012j. DST law changes in Cuba, Israel, Jordan, Libya, Palestine, Western Samoa, and portions of Brazil. Branch -- REL9_2_STABLE Details --- http://git.postgresql.org/pg/commitdiff/842cb63fd3ca3f5371406b5a1cdffb3a9ec6853a Modified Files

[COMMITTERS] pgsql: Update time zone data files to tzdata release 2012j.

2012-12-02 Thread Tom Lane
Update time zone data files to tzdata release 2012j. DST law changes in Cuba, Israel, Jordan, Libya, Palestine, Western Samoa, and portions of Brazil. Branch -- REL9_1_STABLE Details --- http://git.postgresql.org/pg/commitdiff/31ab8936c770545d6aaa09d348661ce175f9b33d Modified Files

[COMMITTERS] pgsql: Add mode where contrib installcheck runs each module in a separa

2012-12-02 Thread Andrew Dunstan
Add mode where contrib installcheck runs each module in a separately named database. Normally each module is tested in aq database named contrib_regression, which is dropped and recreated at the beginhning of each pg_regress run. This mode, enabled by adding USE_MODULE_DB=1 to the make command li

[COMMITTERS] pgsql: Add mode where contrib installcheck runs each module in a separa

2012-12-02 Thread Andrew Dunstan
Add mode where contrib installcheck runs each module in a separately named database. Normally each module is tested in aq database named contrib_regression, which is dropped and recreated at the beginhning of each pg_regress run. This mode, enabled by adding USE_MODULE_DB=1 to the make command li

[COMMITTERS] pgsql: Add mode where contrib installcheck runs each module in a separa

2012-12-02 Thread Andrew Dunstan
Add mode where contrib installcheck runs each module in a separately named database. Normally each module is tested in aq database named contrib_regression, which is dropped and recreated at the beginhning of each pg_regress run. This mode, enabled by adding USE_MODULE_DB=1 to the make command li

[COMMITTERS] pgsql: Add mode where contrib installcheck runs each module in a separa

2012-12-02 Thread Andrew Dunstan
Add mode where contrib installcheck runs each module in a separately named database. Normally each module is tested in aq database named contrib_regression, which is dropped and recreated at the beginhning of each pg_regress run. This mode, enabled by adding USE_MODULE_DB=1 to the make command li