Re: Migrating to postgresql from oracle

2017-12-23 Thread Timo Myyrä
On Sat, Dec 23, 2017, at 21:05, Pavel Stehule wrote: > Hi > > 2017-12-23 19:53 GMT+01:00 Timo Myyrä : >> Hi, >> >> I'm preparing migration of our asset management system database from >> Oracle 12c to>> PostgreSQL 10. I'm using ora2pg and a bit of sed to >> mangle the SQL >> ready for>> im

Re: Migrating to postgresql from oracle

2017-12-23 Thread Pavel Stehule
Hi 2017-12-23 19:53 GMT+01:00 Timo Myyrä : > Hi, > > I'm preparing migration of our asset management system database from > Oracle 12c to > PostgreSQL 10. I'm using ora2pg and a bit of sed to mangle the SQL ready > for > import to pg but I've hit first problem: > ERROR: referenced relation "..."