Firebird To postgresql migration help needed

From: mnavahan <mnavahan(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Firebird To postgresql migration help needed
Date: 2010-05-19 15:39:57
Message-ID: 28610086.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


I try to move from firebird to postgresql But it seems some option to do hold
..

1. In grant section in some reason user ROLE R1 can Access to function F1
and F1 can access to Table T1 bUT user must not be granted to work directly
to table T1

In firebird ,I can invoke grant to object
GRANT SELECT, INSERT ON T1 TO PROCEDURE F1;

Can I do the same with postgresql or other ways to do this job ?

2. In new firebird 2.1.3, I have some "DATABASE TRIGGER" for user to connect
& disconnect or start & finish database or transaction . Do we have same
trigger or any ways in PG to do the same ?

3.I work with pgadmin3 and it is very nice and free ... also I have checked
many other commercial experts such as novicat, pgmanager,maestro.... BUT
I did not find any editor as POWERFUL as IBEXPERT for firebird.
Is there any Powerful editor as powerful as IBEXPERT in PG ?

--
View this message in context: http://old.nabble.com/Firebird-To-postgresql-migration-help-needed-tp28610086p28610086.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2010-05-19 16:08:01 Re: Firebird To postgresql migration help needed
Previous Message Josi Perez (3T Systems) 2010-05-19 12:30:17 Trigger with dynamic SQL