Search Postgresql Archives

Re: create function error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux