Erik Wasser <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
