Re: Need help (unterminated dollar-quoted string at or near "$$ LANGUAGE plpgsql IMMUTABLE; ") - Mailing list pgsql-novice

From Rob Richardson
Subject Re: Need help (unterminated dollar-quoted string at or near "$$ LANGUAGE plpgsql IMMUTABLE; ")
Date
Msg-id 67D108EDFAD3C148A593E6ED7DCB4BBD1FDC388A@RADCONWIN2K8PDC.radcon.local
Whole thread Raw
In response to Need help (unterminated dollar-quoted string at or near "$$ LANGUAGE plpgsql IMMUTABLE; ")  (Hitesh Varule <hiteshvarule@gmail.com>)
List pgsql-novice

That looks to me like an error from PostgreSQL rather than from InstallShield.

 

When I look at a function that works in my database, I see something like:

CREATE OR REPLACE some_function()

  RETURNS integer AS

$BODY$

Begin

                return 1;

end;

$BODY$

  LANGUAGE 'plpgsql' VOLATILE

  COST 100;

 

So, I suggest putting something between the two dollar signs.  I believe, but I’m not positive, that the text between the dollar signs is merely an identifier.  If you don’t have that identifier, I can imagine PostgreSQL getting confused.

 

Good luck!

 

RobR

 

P.S.  Please keep in mind that this advice may be worth exactly what you have paid for it.

pgsql-novice by date:

Previous
From: Steve Horn
Date:
Subject: Re: Details of Segmentation Fault
Next
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: Need help (unterminated dollar-quoted string at or near "$$ LANGUAGE plpgsql IMMUTABLE; ")