Re: bcp.exe Fix Triggers

From: Joe <dev(at)freedomcircle(dot)net>
To: yazicivo <yazicivo(at)ttmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: bcp.exe Fix Triggers
Date: 2008-06-02 12:36:17
Message-ID: 4843E941.30701@freedomcircle.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

yazicivo wrote:
>
> But executing this procedure fails for some reason I couldn't
> understand.
>
> > SELECT public.create_bcp_fix_triggers('commsrv');
> ERROR: syntax error at or near "AS $"
> LINE 4: RETURNS "trigger" AS $bcp-fix$
> ^
>

Use an underscore (_) instead of a minus (-), i.e., $bcp_fix$.

Joe

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2008-06-02 13:52:33 Re: bcp.exe Fix Triggers
Previous Message yazicivo 2008-06-02 08:25:08 bcp.exe Fix Triggers