From: Jan Wieck <JanWieck@Yahoo.com>
To: Yudie@axiontech.com <yudie@axiontech.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: problem with plpgsql trigger function: parse error near ""
Date: Thu, 25 Jul 2002 14:06:22 -0400
Message-ID: <3D403E1E.B9430D68@Yahoo.com> (raw)
References: <00bc01c233ff$8d5489c0$8a01a8c0@yudie>
"Yudie@axiontech.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@Yahoo.com #
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: JanWieck@Yahoo.com, yudie@axiontech.com
Subject: Re: problem with plpgsql trigger function: parse error near ""
In-Reply-To: <3D403E1E.B9430D68@Yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox