Re: [ADMIN] Firebird To postgresql migration help needed

2010-06-05 Thread Scott Marlowe
On Fri, Jun 4, 2010 at 10:24 PM, mnavahan wrote: > > > > Scott Marlowe-2 wrote: >> >> On Wed, May 19, 2010 at 10:38 AM, mnavahan wrote: >>> >I think so.  Look up "SECURITY DEFINER" >>> >>> seems goods i need try to it ... >>> >>> >Not that I know of.  You're talking connect / disconn

Re: [ADMIN] Firebird To postgresql migration help needed

2010-06-04 Thread mnavahan
Scott Marlowe-2 wrote: > > On Wed, May 19, 2010 at 10:38 AM, mnavahan wrote: >> I think so.  Look up "SECURITY DEFINER" >> >> seems goods i need try to it ... >> >> Not that I know of.  You're talking connect / disconnect triggers right? >> YES how do it ? > > It's not reall

Re: [ADMIN] Firebird To postgresql migration help needed

2010-06-03 Thread Dimitri Fontaine
I can't help it. Lew writes: > mnavahan wrote: >>> i [sic] need powerful IDE for it with modernize options (extended editor) >>> rich >>> good > > Scott Marlowe wrote: >> Got me. Maybe eclipse has a nice plugin? > > YMMV. They might represent overkill for some folks. I enjoy the > conven

Re: [ADMIN] Firebird To postgresql migration help needed

2010-06-02 Thread Lew
Scott Marlowe wrote: I use nano or vi for most stuff. Both can do color coding quite nicely for .sql files. mnavahan wrote: i [sic] need powerful IDE for it with modernize options (extended editor) rich good Scott Marlowe wrote: Got me. Maybe eclipse has a nice plugin? I find both

Re: [ADMIN] Firebird To postgresql migration help needed

2010-05-19 Thread Scott Marlowe
On Wed, May 19, 2010 at 10:38 AM, mnavahan wrote: > >>>I think so.  Look up "SECURITY DEFINER" > > seems goods i need try to it ... > > >>>Not that I know of.  You're talking connect / disconnect triggers right? > YES how do it ? It's not really doable. However, it's possible that what

Re: [ADMIN] Firebird To postgresql migration help needed

2010-05-19 Thread mnavahan
>>I think so. Look up "SECURITY DEFINER" seems goods i need try to it ... >>Not that I know of. You're talking connect / disconnect triggers right? YES how do it ? >>>I use nano or vi for most stuff. Both can do color coding quite nicely for .sql files. i need powerful IDE for i

Re: [ADMIN] Firebird To postgresql migration help needed

2010-05-19 Thread Scott Marlowe
On Wed, May 19, 2010 at 9:39 AM, mnavahan 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

[ADMIN] Firebird To postgresql migration help needed

2010-05-19 Thread mnavahan
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