Message-ID: <28610086.post@talk.nabble.com>
Date: Wed, 19 May 2010 08:39:57 -0700 (PDT)
From: mnavahan <mnavahan@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Firebird To postgresql migration help needed
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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.