Re: psqlexception syntax error at or near "$"

Steven Dahlin  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