Обсуждение: BUG #1572: plpgsql in linux os

The following bug has been logged online:

Bug reference:      1572
Logged by:          rajkumar
Email address:      rajkumar8787@yahoo.co.in
PostgreSQL version: 8.0.1
Operating system:   linux
Description:        plpgsql  in linux os
Details:

hello,

we have a postgres in windows and linux operating systems, then the problem
is in plpgsql functions, which is i created a function with exception
handling in postgres 8.0.1 (windows operating system) which handle the
exceptions very well, but i created the same function in (postgres
8.0.1)linux operating system, it gives a syntax error near the exception,
so please tell me, how can i resolve this problem.

with regards,
rajkumar

rajkumar wrote:
>
> The following bug has been logged online:
>
> Bug reference:      1572
> Logged by:          rajkumar
> Email address:      rajkumar8787@yahoo.co.in
> PostgreSQL version: 8.0.1
> Operating system:   linux
> Description:        plpgsql  in linux os
> Details:
>
> hello,
>
> we have a postgres in windows and linux operating systems, then the problem
> is in plpgsql functions, which is i created a function with exception
> handling in postgres 8.0.1 (windows operating system) which handle the
> exceptions very well, but i created the same function in (postgres
> 8.0.1)linux operating system, it gives a syntax error near the exception,
> so please tell me, how can i resolve this problem.

I can't imagine why that would happen.  Can you show us the function?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073