Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.postgresql > #302

Re: User-defined type -- error handling

From Jasen Betts <jasen@xnet.co.nz>
Newsgroups comp.databases.postgresql
Subject Re: User-defined type -- error handling
Date 2012-02-13 09:20 +0000
Organization Dis (not Dat) Organisation
Message-ID <jhakkj$2bn$1@reversiblemaps.ath.cx> (permalink)
References <jh90df$435$1@speranza.aioe.org>

Show all headers | View raw


On 2012-02-12, Don Y <this@isnotme.com> wrote:
> Hi,

> So, I'm trying to figure out what error to throw and how
> PG will react in that event (i.e., just abort the transaction?)

22000 looks like good starting place unless one of the other 22xxx
errors fits better

http://www.postgresql.org/docs/9.1/static/errcodes-appendix.html

yes, it will abort transaction much like "select 1/0;" does.



-- 
⚂⚃ 100% natural

--- Posted via news://freenews.netfront.net/ - Complaints to news@netfront.net ---

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

User-defined type -- error handling Don Y <this@isnotme.com> - 2012-02-12 11:29 -0700
  Re: User-defined type -- error handling Jasen Betts <jasen@xnet.co.nz> - 2012-02-13 09:20 +0000
    Re: User-defined type -- error handling Don Y <this@isnotme.com> - 2012-02-14 20:53 -0700

csiph-web