Menu

#521 Table's file import doesn't report deferred errors

Git
closed-fixed
nobody
5
2017-02-19
2016-11-03
jbgordon85
No

(I'm using Adminer 4.2.5, PostgreSQL 9.5.5.)

In a table of mine, I have some rules enforced by a trigger that defers to the end of a transaction before it runs. When I try to upload a file containing data that violates one of these "enforced-on-commit" rules, the whole file is correctly NOT imported, but Adminer doesn't show any errors and instead shows the green "success" bar with the message "X rows have been imported." (even though really, nothing was imported)

To verify that this is an Adminer problem and not my DB, I clicked the "SQL command" link that follows the "X rows have been imported" message, copied the SQL that Adminer used, and ran that SQL at the command line. When I run it there, I do get the expected error message on commit. So my DB is working as intended, but Adminer apparently isn't.

I've tried to keep this general, but can easily provide specifics if desired.

Discussion

  • Jakub Vrána

    Jakub Vrána - 2017-02-19
    • status: open --> closed-fixed
     

Log in to post a comment.