连接pgsql 报函数table_msg不存错误是因为table_msg函数需要用户自己定义

执行以下sql：

CREATE OR REPLACE FUNCTION pgsql_type(a_type varchar) RETURNS varchar AS  
$BODY$  
DECLARE  
     v_type varchar;  
BEGIN  
     IF a_type='int8' THEN  
          v_type:='bigint';  
     ELSIF a_type='int4' THEN  
          v_type:='integer';  
     ELSIF a_type='int2' THEN  
          v_type:='smallint';  
     ELSIF a_type='bpchar' THEN  
          v_type:='char';  
          v_type:=a_type;  
     END IF;  
     RETURN v_type;  
END;  
$BODY$  
LANGUAGE PLPGSQL;  
CREATE TYPE "public"."tablestruct" AS (  
  "fields_key_name" varchar(100),  
  "fields_name" VARCHAR(200),  
  "fields_type" VARCHAR(20),  
  "fields_length" BIGINT,  
  "fields_not_null" VARCHAR(10),  
  "fields_default" VARCHAR(500),  
  "fields_comment" VARCHAR(1000)  
CREATE OR REPLACE FUNCTION "public"."table_msg" (a_schema_name varchar, a_table_name varchar) RETURNS SETOF "public"."tablestruct" AS  
$body$  
DECLARE  
     v_ret tablestruct;  
     v_oid oid;  
     v_sql varchar;  
     v_rec RECORD;  
     v_key varchar;  
BEGIN  
     SELECT  
           pg_class.oid  INTO v_oid  
           pg_class  
           INNER JOIN pg_namespace ON (pg_class.relnamespace = pg_namespace.oid AND lower(pg_namespace.nspname) = a_schema_name)  
     WHERE  
           pg_class.relname=a_table_name;  
     IF NOT FOUND THEN  
         RETURN;  
     END IF;  
     v_sql='  
     SELECT  
           pg_attribute.attname AS fields_name,  
           pg_attribute.attnum AS fields_index,  
           pgsql_type(pg_type.typname::varchar) AS fields_type,  
           pg_attribute.atttypmod-4 as fields_length,  
           CASE WHEN pg_attribute.attnotnull  THEN ''not null''  
           ELSE ''''  
           END AS fields_not_null,  
           pg_attrdef.adsrc AS fields_default,  
           pg_description.description AS fields_comment  
           pg_attribute  
           INNER JOIN pg_class  ON pg_attribute.attrelid = pg_class.oid  
           INNER JOIN pg_type   ON pg_attribute.atttypid = pg_type.oid  
           LEFT OUTER JOIN pg_attrdef ON pg_attrdef.adrelid = pg_class.oid AND pg_attrdef.adnum = pg_attribute.attnum  
           LEFT OUTER JOIN pg_description ON pg_description.objoid = pg_class.oid AND pg_description.objsubid = pg_attribute.attnum  
     WHERE  
           pg_attribute.attnum > 0  
           AND attisdropped <> ''t''  
           AND pg_class.oid = ' || v_oid || '  
     ORDER BY pg_attribute.attnum' ;  
     FOR v_rec IN EXECUTE v_sql LOOP  
         v_ret.fields_name=v_rec.fields_name;  
         v_ret.fields_type=v_rec.fields_type;  
         IF v_rec.fields_length > 0 THEN  
            v_ret.fields_length:=v_rec.fields_length;  
            v_ret.fields_length:=NULL;  
         END IF;  
         v_ret.fields_not_null=v_rec.fields_not_null;  
         v_ret.fields_default=v_rec.fields_default;  
         v_ret.fields_comment=v_rec.fields_comment;  
         SELECT constraint_name INTO v_key FROM information_schema.key_column_usage WHERE table_schema=a_schema_name AND table_name=a_table_name AND column_name=v_rec.fields_name;  
         IF FOUND THEN  
            v_ret.fields_key_name=v_key;  
            v_ret.fields_key_name='';  
         END IF;  
         RETURN NEXT v_ret;  
     END LOOP;  
     RETURN ;  
END;  
$body$  
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;  
COMMENT ON FUNCTION "public"."table_msg"(a_schema_name varchar, a_table_name varchar)  
IS '获得表信息';  
---重载一个函数  
CREATE OR REPLACE FUNCTION "public"."table_msg" (a_table_name varchar) RETURNS SETOF "public"."tablestruct" AS  
$body$  
DECLARE  
    v_ret tablestruct;  
BEGIN  
    FOR v_ret IN SELECT * FROM table_msg('public',a_table_name) LOOP  
        RETURN NEXT v_ret;  
    END LOOP;  
    RETURN;  
END;  
$body$  
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;  
COMMENT ON FUNCTION "public"."table_msg"(a_table_name varchar)  
IS '获得表信息'; 
                    连接pgsql 报函数table_msg不存错误是因为table_msg函数需要用户自己定义执行以下sql：CREATE OR REPLACE FUNCTION pgsql_type(a_type varchar) RETURNS varchar AS  $BODY$  DECLARE       v_type varchar;  BEGIN       IF a_type='int8' THEN            v_type:='bigint';       ELSIF a_typ
这个Ansible角色在Debian（9，10）或RHEL（7，8）环境中安装PostgreSQL（9.6到12）服务器。
这些说明将为您提供Ansible剧本角色的副本。 一旦启动，它将在Debian或RHEL系统中安装服务器。
已安装Ansible> = 2.9.xx版本。 库存目的地应为Debian或RHEL环境。
 出于测试目的，使用Docker作为驱动程序的Molecule 。 推荐使用Pipenv 2018.11.26和Python 3。
创建或添加到您的角色依赖文件中（例如，requirements.yml）： 
 - src: idealista.postgresql_role
  version: 1.4.0
  name: postgresql
使用ansible-galaxy命令安装角色： 
应用框架：thinkphp5
开发环境：phpStudy 2018
瀚高数据库：hgdb5.6.4-enterprise-windows2012-x86-64-20190614.zip
应用和瀚高数据库适配，出现下面错误信息：
SQLSTATE[42883]: Undefined function: 7
[ info ] [ DB ] INIT pgsql
[ error ] [10501]SQLSTATE[42883]: Undefined function: 7 错误:  函数 table_msg(unknown) 不存在
LINE 1: ...fault as "default",fields_default as "extra" from table_m
				
第二次遇到这个问题了,花了很长时间才搞定,记不住.好记性不如烂笔头,特此记录.
42883: function test(ioid => bigint,idescribe => text) does not exist
发生这个错误的原因是创建函数后,PostgreSQL将函数名和参数名自动转换为小写.当Npgsql调用这个函数时,函数名不区分大小写,但是参数名区分大小写.
--函数...
[ info ] [ DB ] INIT pgsql
[ error ] [10501]SQLSTATE[42883]: Undefined function: 7 错误:  函数 table_msg(unknown) 不存在
LINE 1: ...fault as "default",fields_default as "extra" from table_msg(......
出现异常:WARN: SQL Error: 1146, SQLState: 42S02
异常原因:实体与映射文件的id的主键自增长策略冲突,实体中是String id;映射文件中用的自增长策略为identity
解决方案:将主键自增长策略改为uuid或将String改为Inte
				
错误[42883]：operator does not exist:character varying = integer
修复建议：no operator matches the given name and argument type(s). You might need to add explicit type casts.
错误原因:  字段是字符串类型，sql查询时却用int型表示。
例如：表结构
create table user(
	id int,
	name varcher,
	age ar
字符串你想不想知道像这样 的写法，还有哪些类型名称可以写？
见 https://www.postgresql.org/docs/current/datatype.html
DBeave
[ info ] [ DB ] INIT pgsql
[ error ] [10501]SQLSTATE[42883]: Undefined function: 7 错误:  函数 table_msg(unknown) 不存在
LINE 1: ...fault as "default",fields_default as "extra" from table_msg(...
				
–VS 后端调用 PostgreSql 出错:
ERROR: 42883: operator does not exist: integer ~~ unknown
利用断点发现数据库语句查询正确，但是数据库 NpgsqlConnection 类型的conn.Close();走不进去
postgresql传入参数类型不匹配的原因
–什么是postgresql传入参数类型不匹配
原先定义Mo...
				
引用\[1\]中提到，如果重启服务出现错误"Failed to restart postgresql.service: Unit not found."，可以尝试运行以下命令来解决问题：
1. 运行命令：sudo systemctl restart postgresql
这个命令会尝试重启PostgreSQL服务。
引用\[3\]中提到，如果异常操作导致一些进程状态不对，也可能导致"Failed to restart postgresql.service: Unit not found."的错误。在这种情况下，你可以尝试以下步骤：
1. 进入postgresql\data目录。
2. 运行命令：pg_resetxlog
这个命令会清空数据并重置日志文件。
3. 如果问题仍然存在，你可以手动杀掉所有的pg进程。但是在进行这个操作之前，请确保你已经做好了数据保护的工作。
希望这些方法能够帮助你解决"Failed to restart postgresql.service: Unit not found."的问题。
#### 引用[.reference_title]
-  *1* [linux 在线安装postgresql](https://blog.csdn.net/weixin_43632687/article/details/103186810)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
-  *2* [Redirecting to /bin/systemctl restart mysql.service Failed to restart mysql.service: Unit](https://blog.csdn.net/qq_40597668/article/details/124591439)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
-  *3* [Postgresql数据库报错Failed to restart postgresql-9.2.24.service: Unit not found.](https://blog.csdn.net/mqingo/article/details/86496536)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]