Re: [pgadmin-support] Restoring PostgreSQL Database Backup

2014-02-06 Thread Craig Ringer
On 02/07/2014 12:23 PM, Muhammad Rizwan Anwar wrote: > Respected, > > I am using the following version of PgAdmin and PostgreSQL > > PgAdmin Version: 1.8.4 (June 4 2008, rev:7358) > PostgreSQL: 8.3.13 > > Problem: I have a data base backup file created in PosgtreSQL 8.4.14, > when I restore it i

[pgadmin-support] Restoring PostgreSQL Database Backup

2014-02-06 Thread Muhammad Rizwan Anwar
Respected, I am using the following version of PgAdmin and PostgreSQL PgAdmin Version: 1.8.4 (June 4 2008, rev:7358) PostgreSQL: 8.3.13 Problem: I have a data base backup file created in PosgtreSQL 8.4.14, when I restore it in PostgreSQL: 8.3.13 on a database (by using pgadmin-iii, right click o

Re: [pgadmin-support] Format SQL (external tool)

2014-02-06 Thread Guillaume Lelarge
On Thu, 2014-02-06 at 20:34 +0800, Craig Ringer wrote: > On 02/06/2014 06:25 PM, Michal Kozusznik wrote: > > We are using SQL Assistant for a lot of tasks like code formatting, > > Autocomplete, code searching etc. Really powerful tool. > > Unfortunately pgAdmin developers has been rejected my requ

Re: [pgadmin-support] Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

2014-02-06 Thread Dinesh Kumar
Hi Suhas, On Thu, Feb 6, 2014 at 6:54 PM, suhas_bt022 wrote: > We have tried it already.Actually there are a quite a lot of syntax changes > required .Which is making task time consuming. > > You can find below statement in ora2pg website. > Ora2Pg do its best to automatically convert your Orac

Re: [pgadmin-support] Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

2014-02-06 Thread suhas_bt022
We have tried it already.Actually there are a quite a lot of syntax changes required .Which is making task time consuming. You can find below statement in ora2pg website. Ora2Pg do its best to automatically convert your Oracle database to PostgreSQL but there's still manual works to do. The Oracle

Re: [pgadmin-support] Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

2014-02-06 Thread Dinesh Kumar
Hi Suhas, On Thu, Feb 6, 2014 at 6:02 PM, suhas_bt022 wrote: > Hi, > > Ora2pg does not translate PL/SQL into Postgresql PL/pgSQL. > We need to do it manually. > I was looking for a open source solution to this problem . > > Ora2Pg do converts the PL/SQL objects to PL/PGSQL. I haven't tried it ,

Re: [pgadmin-support] Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

2014-02-06 Thread suhas_bt022
Hi, Ora2pg does not translate PL/SQL into Postgresql PL/pgSQL. We need to do it manually. I was looking for a open source solution to this problem . Thanks Suhas -- View this message in context: http://postgresql.1045698.n5.nabble.com/Tool-for-translation-of-Oracle-PL-SQL-into-Postgresql-PL-p

Re: [pgadmin-support] Format SQL (external tool)

2014-02-06 Thread Craig Ringer
On 02/06/2014 06:25 PM, Michal Kozusznik wrote: > We are using SQL Assistant for a lot of tasks like code formatting, > Autocomplete, code searching etc. Really powerful tool. > Unfortunately pgAdmin developers has been rejected my request to make > CTRL-space hotkey optional in pgAdmin. Allegedly

Re: [pgadmin-support] Format SQL (external tool)

2014-02-06 Thread Michal Kozusznik
We are using SQL Assistant for a lot of tasks like code formatting, Autocomplete, code searching etc. Really powerful tool. Unfortunately pgAdmin developers has been rejected my request to make CTRL-space hotkey optional in pgAdmin. Allegedly because of amount of work needed to do it (lol). I w

Re: [pgadmin-support] Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

2014-02-06 Thread Dinesh Kumar
Hi , On Thu, Feb 6, 2014 at 12:07 PM, suhas_bt022 wrote: > We are trying to migrate a huge oracle database to postgresql.. I am > finally > stuck with conversion of a huge database with around 250 stored procedures > .Its very painful procedure to convert plsql to plpgsql manually.. > Anyone work

[pgadmin-support] Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

2014-02-06 Thread suhas_bt022
We are trying to migrate a huge oracle database to postgresql.. I am finally stuck with conversion of a huge database with around 250 stored procedures .Its very painful procedure to convert plsql to plpgsql manually.. Anyone worked out a better solution for this ? Any script or tool might help