错误org.postgresql.util.PSQLException: unterminated dollar quote started at posi表明在使用PostgreSQL数据库时,SQL语句中遇到了一个未正确终止的dollar quote(美元引号)问题。这里的posi可能是一个位置指示,但由于信息不完整,具体的位置可能无法直接确定。
SQL-Error [42601]: Unterminated dollar quote started at position 121 in SQL CREATE OR REPLACE FUNCTION change_logging_trigger() RETURNS trigger LANGUAGE plpgsql SECURITY DEFINER AS $$ BEGIN ... Steps to reproduce, if exist: Create a function and try different...AS $xxxx$variants. DROPSCHEMAIF...
找到了一个解决方案，但我不知道它为什么有效。我猜Spring框架测试环境不支持双美元符号。
Describe the problem you’re observing: Executing a loaded script in SQL-Editor with a couple of statements for creating a new schema. In DBeaver Version 6.2.2 works fine, in 6.2.3 throws error:SQL-Error [42601]: Unterminated dollar quote started at position 121 in SQL CREATE OR...
经过一番谷歌搜索，我发现一个类似的问题How do I create a function in PostgreSQL using evolutions ...