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


Groups > comp.databases.postgresql > #302

Re: User-defined type -- error handling

Path csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!news.netfront.net!reversiblemaps.ath.cx!not-for-mail
From Jasen Betts <jasen@xnet.co.nz>
Newsgroups comp.databases.postgresql
Subject Re: User-defined type -- error handling
Date 13 Feb 2012 09:20:19 GMT
Organization Dis (not Dat) Organisation
Lines 19
Message-ID <jhakkj$2bn$1@reversiblemaps.ath.cx> (permalink)
References <jh90df$435$1@speranza.aioe.org>
NNTP-Posting-Host 118.90.28.7
Mime-Version 1.0
Content-Type text/plain; charset=UTF-8
Content-Transfer-Encoding 8bit
X-Trace adenine.netfront.net 1329163272 9562 118.90.28.7 (13 Feb 2012 20:01:12 GMT)
X-Complaints-To news@netfront.net
NNTP-Posting-Date Mon, 13 Feb 2012 20:01:12 +0000 (UTC)
X-Face ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s;a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W;(T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q;8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^
User-Agent slrn/pre1.0.0-18 (Linux)
Xref x330-a1.tempe.blueboxinc.net comp.databases.postgresql:302

Show key headers only | 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