Re: SYNTAX ERROR at or near SQLSTATE

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: vishal saberwal <vishalsaberwal(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SYNTAX ERROR at or near SQLSTATE
Date: 2006-01-26 23:14:43
Message-ID: 20060126231443.GA99487@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jan 26, 2006 at 03:02:46PM -0800, vishal saberwal wrote:
> When i run it on PostgreSQL8.0.1 (on fedora core 2), i get the error:
>
> dbm=# select * from excpt_test();
> ERROR: syntax error at or near "sqlstate" at character 133

SQLSTATE and SQLERRM are new in 8.1; they're not available in earlier
versions unless you've applied some patch.

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message vishal saberwal 2006-01-26 23:19:41 Re: SYNTAX ERROR at or near SQLSTATE
Previous Message Michael Glaesemann 2006-01-26 23:06:34 Re: Arrays