ECPG sqlca error handling

From: Matthias Apitz <guru(at)unixarea(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: ECPG sqlca error handling
Date: 2020-11-12 07:07:10
Message-ID: 20201112070710.GA18127@r314251-amd64
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

The documentation explains well how to use the 'sqlca' for error
handling: https://www.postgresql.org/docs/13/ecpg-errors.html#ECPG-SQLCA

An error message is stored in sqlca.sqlerrm.char sqlerrmc[SQLERRMC_LEN].

My question is: Is there some way to get the exact failing ESQL/C
statement, because only the line number does not help in our case.

Thanks in advance

matthias
--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Без книги нет знания, без знания нет коммунизма (Влaдимир Ильич Ленин)
Without books no knowledge - without knowledge no communism (Vladimir Ilyich Lenin)
Sin libros no hay saber - sin saber no hay comunismo. (Vladimir Ilich Lenin)

Browse pgsql-general by date

  From Date Subject
Next Message Moorthy RS 2020-11-12 12:47:53 postgres: WAL ends befor end of online backup
Previous Message Saurav Sarkar 2020-11-12 06:27:27 Re: Encryption with customer provided key in a multi tenant Postgres JSONB DB