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

Re: [HACKERS] Implementation of SQLCODE and SQLERRM variables

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, neilc(at)samurai(dot)com,pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] Implementation of SQLCODE and SQLERRM variables
Date: 2005-04-19 14:37:00
Message-ID: 200504191437.j3JEb0G04431@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Pavel Stehule wrote:
> On Tue, 19 Apr 2005, Tom Lane wrote:
> 
> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > > Guys, is this patch ready for application?  I think so, but am not 100%
> > > sure.
> > 
> > I haven't read the code yet, but in any case I still object to choosing
> > Oracle-like names for Oracle-incompatible functionality.  We need to
> > settle on better names.
> > 
> 
> I changed names on SQLSTATE and SQLERRM. The behave our SQLSTATE and db2 
> SQLSTATE is very similar. But Oracle support SQLSTATE too (in ANSI mode). 
> Only Oracle support SQLERRM.
> 
> http://developer.mimer.com/howto/howto_25.htm
> 
> SQLSTATE, a 5-character return value specified by the SQL standard,
> replaced SQLCODE years ago (SQL-92?). Perhaps both Oracle and DB2/2
> have support for it.
> 
> But I didn't find good informations about error trapping in ANSI SQL. All 
> informations are about Oracle or DB2 :-(.

Oh, it sounds like we are OK then with the names you used.

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

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-04-19 14:38:43
Subject: Re: [HACKERS] Implementation of SQLCODE and SQLERRM variables
Previous:From: Bruce MomjianDate: 2005-04-19 14:35:49
Subject: Re: [HACKERS] Implementation of SQLCODE and SQLERRM variables

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-04-19 14:38:43
Subject: Re: [HACKERS] Implementation of SQLCODE and SQLERRM variables
Previous:From: Bruce MomjianDate: 2005-04-19 14:35:49
Subject: Re: [HACKERS] Implementation of SQLCODE and SQLERRM variables

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