| From: | David Fiedler <david(dot)fido(dot)fiedler(at)gmail(dot)com> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | WHEN SQLSTATE '00000' THEN equals to WHEN OTHERS THEN |
| Date: | 2025-03-19 14:03:34 |
| Message-ID: | CAHjN70-=H5EpTOuZVbC8mPvRS5EfZ4MY2=OUdVDWoyGvKhb+Rw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-hackers |
Hi,
I've stumbled across a code that used this condition, resulting in
unexpected behavior. I think it worths a note that catching 00000 is not
possible and that it results in a catch all handler.
What do you think? Should I post the expected text somewhere?
Thanks,
David Fiedler
--
*David Fiedler*
*737472531*
*david(dot)fido(dot)fiedler(at)gmail(dot)com <david(dot)fido(dot)fiedler(at)gmail(dot)com>*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-03-19 15:29:50 | Re: WHEN SQLSTATE '00000' THEN equals to WHEN OTHERS THEN |
| Previous Message | PG Doc comments form | 2025-03-19 12:14:33 | Ambiguity in IS JSON description and logic |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christophe Pettus | 2025-03-19 14:05:47 | Re: Vacuuming the free space map considered harmful? |
| Previous Message | Bruce Momjian | 2025-03-19 13:53:27 | Re: PATCH: warn about, and deprecate, clear text passwords |