From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | "Yudie(at)axiontech(dot)com" <yudie(at)axiontech(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: problem with plpgsql trigger function: parse error near "" |
Date: | 2002-07-25 18:06:22 |
Message-ID: | 3D403E1E.B9430D68@Yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
"Yudie(at)axiontech(dot)com" wrote:
>
> I just tried the trigger function from:
> http://developer.postgresql.org/docs/postgres/plpgsql-trigger.html
> (You can read the sql command on the bottom of this message.)
There have been issues with carriage-returns in PL/pgSQL. If you
cut'n'pasted that from the HTML into some file or directly into a psql
prompt, you likely got bitten by that.
Try to put the content into a file and make sure that is only has
linefeeds.
vi
<cut'n'paste>
:set notextmode
:wr filename
:q
psql dbname <filename
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | ROUWEZ Stephane | 2002-07-26 11:42:29 | Change size of a field |
Previous Message | Reinoud van Leeuwen | 2002-07-25 17:43:30 | Re: Using Tables from another database. |