[COMMITTERS] pgsql: Add "SHIFT_JIS" as an accepted encoding name for locale checking

2013-12-14 Thread Tatsuo Ishii
Add "SHIFT_JIS" as an accepted encoding name for locale checking. When locale is "ja_JP.SJIS", nl_langinfo(CODESET) returns "SHIFT_JIS" on some platforms, at least on RedHat Linux. So the encoding/locale match table (encoding_match_list) needs the entry. Otherwise client encoding is set to SQL_ASC

[COMMITTERS] pgsql: Add "SHIFT_JIS" as an accepted encoding name for locale checking

2013-12-14 Thread Tatsuo Ishii
Add "SHIFT_JIS" as an accepted encoding name for locale checking. When locale is "ja_JP.SJIS", nl_langinfo(CODESET) returns "SHIFT_JIS" on some platforms, at least on RedHat Linux. So the encoding/locale match table (encoding_match_list) needs the entry. Otherwise client encoding is set to SQL_ASC

[COMMITTERS] pgsql: Add "SHIFT_JIS" as an accepted encoding name for locale checking

2013-12-14 Thread Tatsuo Ishii
Add "SHIFT_JIS" as an accepted encoding name for locale checking. When locale is "ja_JP.SJIS", nl_langinfo(CODESET) returns "SHIFT_JIS" on some platforms, at least on RedHat Linux. So the encoding/locale match table (encoding_match_list) needs the entry. Otherwise client encoding is set to SQL_ASC

[COMMITTERS] pgsql: Add "SHIFT_JIS" as an accepted encoding name for locale checking

2013-12-14 Thread Tatsuo Ishii
Add "SHIFT_JIS" as an accepted encoding name for locale checking. When locale is "ja_JP.SJIS", nl_langinfo(CODESET) returns "SHIFT_JIS" on some platforms, at least on RedHat Linux. So the encoding/locale match table (encoding_match_list) needs the entry. Otherwise client encoding is set to SQL_ASC

[COMMITTERS] pgsql: Add "SHIFT_JIS" as an accepted encoding name for locale checking

2013-12-14 Thread Tatsuo Ishii
Add "SHIFT_JIS" as an accepted encoding name for locale checking. When locale is "ja_JP.SJIS", nl_langinfo(CODESET) returns "SHIFT_JIS" on some platforms, at least on RedHat Linux. So the encoding/locale match table (encoding_match_list) needs the entry. Otherwise client encoding is set to SQL_ASC

[COMMITTERS] pgsql: Add "SHIFT_JIS" as an accepted encoding name for locale checking

2013-12-14 Thread Tatsuo Ishii
Add "SHIFT_JIS" as an accepted encoding name for locale checking. When locale is "ja_JP.SJIS", nl_langinfo(CODESET) returns "SHIFT_JIS" on some platforms, at least on RedHat Linux. So the encoding/locale match table (encoding_match_list) needs the entry. Otherwise client encoding is set to SQL_ASC

[COMMITTERS] pgsql: Allow empty target list in SELECT.

2013-12-14 Thread Tom Lane
Allow empty target list in SELECT. This fixes a problem noted as a followup to bug #8648: if a query has a semantically-empty target list, e.g. SELECT * FROM zero_column_table, ruleutils.c will dump it as a syntactically-empty target list, which was not allowed. There doesn't seem to be any relia

[COMMITTERS] pgsql: Fix inherited UPDATE/DELETE with UNION ALL subqueries.

2013-12-14 Thread Tom Lane
Fix inherited UPDATE/DELETE with UNION ALL subqueries. Fix an oversight in commit b3aaf9081a1a95c245fd605dcf02c91b3a5c3a29: we do indeed need to process the planner's append_rel_list when copying RTE subqueries, because if any of them were flattenable UNION ALL subqueries, the append_rel_list show

[COMMITTERS] pgsql: Fix inherited UPDATE/DELETE with UNION ALL subqueries.

2013-12-14 Thread Tom Lane
Fix inherited UPDATE/DELETE with UNION ALL subqueries. Fix an oversight in commit b3aaf9081a1a95c245fd605dcf02c91b3a5c3a29: we do indeed need to process the planner's append_rel_list when copying RTE subqueries, because if any of them were flattenable UNION ALL subqueries, the append_rel_list show

[COMMITTERS] pgsql: Fix inherited UPDATE/DELETE with UNION ALL subqueries.

2013-12-14 Thread Tom Lane
Fix inherited UPDATE/DELETE with UNION ALL subqueries. Fix an oversight in commit b3aaf9081a1a95c245fd605dcf02c91b3a5c3a29: we do indeed need to process the planner's append_rel_list when copying RTE subqueries, because if any of them were flattenable UNION ALL subqueries, the append_rel_list show