pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Can SELECT statements throw an error 2+ messages / 2 participants [nested] [flat]
* Can SELECT statements throw an error @ 2005-07-21 14:20 Erik Wasser <erik.wasser@iquer.net> 0 siblings, 1 reply; 2+ messages in thread From: Erik Wasser @ 2005-07-21 14:20 UTC (permalink / raw) To: pgsql-sql Hello list, can SELECT statements throw errors except the followings: - SQL syntax errors - connection based errors (database is down/etc...) - deadlocks Did I miss an option? -- So long... Fuzz ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Can SELECT statements throw an error @ 2005-07-21 14:35 Tom Lane <tgl@sss.pgh.pa.us> parent: Erik Wasser <erik.wasser@iquer.net> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2005-07-21 14:35 UTC (permalink / raw) To: Erik Wasser <erik.wasser@iquer.net>; +Cc: pgsql-sql Erik Wasser <erik.wasser@iquer.net> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-07-21 14:35 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-07-21 14:20 Can SELECT statements throw an error Erik Wasser <erik.wasser@iquer.net> 2005-07-21 14:35 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox