Sorry, received information I wasn't aware of. My understanding was
this was all running on the db server, but the script was actually being
executed through another server (web) that only had a 7.4 client. This
appears to have been the problem. Thanks.
Tony Crisera
Michael Glaesemann
On Jul 26, 2007, at 13:22 , Tony Crisera wrote:
ERROR: unterminated dollar-quoted string at or near "$$
BEGIN
NEW.mod_date := now();" at character 63
ERROR: syntax error at or near "RETURN" at character 9
WARNING: there is no transaction in progress
ERROR: unterminated dollar-quoted stri
We have gotten these errors every time we try to create a function
through psql. However, if we run the same statements using phpPgAdmin
or pgAdmin III query tool it works fine.
Here's the error-
ERROR: unterminated dollar-quoted string at or near "$$
BEGIN
NEW.mod_date := now();" at charac
You need to create the plpgsql language in your database first. See
http://www.faqs.org/docs/ppbook/c19610.htm for how to do this.
Hope this helps,
[EMAIL PROTECTED]
[EMAIL PROTECTED] ("Thomas LeBlanc") wrote in message news:<[EMAIL PROTECTED]>...
> I copied an example from the help:
>
> CREATE
