Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

Next:From: Tom LaneDate: 2008-06-02 13:52:33
Subject: Re: bcp.exe Fix Triggers
Previous:From: yazicivoDate: 2008-06-02 08:25:08
Subject: bcp.exe Fix Triggers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group