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 wrote:
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 string at or near "$$
LANGUAGE plpgsql;" at character 1
Note that this is *not* the script you provided below, as $$ does not
appear in the script you provided. Please provide the full output of
the psql session that shows the error (i.e., statements and error
output).
ERROR: function public.setproposalmoddate() does not exist
This is irrelevant. It's just telling you the trigger can't be created
because the function doesn't exist.
Here is a script that produces the error-
CREATE OR REPLACE FUNCTION setproposalmoddate() RETURNS TRIGGER AS
$mod_date$
BEGIN
NEW.mod_date := now();
RETURN NEW;
END;
$mod_date$ LANGUAGE plpgsql;
Works fine for me:
test=# CREATE OR REPLACE FUNCTION setproposalmoddate() RETURNS TRIGGER
AS $mod_date$
test$# BEGIN
test$# NEW.mod_date := now();
test$# RETURN NEW;
test$# END;
test$# $mod_date$ LANGUAGE plpgsql;
CREATE FUNCTION
test=# select version();
version
----------------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.2.4 on powerpc-apple-darwin8.9.0, compiled by GCC
powerpc-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc.
build 5367)
(1 row)
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
