tag:blogger.com,1999:blog-8839574367290288724.post2927167910621944593..comments2023-12-11T13:13:11.330-08:00Comments on Pavel Stehule's blog: plpgsql_check 0.9Pavel Stěhulehttp://www.blogger.com/profile/01996484227228696817noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-8839574367290288724.post-27979893510617106012014-08-20T06:23:04.037-07:002014-08-20T06:23:04.037-07:00Thank you, I saw that in the readme and didn't...Thank you, I saw that in the readme and didn't understand what it was for and didn't put 2 and 2 together!<br /><br />Thank you for this valuable extension.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8839574367290288724.post-36022811567134161672014-08-20T06:11:58.220-07:002014-08-20T06:11:58.220-07:00@Anonymous - it is ugly, but expected - there is d...@Anonymous - it is ugly, but expected - there is dependency to external library - plpgsql, and this use case is not supported perfectly. <br /><br />you should to explicitly load plpgsql library first - or just call any plpgsql function:<br /><br />omega=# create extension plpgsql_check ;<br />ERROR: could not load library "/usr/local/pgsql/lib/plpgsql_check.so": /usr/local/pgsql/lib/plpgsql_check.so: undefined symbol: plpgsql_parser_setup<br />omega=# load 'plpgsql';<br />LOAD<br />omega=# create extension plpgsql_check ;<br />CREATE EXTENSION<br />omega=# <br />Pavel Stěhulehttps://www.blogger.com/profile/01996484227228696817noreply@blogger.comtag:blogger.com,1999:blog-8839574367290288724.post-64269130856135360702014-08-20T06:05:26.730-07:002014-08-20T06:05:26.730-07:00after installing I am getting this:
=#create exte...after installing I am getting this:<br /><br />=#create extension plpgsql_check;<br /><br />ERROR: could not load library "/usr/pgsql-9.3/lib/plpgsql_check.so": /usr/pgsql-9.3/lib/plpgsql_check.so: undefined symbol: plpgsql_parser_setup<br /><br />I grabbed the zip from github, any thoughts? thanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8839574367290288724.post-12274029733918491172014-08-18T02:45:25.224-07:002014-08-18T02:45:25.224-07:00fixed in code - thank youfixed in code - thank youPavel Stěhulehttps://www.blogger.com/profile/01996484227228696817noreply@blogger.comtag:blogger.com,1999:blog-8839574367290288724.post-83737006089365970422014-08-18T01:55:57.114-07:002014-08-18T01:55:57.114-07:00"target variable has different type then expr..."target variable has different type then expression result"<br /><br />then -> than<br />Anonymousnoreply@blogger.com