大佬教程收集整理的这篇文章主要介绍了PostgreSQL:ERROR,0A000,"cached plan must not change result type",大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
@H_616_15@2013-07-24 15:11:35.895 CST,"db_test",17526,"192.168.100.221:40188",51ed7b10.4476,1555,"BIND",2013-07-23 02:33:52 CST,236/820620,@H_616_15@ERROR,0A000,"cached plan must not change result type@H_616_15@","SELECT pkg_name FROM tbl_test WHERE chAnnel_no = $1 AND store_ID = $2","RevalIDateCachedplan,plancache.c:589","" |
@H_616_15@francs=> create table test_cache (ID int4,name character varying(32));
INSERT 0 3
ID | name
----+------
1 | a
2 | b
3 | c
(3 rows)
|
@H_616_15@francs=> PREPARE SELEct_1 (character varying) AS
PREPARE
ID | name
----+------
1 | a
(1 row)
|
@H_616_15@francs=> \d test_cache
column | Type | ModifIErs
--------+-----------------------+-----------
ID | Integer |
name | character varying(32) |
|
@H_616_15@2013-07-24 15:19:36.139 CST,"francs",23261,"[local]",51ef7f33.5add,1,"EXECUTE",2013-07-24 15:16:03 CST,3/10083,ERROR,"cached plan must not change result type","EXECUTE SELEct_1('a');","psql" |
@H_616_15@francs=> DEALLOCATE SELEct_1;
DEALLOCATE
francs=> PREPARE SELEct_1 (character varying) AS
PREPARE
ID | name
----+------
1 | a
(1 row)
|
以上是大佬教程为你收集整理的PostgreSQL:ERROR,0A000,"cached plan must not change result type"全部内容,希望文章能够帮你解决PostgreSQL:ERROR,0A000,"cached plan must not change result type"所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。