Re: psqlexception syntax error at or near "$" - Mailing list pgsql-jdbc

Steven Dahlin <pgdb.sldahlin@gmail.com> wrote:

> CREATE OR REPLACE FUNCTION system_info_fnc01() RETURNS trigger AS
> $$

>      raise exception ''System Info record already present'';

> $$

When you use dollar quoting you should not double your apostrophes.

Try:

     raise exception 'System Info record already present';

-Kevin