Fix errcontext() function
От | Chen Huajun |
---|---|
Тема | Fix errcontext() function |
Дата | |
Msg-id | 509B4A5E.7010307@cn.fujitsu.com обсуждение исходный текст |
Ответы |
Re: Fix errcontext() function
|
Список | pgsql-hackers |
Hello, I am sending patch for errcontext() function. I use procedural languages to do some operation, but when error occurs ,the CONTEXT error messages from procedural languages doesn't display in local language. for example: -------------------------------------------------------- postgres=# CREATE OR REPLACE FUNCTION logfunc3 (logtxt text) RETURNS timestamp AS $$ postgres$# BEGIN postgres$# select * from db; postgres$# RETURN 'now'; postgres$# END; postgres$# $$ LANGUAGE plpgsql; CREATE FUNCTION postgres=# select logfunc3('test'); ERROR: リレーション"db"は存在しません 行 1: select * from db QUERY: select * from db CONTEXT: PL/pgSQL function "logfunc3" line 3 at SQL ステートメント -------------------------------------------------------- but,“CONTEXT: PL/pgSQL 関数 "logfunc3" の 3 行目の型 SQL ステートメント” is my expected. There is the same problem in pl/perl and pl/python . After checking and debuging the source code ,I found the reason. The reason is that domian setted is wrong. For PL/pgSQL, domain "pgsql" should be setted, but domain setted is "postgres". So I considered to fix the bug by updating errcontext() funtion. The patched portion is at src/include/utils/elog.h and src/backend/utils/error/elog.c I invite any ideas how to improve this patch. Best Regards Huajun Chen
Вложения
В списке pgsql-hackers по дате отправления: