错误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...
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 ...