there's no error before I run insert.sql
I exported schema from oracle using ora2pg, I imported (by runing) tables.sql, procedure.sql, sequence.sql fine. When I execute insert.sql I get the error as I posted. Check the tables, they are empty, no data insert. Rollback, - no transaction in process.
thank you,
Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
On Thursday, January 31, 2019 3:16 PM, Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:
> On Jan 31, 2019, at 1:12 PM, Pepe TD Vo <pepevo@xxxxxxxxx> wrote:
>
> there's no transaction in progress when i type rollback command. Also, all tables are emptiness right now.
then there is an earlier error when you run the script
>
> there's no transaction in progress when i type rollback command. Also, all tables are emptiness right now.
then there is an earlier error when you run the script
