Re: Firebird To postgresql migration help needed

On Wed, May 19, 2010 at 9:39 AM, mnavahan <mnavahan(at)yahoo(dot)com> wrote:
>
> 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 ?

I think so. Look up "SECURITY DEFINER"

> 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 ?

Not that I know of. You're talking connect / disconnect triggers right?

> 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 ?

I use nano or vi for most stuff. Both can do color coding quite
nicely for .sql files.