Re: bcp.exe Fix Triggers - Mailing list pgsql-sql

From Joe
Subject Re: bcp.exe Fix Triggers
Date
Msg-id 4843E941.30701@freedomcircle.net
Whole thread Raw
In response to bcp.exe Fix Triggers  ("yazicivo" <yazicivo@ttmail.com>)
List 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


pgsql-sql by date:

Previous
From: "yazicivo"
Date:
Subject: bcp.exe Fix Triggers
Next
From: Tom Lane
Date:
Subject: Re: bcp.exe Fix Triggers