Message-ID: <7738.125.24.3.239.1136521196.squirrel@webmail.xs4all.nl>
In-Reply-To: <20060106040158.GA81499@winnie.fuhr.org>
References: <43BDC8B4.6020801@sduept.com>
	<20060106021149.GA80657@winnie.fuhr.org> <43BDD2B7.2090609@sduept.com>
	<20060106040158.GA81499@winnie.fuhr.org>
Date: Fri, 6 Jan 2006 11:19:56 +0700 (ICT)
Subject: Re: [C API] Is there a nice way to get table/column 
From: "Jeroen T. Vermeulen" <jtv@xs4all.nl>
To: "Michael Fuhr" <mike@fuhr.org>
Cc: "JiangWei" <jw.pgsql@sduept.com>, pgsql-interfaces@postgresql.org
User-Agent: SquirrelMail/1.4.5
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit

On Fri, January 6, 2006 11:01, Michael Fuhr wrote:
> On Fri, Jan 06, 2006 at 10:15:19AM +0800, JiangWei wrote:

>>  No.  I want to throw a exception with  the column name, like this :
>>  if (sqlstate == undefined_column)
>>    throw UnknownProperty(column_name);
>
> I'm not aware of a way to get just the column name, so if nobody
> else posts a way then you might have to parse the error message
> (admittedly a pain, especially if you have to deal with different
> languages).

Well, assuming your program has a hand in constructing the queries and
therefore understands their structure, you could have a pretty good stab
at finding out.

Just query the system catalog to find the invalid column name.  It'd be
slow, but exceptions are presumably rare so the cost may be acceptable. 
(BTW apparently you're using C++, not C, so why are you using the C API?)


Jeroen