Search Postgresql Archives

Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



El día Dienstag, Mai 12, 2020 a las 12:30:17 -0700, Adrian Klaver escribió:

> On 5/12/20 12:14 PM, Matthias Apitz wrote:
> > 
> > To answer also the question of Adrian Klaver:
> > 
> > The database in question has ~400 tables and the ESQL/C application has
> > for each table its own ESQL/C source file. It would be possible but a
> > nightmare to share the code and it's better to discuss the problem based
> > on the ESQL/c log file or I have to write some small example code to
> > reproduce the problem. The line numbers are relative to those source
> > files (and it's a pitty that the name of the source file is not logged,
> > onle the line numbers).
> 
> Yeah, but there is a one:one mapping of table:source file and you know the
> table, so you should be able to find the source at the line number. Or am I
> missing something?

Yes. The table here is swd_daten, the corresponding .pgc file is
swd_daten.pgc.

And in the log the line logged is:

[1471] [12.05.2020 15:48:50:476]: ecpg_process_output on line 1744: OK: INSERT 0 1

What I wanted to have is:


[1471] [12.05.2020 15:48:50:476]: ecpg_process_output on line 1744 of swd_daten.pgc: OK: INSERT 0 1

i.e. have added the file name to the line number as "on line 1744 of
swd_daten.pgc" to not always have to think, hey in which table we're
with this at the moment.

> Also, from OP did:
> 
> insert into swd_auftrag ..
> 
> COMMIT?

This question (if it was a question) I don't understand.

	matthias
-- 
Matthias Apitz, ✉ guru@xxxxxxxxxxx, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux