postgres insert is rolled back

[timterry]

Hi,

I have a postgres migrator with an insert statement. The migrator runs fine but the new rows are not committed. (i can see the table's sequence has incremented). I have turned on debug logging in the posgres driver and can see the statements being executed and committed. However, after inspecting the table, no new rows have been added. The sql creates a simple table with two columns in one migration then tries to insert a record in the next. Any clues to what could be the cause?

Thanks

[michaelklishin]

Can you post said PostgreSQL log? Rollbacks typically indicate migration failures.