What IR model the PostgreSQL FTS implementation is based on?

2022-02-26 Thread Timo Myyrä
Hi, I'm trying to figure out what information retrieval model[1] the PostgreSQL Full-Text Search is based on. Based on my reading on the PostgreSQL documentation I would have guessed extended boolean model but I came across an web article by Compose[2] which claims that FTS is based on vector spa

Migrating to postgresql from oracle

2017-12-23 Thread 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 "..." is not a table Our Oracle databases uses single 'admin' s

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

Re: Oracle to postgres migration

2017-12-26 Thread Timo Myyrä
On Tue, Dec 26, 2017, at 11:36, Vasilis Ventirozos wrote: > I'd start with this first : https://ora2pg.darold.net > >> On 26 Dec 2017, at 02:30, Azimuddin Mohammed >> wrote:>> >> Hello, >> Can anyone guide me through the steps for migration from oracle to >> postgres with config changes required

Re: Oracle to postgres migration

2017-12-26 Thread Timo Myyrä
On Tue, Dec 26, 2017, at 02:30, Azimuddin Mohammed wrote: > Hello, > Can anyone guide me through the steps for migration from oracle to > postgres with config changes required, keeping in mind that neither I > am a oracle DBA not postgres admin> > -- > > Regards, > Azim > > > Virus-free. www.