Re: Wrong SQLSTATE returned?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Babak Asadi <basadi(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Wrong SQLSTATE returned?
Date: 2005-06-05 03:58:17
Message-ID: 566.1117943897@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Babak Asadi <basadi(at)gmail(dot)com> writes:
> I'm using ADO to connect to my PostgreSQL instance. When I use a
> SELECT statement that references a non-existent column in an existing
> table I get a SQLSTATE error S1000 code with native error code 7.

> Am I not supposed to get a SQLSTATE code of: 42703 UNDEFINED COLUMN?

Well, there is certainly no part of the Postgres code that will return
'S1000', so I have to suppose that ADO is inserting that SQLSTATE value.
You'd probably best ask about this on an ADO list ...

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message John DeSoi 2005-06-05 14:39:04 Re: Auto Increment Questions
Previous Message Michael Avila 2005-06-04 22:54:58 Install Errors