new regression data for 7.1

8 files changed, 458 insertions, 407 deletions

diff --git a/src/test/mb/expected/big5.out b/src/test/mb/expected/big5.out
index 14ae2be29a4..8ba6a9a25f8 100644
--- a/src/test/mb/expected/big5.out
+++ b/src/test/mb/expected/big5.out
@@ -1,4 +1,5 @@
 drop table 紅坝戈;
+ERROR:  table "紅坝戈" does not exist
 create table 紅坝戈 (︽穨 text, そ╋繷 varchar,  varchar(16));
 create index 紅坝戈index1 on 紅坝戈 using btree (︽穨);
 create index 紅坝戈index2 on 紅坝戈 using hash (そ╋繷);
@@ -67,15 +68,15 @@ select *, octet_length(︽穨) from 紅坝戈;
 (3 rows)
 
 select *, position('Τ' in そ╋繷) from 紅坝戈;
- ︽穨 |     そ╋繷     |     | strpos 
---------+------------------+---------+--------
- 筿福穨 | 笷笷м         | A01く |      0
- 籹硑穨 | 癩方Τそ     | いB10い |      3
- 繺都穨 | Τそ | 蔼Z01 |      5
+ ︽穨 |     そ╋繷     |     | position 
+--------+------------------+---------+----------
+ 筿福穨 | 笷笷м         | A01く |        0
+ 籹硑穨 | 癩方Τそ     | いB10い |        3
+ 繺都穨 | Τそ | 蔼Z01 |        5
 (3 rows)
 
 select *, substring(そ╋繷 from 3 for 6 ) from 紅坝戈;
- ︽穨 |     そ╋繷     |     |    substr    
+ ︽穨 |     そ╋繷     |     |  substring   
 --------+------------------+---------+--------------
  筿福穨 | 笷笷м         | A01く | м
  籹硑穨 | 癩方Τそ     | いB10い | Τそ
diff --git a/src/test/mb/expected/euc_cn.out b/src/test/mb/expected/euc_cn.out
index 7fdb13cfe5d..8b80d6d5845 100644
--- a/src/test/mb/expected/euc_cn.out
+++ b/src/test/mb/expected/euc_cn.out
@@ -1,87 +1,38 @@
 drop table 计算机术语;
-ERROR:  Relation '计算机术语' does not exist
+ERROR:  parser: parse error at or near "("
 create table 计算机术语(术语 text, 分类号 varchar, 备注1A char(16));
+ERROR:  parser: parse error at or near "("
 create index 计算机术语index1 on 计算机术语 using btree(术语);
+ERROR:  parser: parse error at or near "("
 create index 计算机术语index2 on 计算机术语 using btree(分类号);
+ERROR:  parser: parse error at or near "("
 insert into 计算机术语 values('电脑显示屏','机A01上');
+ERROR:  parser: parse error at or near "("
 insert into 计算机术语 values('电脑图形','分B01中');
+ERROR:  parser: parse error at or near "("
 insert into 计算机术语 values('电脑程序员','人Z01下');
+ERROR:  parser: parse error at or near "("
 vacuum 计算机术语;
+ERROR:  parser: parse error at or near "("
 select * from 计算机术语;
-    术语    | 分类号  | 备注1a 
-------------+---------+--------
- 电脑显示屏 | 机A01上 | 
- 电脑图形   | 分B01中 | 
- 电脑程序员 | 人Z01下 | 
-(3 rows)
-
+ERROR:  parser: parse error at or near "92"
 select * from 计算机术语 where 分类号 = '人Z01下';
-    术语    | 分类号  | 备注1a 
-------------+---------+--------
- 电脑程序员 | 人Z01下 | 
-(1 row)
-
+ERROR:  parser: parse error at or near "92"
 select * from 计算机术语 where 分类号 ~* '人z01下';
-    术语    | 分类号  | 备注1a 
-------------+---------+--------
- 电脑程序员 | 人Z01下 | 
-(1 row)
-
+ERROR:  parser: parse error at or near "92"
 select * from 计算机术语 where 分类号 like '_Z01_';
-    术语    | 分类号  | 备注1a 
-------------+---------+--------
- 电脑程序员 | 人Z01下 | 
-(1 row)
-
+ERROR:  parser: parse error at or near "92"
 select * from 计算机术语 where 分类号 like '_Z%';
-    术语    | 分类号  | 备注1a 
-------------+---------+--------
- 电脑程序员 | 人Z01下 | 
-(1 row)
-
+ERROR:  parser: parse error at or near "92"
 select * from 计算机术语 where 术语 ~ '电脑[显图]';
-    术语    | 分类号  | 备注1a 
-------------+---------+--------
- 电脑显示屏 | 机A01上 | 
- 电脑图形   | 分B01中 | 
-(2 rows)
-
+ERROR:  parser: parse error at or near "92"
 select * from 计算机术语 where 术语 ~* '电脑[显图]';
-    术语    | 分类号  | 备注1a 
-------------+---------+--------
- 电脑显示屏 | 机A01上 | 
- 电脑图形   | 分B01中 | 
-(2 rows)
-
+ERROR:  parser: parse error at or near "92"
 select *,character_length(术语) from 计算机术语;
-    术语    | 分类号  | 备注1a | char_length 
-------------+---------+--------+-------------
- 电脑显示屏 | 机A01上 |        |           5
- 电脑图形   | 分B01中 |        |           4
- 电脑程序员 | 人Z01下 |        |           5
-(3 rows)
-
+ERROR:  parser: parse error at or near "caf5"
 select *,octet_length(术语) from 计算机术语;
-    术语    | 分类号  | 备注1a | octet_length 
-------------+---------+--------+--------------
- 电脑显示屏 | 机A01上 |        |           10
- 电脑图形   | 分B01中 |        |            8
- 电脑程序员 | 人Z01下 |        |           10
-(3 rows)
-
+ERROR:  parser: parse error at or near "caf5"
 select *,position('显' in 术语) from 计算机术语;
-    术语    | 分类号  | 备注1a | strpos 
-------------+---------+--------+--------
- 电脑显示屏 | 机A01上 |        |      3
- 电脑图形   | 分B01中 |        |      0
- 电脑程序员 | 人Z01下 |        |      0
-(3 rows)
-
+ERROR:  parser: parse error at or near "caf5"
 select *,substring(术语 from 3 for 4) from 计算机术语;
-    术语    | 分类号  | 备注1a | substr 
-------------+---------+--------+--------
- 电脑显示屏 | 机A01上 |        | 显示屏
- 电脑图形   | 分B01中 |        | 图形
- 电脑程序员 | 人Z01下 |        | 程序员
-(3 rows)
-
+ERROR:  parser: parse error at or near "caf5"
diff --git a/src/test/mb/expected/euc_jp.out b/src/test/mb/expected/euc_jp.out
index 190f631fe04..0cdf8fede47 100644
--- a/src/test/mb/expected/euc_jp.out
+++ b/src/test/mb/expected/euc_jp.out
@@ -1,5 +1,5 @@
 drop table 纷换怠脱胳;
-ERROR:  Relation '纷换怠脱胳' does not exist
+ERROR:  table "纷换怠脱胳" does not exist
 create table 纷换怠脱胳 (脱胳 text, 尸梧コ〖ド varchar, 洒雇1Aだよ char(16));
 create index 纷换怠脱胳index1 on 纷换怠脱胳 using btree (脱胳);
 create index 纷换怠脱胳index2 on 纷换怠脱胳 using hash (尸梧コ〖ド);
@@ -70,16 +70,16 @@ select *,octet_length(脱胳) from 纷换怠脱胳;
 (3 rows)
 
 select *,position('デ' in 脱胳) from 纷换怠脱胳;
-            脱胳            | 尸梧コ〖ド | 洒雇1aだよ | strpos 
-----------------------------+------------+------------+--------
- コンピュ〖タディスプレイ   | 怠A01惧    |            |      7
- コンピュ〖タグラフィックス | 尸B10面    |            |      0
- コンピュ〖タプログラマ〖   | 客Z01布    |            |      0
+            脱胳            | 尸梧コ〖ド | 洒雇1aだよ | position 
+----------------------------+------------+------------+----------
+ コンピュ〖タディスプレイ   | 怠A01惧    |            |        7
+ コンピュ〖タグラフィックス | 尸B10面    |            |        0
+ コンピュ〖タプログラマ〖   | 客Z01布    |            |        0
 (3 rows)
 
 select *,substring(脱胳 from 10 for 4) from 纷换怠脱胳;
-            脱胳            | 尸梧コ〖ド | 洒雇1aだよ |  substr  
-----------------------------+------------+------------+----------
+            脱胳            | 尸梧コ〖ド | 洒雇1aだよ | substring 
+----------------------------+------------+------------+-----------
  コンピュ〖タディスプレイ   | 怠A01惧    |            | プレイ
  コンピュ〖タグラフィックス | 尸B10面    |            | ィックス
  コンピュ〖タプログラマ〖   | 客Z01布    |            | ラマ〖
diff --git a/src/test/mb/expected/euc_kr.out b/src/test/mb/expected/euc_kr.out
index 368525b220f..85282e627fa 100644
--- a/src/test/mb/expected/euc_kr.out
+++ b/src/test/mb/expected/euc_kr.out
@@ -1,87 +1,38 @@
 drop table 酮擤薛侩绢;
-ERROR:  Relation '酮擤薛侩绢' does not exist
+ERROR:  parser: parse error at or near "("
 create table 酮擤薛侩绢 (侩绢 text, 萋拙内靛 varchar, 厚绊1A扼备 char(16));
+ERROR:  parser: parse error at or near "("
 create index 酮擤薛侩绢index1 on 酮擤薛侩绢 using btree (侩绢);
+ERROR:  parser: parse error at or near "("
 create index 酮擤薛侩绢index2 on 酮擤薛侩绢 using hash (萋拙内靛);
+ERROR:  parser: parse error at or near "("
 insert into 酮擤薛侩绢 values('哪腔磐叼胶敲饭捞', '薛A01呔');
+ERROR:  parser: parse error at or near "("
 insert into 酮擤薛侩绢 values('哪腔磐弊贰侨胶', '萋B10耖');
+ERROR:  parser: parse error at or near "("
 insert into 酮擤薛侩绢 values('哪腔磐橇肺弊贰赣', '煅Z01');
+ERROR:  parser: parse error at or near "("
 vacuum 酮擤薛侩绢;
+ERROR:  parser: parse error at or near "("
 select * from 酮擤薛侩绢;
-       侩绢       | 萋拙内靛 | 厚绊1a扼备 
-------------------+----------+------------
- 哪腔磐叼胶敲饭捞 | 薛A01呔  | 
- 哪腔磐弊贰侨胶   | 萋B10耖  | 
- 哪腔磐橇肺弊贰赣 | 煅Z01  | 
-(3 rows)
-
+ERROR:  parser: parse error at or near "92"
 select * from 酮擤薛侩绢 where 萋拙内靛 = '煅Z01';
-       侩绢       | 萋拙内靛 | 厚绊1a扼备 
-------------------+----------+------------
- 哪腔磐橇肺弊贰赣 | 煅Z01  | 
-(1 row)
-
+ERROR:  parser: parse error at or near "92"
 select * from 酮擤薛侩绢 where 萋拙内靛 ~* '煅z01';
-       侩绢       | 萋拙内靛 | 厚绊1a扼备 
-------------------+----------+------------
- 哪腔磐橇肺弊贰赣 | 煅Z01  | 
-(1 row)
-
+ERROR:  parser: parse error at or near "92"
 select * from 酮擤薛侩绢 where 萋拙内靛 like '_Z01_';
-       侩绢       | 萋拙内靛 | 厚绊1a扼备 
-------------------+----------+------------
- 哪腔磐橇肺弊贰赣 | 煅Z01  | 
-(1 row)
-
+ERROR:  parser: parse error at or near "92"
 select * from 酮擤薛侩绢 where 萋拙内靛 like '_Z%';
-       侩绢       | 萋拙内靛 | 厚绊1a扼备 
-------------------+----------+------------
- 哪腔磐橇肺弊贰赣 | 煅Z01  | 
-(1 row)
-
+ERROR:  parser: parse error at or near "92"
 select * from 酮擤薛侩绢 where 侩绢 ~ '哪腔磐[叼弊]';
-       侩绢       | 萋拙内靛 | 厚绊1a扼备 
-------------------+----------+------------
- 哪腔磐叼胶敲饭捞 | 薛A01呔  | 
- 哪腔磐弊贰侨胶   | 萋B10耖  | 
-(2 rows)
-
+ERROR:  parser: parse error at or near "92"
 select * from 酮擤薛侩绢 where 侩绢 ~* '哪腔磐[叼弊]';
-       侩绢       | 萋拙内靛 | 厚绊1a扼备 
-------------------+----------+------------
- 哪腔磐叼胶敲饭捞 | 薛A01呔  | 
- 哪腔磐弊贰侨胶   | 萋B10耖  | 
-(2 rows)
-
+ERROR:  parser: parse error at or near "92"
 select *,character_length(侩绢) from 酮擤薛侩绢;
-       侩绢       | 萋拙内靛 | 厚绊1a扼备 | char_length 
-------------------+----------+------------+-------------
- 哪腔磐叼胶敲饭捞 | 薛A01呔  |            |           8
- 哪腔磐弊贰侨胶   | 萋B10耖  |            |           7
- 哪腔磐橇肺弊贰赣 | 煅Z01  |            |           8
-(3 rows)
-
+ERROR:  parser: parse error at or near "bfeb"
 select *,octet_length(侩绢) from 酮擤薛侩绢;
-       侩绢       | 萋拙内靛 | 厚绊1a扼备 | octet_length 
-------------------+----------+------------+--------------
- 哪腔磐叼胶敲饭捞 | 薛A01呔  |            |           16
- 哪腔磐弊贰侨胶   | 萋B10耖  |            |           14
- 哪腔磐橇肺弊贰赣 | 煅Z01  |            |           16
-(3 rows)
-
+ERROR:  parser: parse error at or near "bfeb"
 select *,position('叼' in 侩绢) from 酮擤薛侩绢;
-       侩绢       | 萋拙内靛 | 厚绊1a扼备 | strpos 
-------------------+----------+------------+--------
- 哪腔磐叼胶敲饭捞 | 薛A01呔  |            |      4
- 哪腔磐弊贰侨胶   | 萋B10耖  |            |      0
- 哪腔磐橇肺弊贰赣 | 煅Z01  |            |      0
-(3 rows)
-
+ERROR:  parser: parse error at or near "bfeb"
 select *,substring(侩绢 from 3 for 4) from 酮擤薛侩绢;
-       侩绢       | 萋拙内靛 | 厚绊1a扼备 |  substr  
-------------------+----------+------------+----------
- 哪腔磐叼胶敲饭捞 | 薛A01呔  |            | 磐叼胶敲
- 哪腔磐弊贰侨胶   | 萋B10耖  |            | 磐弊贰侨
- 哪腔磐橇肺弊贰赣 | 煅Z01  |            | 磐橇肺弊
-(3 rows)
-
+ERROR:  parser: parse error at or near "bfeb"
diff --git a/src/test/mb/expected/euc_tw.out b/src/test/mb/expected/euc_tw.out
index cf855809ab7..f9629f9f784 100644
--- a/src/test/mb/expected/euc_tw.out
+++ b/src/test/mb/expected/euc_tw.out
@@ -1,85 +1,38 @@
 drop table 燹俑骜砧;
-ERROR:  Relation '燹俑骜砧' does not exist
+ERROR:  parser: parse error at or near "("
 create table 燹俑骜砧 (如淦杀 text, 狞瞥婉螭 varchar, 氢蛇 varchar(16));
+ERROR:  parser: parse error at or near "("
 create index 燹俑骜砧index1 on 燹俑骜砧 using btree (如淦杀);
+ERROR:  parser: parse error at or near "("
 create index 燹俑骜砧index2 on 燹俑骜砧 using hash (狞瞥婉螭);
+ERROR:  parser: parse error at or near "("
 insert into 燹俑骜砧 values ('缳妾淦', '绠绠绎世', '啤A01念');
+ERROR:  parser: parse error at or near "("
 insert into 燹俑骜砧 values ('犒葸淦', '芈溷却宇狞瞥', '你B10你');
+ERROR:  parser: parse error at or near "("
 insert into 燹俑骜砧 values ('螫悖淦', '印汤洗枪却宇狞瞥', '仨Z01摩');
+ERROR:  parser: parse error at or near "("
 vacuum 燹俑骜砧;
+ERROR:  parser: parse error at or near "("
 select * from 燹俑骜砧;
- 如淦杀 |     狞瞥婉螭     |  氢蛇   
---------+------------------+---------
- 缳妾淦 | 绠绠绎世         | 啤A01念
- 犒葸淦 | 芈溷却宇狞瞥     | 你B10你
- 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
-(3 rows)
-
+ERROR:  parser: parse error at or near "92"
 select * from 燹俑骜砧 where 氢蛇 = '仨Z01摩';
- 如淦杀 |     狞瞥婉螭     |  氢蛇   
---------+------------------+---------
- 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
-(1 row)
-
+ERROR:  parser: parse error at or near "92"
 select * from 燹俑骜砧 where 氢蛇 ~* '仨z01摩';
- 如淦杀 |     狞瞥婉螭     |  氢蛇   
---------+------------------+---------
- 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
-(1 row)
-
+ERROR:  parser: parse error at or near "92"
 select * from 燹俑骜砧 where 氢蛇 like '_Z01_';
- 如淦杀 |     狞瞥婉螭     |  氢蛇   
---------+------------------+---------
- 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
-(1 row)
-
+ERROR:  parser: parse error at or near "92"
 select * from 燹俑骜砧 where 氢蛇 like '_Z%';
- 如淦杀 |     狞瞥婉螭     |  氢蛇   
---------+------------------+---------
- 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
-(1 row)
-
+ERROR:  parser: parse error at or near "92"
 select * from 燹俑骜砧 where 狞瞥婉螭 ~ '绠绠绎[凫卮世]';
- 如淦杀 | 狞瞥婉螭 |  氢蛇   
---------+----------+---------
- 缳妾淦 | 绠绠绎世 | 啤A01念
-(1 row)
-
+ERROR:  parser: parse error at or near "92"
 select * from 燹俑骜砧 where 狞瞥婉螭 ~* '绠绠绎[凫卮世]';
- 如淦杀 | 狞瞥婉螭 |  氢蛇   
---------+----------+---------
- 缳妾淦 | 绠绠绎世 | 啤A01念
-(1 row)
-
+ERROR:  parser: parse error at or near "92"
 select *, character_length(如淦杀) from 燹俑骜砧;
- 如淦杀 |     狞瞥婉螭     |  氢蛇   | char_length 
---------+------------------+---------+-------------
- 缳妾淦 | 绠绠绎世         | 啤A01念 |           3
- 犒葸淦 | 芈溷却宇狞瞥     | 你B10你 |           3
- 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩 |           3
-(3 rows)
-
+ERROR:  parser: parse error at or near "c8e7"
 select *, octet_length(如淦杀) from 燹俑骜砧;
- 如淦杀 |     狞瞥婉螭     |  氢蛇   | octet_length 
---------+------------------+---------+--------------
- 缳妾淦 | 绠绠绎世         | 啤A01念 |            6
- 犒葸淦 | 芈溷却宇狞瞥     | 你B10你 |            6
- 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩 |            6
-(3 rows)
-
+ERROR:  parser: parse error at or near "c8e7"
 select *, position('却宇' in 狞瞥婉螭) from 燹俑骜砧;
- 如淦杀 |     狞瞥婉螭     |  氢蛇   | strpos 
---------+------------------+---------+--------
- 缳妾淦 | 绠绠绎世         | 啤A01念 |      0
- 犒葸淦 | 芈溷却宇狞瞥     | 你B10你 |      3
- 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩 |      5
-(3 rows)
-
+ERROR:  parser: parse error at or near "c4fc"
 select *, substring(狞瞥婉螭 from 3 for 6 ) from 燹俑骜砧;
- 如淦杀 |     狞瞥婉螭     |  氢蛇   |    substr    
---------+------------------+---------+--------------
- 缳妾淦 | 绠绠绎世         | 啤A01念 | 绎世
- 犒葸淦 | 芈溷却宇狞瞥     | 你B10你 | 却宇狞瞥
- 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩 | 洗枪却宇狞瞥
-(3 rows)
-
+ERROR:  parser: parse error at or near "c4fc"
diff --git a/src/test/mb/expected/mule_internal.out b/src/test/mb/expected/mule_internal.out
index bfcffc8490a..034701277a7 100644
--- a/src/test/mb/expected/mule_internal.out
+++ b/src/test/mb/expected/mule_internal.out
@@ -1,5 +1,5 @@
 drop table 挿讙换挼脱捀�;
-ERROR:  Relation '挿讙换挼脱捀�' does not exist
+ERROR:  table "挿讙换挼脱捀�" does not exist
 create table 挿讙换挼脱捀� (捦褣胳 text, 捠瑨梧挜硳〖挜� varchar, 捜鲯雇1A挙罀よ char(16));
 create index 挿讙换挼脱捀靑ndex1 on 挿讙换挼脱捀� using btree (捦褣胳);
 create index 挿讙换挼脱捀靑ndex2 on 挿讙换挼脱捀� using hash (捠瑨梧挜硳〖挜�);
@@ -22,71 +22,70 @@ select * from 挿讙换挼脱捀� where 捠瑨梧挜硳〖挜� = '捒蚙01挷�';
 (1 row)
 
 select * from 挿讙换挼脱捀� where 捠瑨梧挜硳〖挜� ~* '捒蛕01挷�';
-                捦褣胳                | 捠瑨梧挜硳〖挜� | 捜鲯雇1a挙罀よ 
---------------------------------------+-----------------+----------------
- 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷�       | 
-(1 row)
+ 捦褣胳 | 捠瑨梧挜硳〖挜� | 捜鲯雇1a挙罀よ 
+--------+-----------------+----------------
+(0 rows)
 
 select * from 挿讙换挼脱捀� where 捠瑨梧挜硳〖挜� like '_Z01_';
-                捦褣胳                | 捠瑨梧挜硳〖挜� | 捜鲯雇1a挙罀よ 
---------------------------------------+-----------------+----------------
- 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷�       | 
-(1 row)
+ 捦褣胳 | 捠瑨梧挜硳〖挜� | 捜鲯雇1a挙罀よ 
+--------+-----------------+----------------
+(0 rows)
 
 select * from 挿讙换挼脱捀� where 捠瑨梧挜硳〖挜� like '_Z%';
-                捦褣胳                | 捠瑨梧挜硳〖挜� | 捜鲯雇1a挙罀よ 
---------------------------------------+-----------------+----------------
- 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖 | 捒蚙01挷�       | 
-(1 row)
+ 捦褣胳 | 捠瑨梧挜硳〖挜� | 捜鲯雇1a挙罀よ 
+--------+-----------------+----------------
+(0 rows)
 
 select * from 挿讙换挼脱捀� where 捦褣胳 ~ '挜硳ン挜話ュ挕紥タ[挜菕グ]';
                  捦褣胳                  | 捠瑨梧挜硳〖挜� | 捜鲯雇1a挙罀よ 
 -----------------------------------------+-----------------+----------------
  挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ    | 挼01捑�       | 
  挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜� | 捠珺10捗�       | 
-(2 rows)
+ 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖    | 捒蚙01挷�       | 
+(3 rows)
 
 select * from 挿讙换挼脱捀� where 捦褣胳 ~* '挜硳ン挜話ュ挕紥タ[挜菕グ]';
                  捦褣胳                  | 捠瑨梧挜硳〖挜� | 捜鲯雇1a挙罀よ 
 -----------------------------------------+-----------------+----------------
  挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ    | 挼01捑�       | 
  挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜� | 捠珺10捗�       | 
-(2 rows)
+ 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖    | 捒蚙01挷�       | 
+(3 rows)
 
 select *,character_length(捦褣胳) from 挿讙换挼脱捀�;
                  捦褣胳                  | 捠瑨梧挜硳〖挜� | 捜鲯雇1a挙罀よ | char_length 
 -----------------------------------------+-----------------+----------------+-------------
- 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ    | 挼01捑�       |                |          12
- 挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜� | 捠珺10捗�       |                |          13
- 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖    | 捒蚙01挷�       |                |          12
+ 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ    | 挼01捑�       |                |          18
+ 挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜� | 捠珺10捗�       |                |          20
+ 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖    | 捒蚙01挷�       |                |          18
 (3 rows)
 
 select *,octet_length(捦褣胳) from 挿讙换挼脱捀�;
                  捦褣胳                  | 捠瑨梧挜硳〖挜� | 捜鲯雇1a挙罀よ | octet_length 
 -----------------------------------------+-----------------+----------------+--------------
- 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ    | 挼01捑�       |                |           36
- 挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜� | 捠珺10捗�       |                |           39
- 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖    | 捒蚙01挷�       |                |           36
+ 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ    | 挼01捑�       |                |           54
+ 挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜� | 捠珺10捗�       |                |           59
+ 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖    | 捒蚙01挷�       |                |           54
 (3 rows)
 
 select *,position('挜�' in 捦褣胳) from 挿讙换挼脱捀�;
-                 捦褣胳                  | 捠瑨梧挜硳〖挜� | 捜鲯雇1a挙罀よ | strpos 
------------------------------------------+-----------------+----------------+--------
- 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ    | 挼01捑�       |                |      7
- 挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜� | 捠珺10捗�       |                |      0
- 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖    | 捒蚙01挷�       |                |      0
+                 捦褣胳                  | 捠瑨梧挜硳〖挜� | 捜鲯雇1a挙罀よ | position 
+-----------------------------------------+-----------------+----------------+----------
+ 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ    | 挼01捑�       |                |        0
+ 挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜� | 捠珺10捗�       |                |        0
+ 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖    | 捒蚙01挷�       |                |        0
 (3 rows)
 
 select *,substring(捦褣胳 from 10 for 4) from 挿讙换挼脱捀�;
-                 捦褣胳                  | 捠瑨梧挜硳〖挜� | 捜鲯雇1a挙罀よ |    substr    
------------------------------------------+-----------------+----------------+--------------
- 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ    | 挼01捑�       |                | 挜讙レ挜�
- 挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜� | 捠珺10捗�       |                | 挜ッ挜瘨ス
- 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖    | 捒蚙01挷�       |                | 挜閽マ挕�
+                 捦褣胳                  | 捠瑨梧挜硳〖挜� | 捜鲯雇1a挙罀よ | substring 
+-----------------------------------------+-----------------+----------------+-----------
+ 挜硳ン挜話ュ挕紥タ挜菕ィ挜箳プ挜鞉イ    | 挼01捑�       |                | 挜菕ィ挜
+ 挜硳ン挜話ュ挕紥タ挜皰ラ挜諕ィ挜脪ク挜� | 捠珺10捗�       |                | 挜皰ラ挜
+ 挜硳ン挜話ュ挕紥タ挜讙ロ挜皰ラ挜迴〖    | 捒蚙01挷�       |                | 挜讙ロ挜
 (3 rows)
 
 drop table 懠茟算懟鷳术懹�;
-ERROR:  Relation '懠茟算懟鷳术懹�' does not exist
+ERROR:  table "懠茟算懟鷳术懹�" does not exist
 create table 懠茟算懟鷳术懹�(懯鯌语 text, 懛謶类懞� varchar, 懕笐注1A char(16));
 create index 懠茟算懟鷳术懹飅ndex1 on 懠茟算懟鷳术懹� using btree(懯鯌语);
 create index 懠茟算懟鷳术懹飅ndex2 on 懠茟算懟鷳术懹� using btree(懛謶类懞�);
@@ -109,71 +108,66 @@ select * from 懠茟算懟鷳术懹� where 懛謶类懞� = '懭薢01懴�';
 (1 row)
 
 select * from 懠茟算懟鷳术懹� where 懛謶类懞� ~* '懭藌01懴�';
-     懯鯌语      | 懛謶类懞� | 懕笐注1a 
------------------+-----------+----------
- 懙鐟脑懗虘序懺� | 懭薢01懴� | 
-(1 row)
+ 懯鯌语 | 懛謶类懞� | 懕笐注1a 
+--------+-----------+----------
+(0 rows)
 
 select * from 懠茟算懟鷳术懹� where 懛謶类懞� like '_Z01_';
-     懯鯌语      | 懛謶类懞� | 懕笐注1a 
------------------+-----------+----------
- 懙鐟脑懗虘序懺� | 懭薢01懴� | 
-(1 row)
+ 懯鯌语 | 懛謶类懞� | 懕笐注1a 
+--------+-----------+----------
+(0 rows)
 
 select * from 懠茟算懟鷳术懹� where 懛謶类懞� like '_Z%';
-     懯鯌语      | 懛謶类懞� | 懕笐注1a 
------------------+-----------+----------
- 懙鐟脑懗虘序懺� | 懭薢01懴� | 
-(1 row)
+ 懯鯌语 | 懛謶类懞� | 懕笐注1a 
+--------+-----------+----------
+(0 rows)
 
 select * from 懠茟算懟鷳术懹� where 懯鯌语 ~ '懙鐟脑[懴詰图]';
      懯鯌语      | 懛謶类懞� | 懕笐注1a 
 -----------------+-----------+----------
  懙鐟脑懴詰示懫� | 懟鶤01懮� | 
- 懙鐟脑懲紤形    | 懛諦01懼� | 
-(2 rows)
+(1 row)
 
 select * from 懠茟算懟鷳术懹� where 懯鯌语 ~* '懙鐟脑[懴詰图]';
      懯鯌语      | 懛謶类懞� | 懕笐注1a 
 -----------------+-----------+----------
  懙鐟脑懴詰示懫� | 懟鶤01懮� | 
- 懙鐟脑懲紤形    | 懛諦01懼� | 
-(2 rows)
+(1 row)
 
 select *,character_length(懯鯌语) from 懠茟算懟鷳术懹�;
      懯鯌语      | 懛謶类懞� | 懕笐注1a | char_length 
 -----------------+-----------+----------+-------------
- 懙鐟脑懴詰示懫� | 懟鶤01懮� |          |           5
- 懙鐟脑懲紤形    | 懛諦01懼� |          |           4
- 懙鐟脑懗虘序懺� | 懭薢01懴� |          |           5
+ 懙鐟脑懴詰示懫� | 懟鶤01懮� |          |           8
+ 懙鐟脑懲紤形    | 懛諦01懼� |          |           6
+ 懙鐟脑懗虘序懺� | 懭薢01懴� |          |           8
 (3 rows)
 
 select *,octet_length(懯鯌语) from 懠茟算懟鷳术懹�;
      懯鯌语      | 懛謶类懞� | 懕笐注1a | octet_length 
 -----------------+-----------+----------+--------------
- 懙鐟脑懴詰示懫� | 懟鶤01懮� |          |           15
- 懙鐟脑懲紤形    | 懛諦01懼� |          |           12
- 懙鐟脑懗虘序懺� | 懭薢01懴� |          |           15
+ 懙鐟脑懴詰示懫� | 懟鶤01懮� |          |           23
+ 懙鐟脑懲紤形    | 懛諦01懼� |          |           18
+ 懙鐟脑懗虘序懺� | 懭薢01懴� |          |           23
 (3 rows)
 
 select *,position('懴�' in 懯鯌语) from 懠茟算懟鷳术懹�;
-     懯鯌语      | 懛謶类懞� | 懕笐注1a | strpos 
------------------+-----------+----------+--------
- 懙鐟脑懴詰示懫� | 懟鶤01懮� |          |      3
- 懙鐟脑懲紤形    | 懛諦01懼� |          |      0
- 懙鐟脑懗虘序懺� | 懭薢01懴� |          |      0
+     懯鯌语      | 懛謶类懞� | 懕笐注1a | position 
+-----------------+-----------+----------+----------
+ 懙鐟脑懴詰示懫� | 懟鶤01懮� |          |        0
+ 懙鐟脑懲紤形    | 懛諦01懼� |          |        0
+ 懙鐟脑懗虘序懺� | 懭薢01懴� |          |        0
 (3 rows)
 
 select *,substring(懯鯌语 from 3 for 4) from 懠茟算懟鷳术懹�;
-     懯鯌语      | 懛謶类懞� | 懕笐注1a |  substr   
+     懯鯌语      | 懛謶类懞� | 懕笐注1a | substring 
 -----------------+-----------+----------+-----------
- 懙鐟脑懴詰示懫� | 懟鶤01懮� |          | 懴詰示懫�
- 懙鐟脑懲紤形    | 懛諦01懼� |          | 懲紤形
- 懙鐟脑懗虘序懺� | 懭薢01懴� |          | 懗虘序懺�
+ 懙鐟脑懴詰示懫� | 懟鶤01懮� |          | 脑懴詰示
+ 懙鐟脑懲紤形    | 懛諦01懼� |          | 脑懲紤形
+ 懙鐟脑懗虘序懺� | 懭薢01懴� |          | 脑懗虘序
 (3 rows)
 
 drop table 撏獡擤撗侩摼�;
-ERROR:  Relation '撏獡擤撗侩摼�' does not exist
+ERROR:  table "撏獡擤撗侩摼�" does not exist
 create table 撏獡擤撗侩摼� (摽霌绢 text, 撦聯拙撃趽靛 varchar, 摵駬绊1A摱髶备 char(16));
 create index 撏獡擤撗侩摼頸ndex1 on 撏獡擤撗侩摼� using btree (摽霌绢);
 create index 撏獡擤撗侩摼頸ndex2 on 撏獡擤撗侩摼� using hash (撦聯拙撃趽靛);
@@ -196,71 +190,64 @@ select * from 撏獡擤撗侩摼� where 撦聯拙撃趽靛 = '撿裐01擓�';
 (1 row)
 
 select * from 撏獡擤撗侩摼� where 撦聯拙撃趽靛 ~* '撿褄01擓�';
-          摽霌绢          | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 
---------------------------+--------------+----------------
- 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓�    | 
-(1 row)
+ 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 
+--------+--------------+----------------
+(0 rows)
 
 select * from 撏獡擤撗侩摼� where 撦聯拙撃趽靛 like '_Z01_';
-          摽霌绢          | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 
---------------------------+--------------+----------------
- 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓�    | 
-(1 row)
+ 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 
+--------+--------------+----------------
+(0 rows)
 
 select * from 撏獡擤撗侩摼� where 撦聯拙撃趽靛 like '_Z%';
-          摽霌绢          | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 
---------------------------+--------------+----------------
- 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓�    | 
-(1 row)
+ 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 
+--------+--------------+----------------
+(0 rows)
 
 select * from 撏獡擤撗侩摼� where 摽霌绢 ~ '撃膿腔撆蚚摰饟弊]';
-          摽霌绢          | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 
---------------------------+--------------+----------------
- 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨�    | 
- 撃膿腔撆蛽弊摲侨摻�    | 撦翨10擇�    | 
-(2 rows)
+ 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 
+--------+--------------+----------------
+(0 rows)
 
 select * from 撏獡擤撗侩摼� where 摽霌绢 ~* '撃膿腔撆蚚摰饟弊]';
-          摽霌绢          | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 
---------------------------+--------------+----------------
- 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨�    | 
- 撃膿腔撆蛽弊摲侨摻�    | 撦翨10擇�    | 
-(2 rows)
+ 摽霌绢 | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 
+--------+--------------+----------------
+(0 rows)
 
 select *,character_length(摽霌绢) from 撏獡擤撗侩摼�;
           摽霌绢          | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 | char_length 
 --------------------------+--------------+----------------+-------------
- 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨�    |                |           8
- 撃膿腔撆蛽弊摲侨摻�    | 撦翨10擇�    |                |           7
- 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓�    |                |           8
+ 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨�    |                |          12
+ 撃膿腔撆蛽弊摲侨摻�    | 撦翨10擇�    |                |          11
+ 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓�    |                |          12
 (3 rows)
 
 select *,octet_length(摽霌绢) from 撏獡擤撗侩摼�;
           摽霌绢          | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 | octet_length 
 --------------------------+--------------+----------------+--------------
- 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨�    |                |           24
- 撃膿腔撆蛽弊摲侨摻�    | 撦翨10擇�    |                |           21
- 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓�    |                |           24
+ 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨�    |                |           36
+ 撃膿腔撆蛽弊摲侨摻�    | 撦翨10擇�    |                |           32
+ 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓�    |                |           36
 (3 rows)
 
 select *,position('摰�' in 摽霌绢) from 撏獡擤撗侩摼�;
-          摽霌绢          | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 | strpos 
---------------------------+--------------+----------------+--------
- 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨�    |                |      4
- 撃膿腔撆蛽弊摲侨摻�    | 撦翨10擇�    |                |      0
- 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓�    |                |      0
+          摽霌绢          | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 | position 
+--------------------------+--------------+----------------+----------
+ 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨�    |                |        0
+ 撃膿腔撆蛽弊摲侨摻�    | 撦翨10擇�    |                |        0
+ 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓�    |                |        0
 (3 rows)
 
 select *,substring(摽霌绢 from 3 for 4) from 撏獡擤撗侩摼�;
-          摽霌绢          | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 |    substr    
---------------------------+--------------+----------------+--------------
- 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨�    |                | 撆蛽叼摻簱敲
- 撃膿腔撆蛽弊摲侨摻�    | 撦翨10擇�    |                | 撆蛽弊摲侨
- 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓�    |                | 撆蛽橇摲螕弊
+          摽霌绢          | 撦聯拙撃趽靛 | 摵駬绊1a摱髶备 | substring 
+--------------------------+--------------+----------------+-----------
+ 撃膿腔撆蛽叼摻簱敲摲箵捞 | 撗01撨�    |                | 腔撆蛽叼
+ 撃膿腔撆蛽弊摲侨摻�    | 撦翨10擇�    |                | 腔撆蛽弊
+ 撃膿腔撆蛽橇摲螕弊摲赣 | 撿裐01擓�    |                | 腔撆蛽橇
 (3 rows)
 
 drop table test;
-ERROR:  Relation 'test' does not exist
+ERROR:  table "test" does not exist
 create table test (t text);
 insert into test values('ENGLISH');
 insert into test values('FRAN伹AIS');
@@ -305,25 +292,25 @@ select *,octet_length(t) from test;
                   t                   | octet_length 
 --------------------------------------+--------------
  ENGLISH                              |            7
- FRAN伹AIS                            |            9
- ESPA佈OL                             |            8
- 佂SLENSKA                            |            9
- ENGLISH FRAN伹AIS ESPA佈OL 佂SLENSKA |           36
+ FRAN伹AIS                            |           10
+ ESPA佈OL                             |            9
+ 佂SLENSKA                            |           10
+ ENGLISH FRAN伹AIS ESPA佈OL 佂SLENSKA |           39
 (5 rows)
 
 select *,position('L' in t) from test;
-                  t                   | strpos 
---------------------------------------+--------
- ENGLISH                              |      4
- FRAN伹AIS                            |      0
- ESPA佈OL                             |      7
- 佂SLENSKA                            |      3
- ENGLISH FRAN伹AIS ESPA佈OL 佂SLENSKA |      4
+                  t                   | position 
+--------------------------------------+----------
+ ENGLISH                              |        4
+ FRAN伹AIS                            |        0
+ ESPA佈OL                             |        7
+ 佂SLENSKA                            |        3
+ ENGLISH FRAN伹AIS ESPA佈OL 佂SLENSKA |        4
 (5 rows)
 
 select *,substring(t from 3 for 4) from test;
-                  t                   | substr 
---------------------------------------+--------
+                  t                   | substring 
+--------------------------------------+-----------
  ENGLISH                              | GLIS
  FRAN伹AIS                            | AN伹A
  ESPA佈OL                             | PA佈O
diff --git a/src/test/mb/expected/sjis.out b/src/test/mb/expected/sjis.out
index 39ae540da4d..2a852086e13 100644
--- a/src/test/mb/expected/sjis.out
+++ b/src/test/mb/expected/sjis.out
@@ -69,16 +69,16 @@ select *,octet_length(梡岅) from 寁嶼婡梡岅;
 (3 rows)
 
 select *,position('僨' in 梡岅) from 寁嶼婡梡岅;
-            梡岅            | 暘椶僐乕僪 | 旛峫1a偩傛 | strpos 
-----------------------------+------------+------------+--------
- 僐儞僺儏乕僞僨傿僗僾儗僀   | 婡A01忋    |            |      7
- 僐儞僺儏乕僞僌儔僼傿僢僋僗 | 暘B10拞    |            |      0
- 僐儞僺儏乕僞僾儘僌儔儅乕   | 恖Z01壓    |            |      0
+            梡岅            | 暘椶僐乕僪 | 旛峫1a偩傛 | position 
+----------------------------+------------+------------+----------
+ 僐儞僺儏乕僞僨傿僗僾儗僀   | 婡A01忋    |            |        7
+ 僐儞僺儏乕僞僌儔僼傿僢僋僗 | 暘B10拞    |            |        0
+ 僐儞僺儏乕僞僾儘僌儔儅乕   | 恖Z01壓    |            |        0
 (3 rows)
 
 select *,substring(梡岅 from 10 for 4) from 寁嶼婡梡岅;
-            梡岅            | 暘椶僐乕僪 | 旛峫1a偩傛 |  substr  
-----------------------------+------------+------------+----------
+            梡岅            | 暘椶僐乕僪 | 旛峫1a偩傛 | substring 
+----------------------------+------------+------------+-----------
  僐儞僺儏乕僞僨傿僗僾儗僀   | 婡A01忋    |            | 僾儗僀
  僐儞僺儏乕僞僌儔僼傿僢僋僗 | 暘B10拞    |            | 傿僢僋僗
  僐儞僺儏乕僞僾儘僌儔儅乕   | 恖Z01壓    |            | 儔儅乕
diff --git a/src/test/mb/expected/unicode.out b/src/test/mb/expected/unicode.out
index df7f5f8306f..71c9e9a4413 100644
--- a/src/test/mb/expected/unicode.out
+++ b/src/test/mb/expected/unicode.out
@@ -1,87 +1,295 @@
 drop table 瑷堢畻姗熺敤瑾�;
-ERROR:  Relation '瑷堢畻姗熺敤瑾�' does not exist
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored
+ERROR:  table "瑷姗瑾" does not exist
 create table 瑷堢畻姗熺敤瑾� (鐢ㄨ獮 text, 鍒嗛銈炽兗銉� varchar, 鍌欒��1A銇犮倛 char(16));
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe582) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x99e8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8083) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe381) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa0e3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8288) EUC_JP to UTF-8. Ignored
+ERROR:  parser: parse error at or near "1"
 create index 瑷堢畻姗熺敤瑾瀒ndex1 on 瑷堢畻姗熺敤瑾� using btree (鐢ㄨ獮);
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e69) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
+ERROR:  parser: parse error at or near "btree"
 create index 瑷堢畻姗熺敤瑾瀒ndex2 on 瑷堢畻姗熺敤瑾� using hash (鍒嗛銈炽兗銉�);
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e69) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8929) EUC_JP to UTF-8. Ignored
+ERROR:  parser: parse error at or near "hash"
 insert into 瑷堢畻姗熺敤瑾� values('銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆','姗烝01涓�');
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x87e3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x82a3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8397) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xace3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x82a4) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9f41) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8a27) EUC_JP to UTF-8. Ignored
+ERROR:  parser: parse error at or near "'"
 insert into 瑷堢畻姗熺敤瑾� values('銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈�','鍒咮10涓�');
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83a9) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x95e3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x82a3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83e3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x82af) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xb927) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8642) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xad27) EUC_JP to UTF-8. Ignored
+ERROR:  parser: parse error at or near "'"
 insert into 瑷堢畻姗熺敤瑾� values('銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗','浜篫01涓�');
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x97e3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83ad) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83a9) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9ee3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xba5a) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8b27) EUC_JP to UTF-8. Ignored
+ERROR:  parser: parse error at or near "'"
 vacuum 瑷堢畻姗熺敤瑾�;
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored
+NOTICE:  Vacuum: table not found
 select * from 瑷堢畻姗熺敤瑾�;
-                 鐢ㄨ獮                  | 鍒嗛銈炽兗銉� | 鍌欒��1a銇犮倛 
------------------------------------------+-----------------+----------------
- 銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆    | 姗烝01涓�       | 
- 銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈� | 鍒咮10涓�       | 
- 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗    | 浜篫01涓�       | 
-(3 rows)
-
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored
+ERROR:  Relation '瑷姗瑾' does not exist
 select * from 瑷堢畻姗熺敤瑾� where 鍒嗛銈炽兗銉� = '浜篫01涓�';
-                鐢ㄨ獮                | 鍒嗛銈炽兗銉� | 鍌欒��1a銇犮倛 
---------------------------------------+-----------------+----------------
- 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗 | 浜篫01涓�       | 
-(1 row)
-
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xba5a) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8b27) EUC_JP to UTF-8. Ignored
+ERROR:  parser: parse error at or near "="
 select * from 瑷堢畻姗熺敤瑾� where 鍒嗛銈炽兗銉� ~* '浜簔01涓�';
-                鐢ㄨ獮                | 鍒嗛銈炽兗銉� | 鍌欒��1a銇犮倛 
---------------------------------------+-----------------+----------------
- 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗 | 浜篫01涓�       | 
-(1 row)
-
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xba7a) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8b27) EUC_JP to UTF-8. Ignored
+ERROR:  parser: parse error at or near "~*"
 select * from 瑷堢畻姗熺敤瑾� where 鍒嗛銈炽兗銉� like '_Z01_';
-                鐢ㄨ獮                | 鍒嗛銈炽兗銉� | 鍌欒��1a銇犮倛 
---------------------------------------+-----------------+----------------
- 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗 | 浜篫01涓�       | 
-(1 row)
-
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored
+ERROR:  parser: parse error at or near "'"
 select * from 瑷堢畻姗熺敤瑾� where 鍒嗛銈炽兗銉� like '_Z%';
-                鐢ㄨ獮                | 鍒嗛銈炽兗銉� | 鍌欒��1a銇犮倛 
---------------------------------------+-----------------+----------------
- 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗 | 浜篫01涓�       | 
-(1 row)
-
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored
+ERROR:  parser: parse error at or near "'"
 select * from 瑷堢畻姗熺敤瑾� where 鐢ㄨ獮 ~ '銈炽兂銉斻儱銉笺偪[銉囥偘]';
-                 鐢ㄨ獮                  | 鍒嗛銈炽兗銉� | 鍌欒��1a銇犮倛 
------------------------------------------+-----------------+----------------
- 銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆    | 姗烝01涓�       | 
- 銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈� | 鍒咮10涓�       | 
-(2 rows)
-
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x87e3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x82b0) EUC_JP to UTF-8. Ignored
+ERROR:  parser: parse error at or near "~"
 select * from 瑷堢畻姗熺敤瑾� where 鐢ㄨ獮 ~* '銈炽兂銉斻儱銉笺偪[銉囥偘]';
-                 鐢ㄨ獮                  | 鍒嗛銈炽兗銉� | 鍌欒��1a銇犮倛 
------------------------------------------+-----------------+----------------
- 銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆    | 姗烝01涓�       | 
- 銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈� | 鍒咮10涓�       | 
-(2 rows)
-
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x87e3) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x82b0) EUC_JP to UTF-8. Ignored
+ERROR:  parser: parse error at or near "~*"
 select *,character_length(鐢ㄨ獮) from 瑷堢畻姗熺敤瑾�;
-                 鐢ㄨ獮                  | 鍒嗛銈炽兗銉� | 鍌欒��1a銇犮倛 | char_length 
------------------------------------------+-----------------+----------------+-------------
- 銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆    | 姗烝01涓�       |                |          12
- 銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈� | 鍒咮10涓�       |                |          13
- 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗    | 浜篫01涓�       |                |          12
-(3 rows)
-
+NOTICE:  local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored
+ERROR:  Relation '瑷姗瑾' does not exist
 select *,octet_length(鐢ㄨ獮) from 瑷堢畻姗熺敤瑾�;
-                 鐢ㄨ獮                  | 鍒嗛銈炽兗銉� | 鍌欒��1a銇犮倛 | octet_length 
------------------------------------------+-----------------+----------------+--------------
- 銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆    | 姗烝01涓�       |                |           36
- 銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈� | 鍒咮10涓�       |                |           39
- 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗    | 浜篫01涓�       |                |           36
-(3 rows)
-
+NOTICE:  local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored
+ERROR:  Relation '瑷姗瑾' does not exist
 select *,position('銉�' in 鐢ㄨ獮) from 瑷堢畻姗熺敤瑾�;
-                 鐢ㄨ獮                  | 鍒嗛銈炽兗銉� | 鍌欒��1a銇犮倛 | strpos 
------------------------------------------+-----------------+----------------+--------
- 銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆    | 姗烝01涓�       |                |      7
- 銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈� | 鍒咮10涓�       |                |      0
- 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗    | 浜篫01涓�       |                |      0
-(3 rows)
-
+NOTICE:  local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x8727) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored
+ERROR:  Unterminated quoted string
 select *,substring(鐢ㄨ獮 from 10 for 4) from 瑷堢畻姗熺敤瑾�;
-                 鐢ㄨ獮                  | 鍒嗛銈炽兗銉� | 鍌欒��1a銇犮倛 |    substr    
------------------------------------------+-----------------+----------------+--------------
- 銈炽兂銉斻儱銉笺偪銉囥偅銈广儣銉偆    | 姗烝01涓�       |                | 銉椼儸銈�
- 銈炽兂銉斻儱銉笺偪銈般儵銉曘偅銉冦偗銈� | 鍒咮10涓�       |                | 銈ｃ儍銈偣
- 銈炽兂銉斻儱銉笺偪銉椼儹銈般儵銉炪兗    | 浜篫01涓�       |                | 銉┿優銉�
-(3 rows)
-
+NOTICE:  local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored
+NOTICE:  local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored
+ERROR:  parser: parse error at or near "from"