X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C53E752AC5 for ; Thu, 21 Jul 2005 11:35:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75877-09 for ; Thu, 21 Jul 2005 14:35:24 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 3389252BB4 for ; Thu, 21 Jul 2005 11:35:23 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j6LEZQ0v019903; Thu, 21 Jul 2005 10:35:26 -0400 (EDT) To: Erik Wasser Cc: pgsql-sql@postgresql.org Subject: Re: Can SELECT statements throw an error In-reply-to: <200507211620.37120.erik.wasser@iquer.net> References: <200507211620.37120.erik.wasser@iquer.net> Comments: In-reply-to Erik Wasser message dated "Thu, 21 Jul 2005 16:20:36 +0200" Date: Thu, 21 Jul 2005 10:35:26 -0400 Message-ID: <19902.1121956526@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/180 X-Sequence-Number: 22158 Erik Wasser writes: > can SELECT statements throw errors except the followings: > - SQL syntax errors > - connection based errors (database is down/etc...) > - deadlocks > Did I miss an option? Many. Consider select 1 / 0 In general I'd think that most errors in the "data exception", "cardinality violation", "insufficient resources", and "operator intervention" categories are possible. See the error codes appendix for some ideas. And of course, if the SELECT invokes a user-defined function, no holds are barred ... regards, tom lane