Firebird To postgresql migration help needed

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.


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Firebird To postgresql migration help needed

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 direct=
ly
> to table T1
>
> =A0 In firebird ,I can invoke grant to object
> =A0 =A0 =A0 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 conn=
ect
> & disconnect or start =A0& finish database or transaction . =A0Do 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 check=
ed
> many other commercial experts such as novicat, pgmanager,maestro.... =A0 =
=A0 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.

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Firebird To postgresql migration help needed

>>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 it with modernize options (extended editor) rich
good ....
--
View this message in context: http://old.nabble.com/Firebird-To-postgresql-migration-help- needed-tp28610086p28610897.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Firebird To postgresql migration help needed

On Wed, May 19, 2010 at 10:38 AM, mnavahan wrote:
>
>>>I think so. =A0Look up "SECURITY DEFINER"
>
> seems goods .... i need try to it ...
>
>
>>>Not that I know of. =A0You're talking connect / disconnect triggers righ=
t?
> YES .... how do it ?

It's not really doable. However, it's possible that what you're
trying to accomplish (big picture) is. What is it that you're trying
to accomplish with connect / disconnect triggers?

>>>>I use nano or vi for most stuff. =A0Both can do color coding quite nice=
ly
> for .sql files.
>
> i need powerful IDE for it with modernize options (extended editor) rich
> good ....

Got me. Maybe eclipse has a nice plugin?

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Firebird To postgresql migration help needed

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 Eclipse and NetBeans to be quite sufficient as SQL editors and
admin/edit/query front ends for any database system that has a JDBC driver.
They probably aren't quite as useful if you aren't using Java, although both
have C/C++ capability. I'm not familiar with other IDEs.

No extra plugins were required with the current versions that I downloaded,
namely NetBeans 6.8 or 6.9beta or Eclipse Galileo SR2.

The IDEs have additional advantages besides managing databases and editing SQL
and program source code, such as providing quite convenient management
consoles for popular Java application servers such as Tomcat or various Java
EE products, and handling applications' build and deployment phases.

YMMV. They might represent overkill for some folks. I enjoy the convenience
of having everything under one roof.

--
Lew

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Firebird To postgresql migration help needed

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
> convenience of having everything under one roof.

For those reasons I use Emacs.
--
dim

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Firebird To postgresql migration help needed

Scott Marlowe-2 wrote:
>=20
> 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 ?
>=20
> It's not really doable. However, it's possible that what you're
> trying to accomplish (big picture) is. What is it that you're trying
> to accomplish with connect / disconnect triggers?
>=20
>=20


yes really need it !
also need for transaction !
--=20
View this message in context: http://old.nabble.com/Firebird-To-postgresql-=
migration-help-needed-tp28610086p28787304.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Firebird To postgresql migration help needed

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. =A0Look up "SECURITY DEFINER"
>>>
>>> seems goods .... i need try to it ...
>>>
>>>
>>>>>Not that I know of. =A0You're talking connect / disconnect triggers ri=
ght?
>>> YES .... how do it ?
>>
>> It's not really doable. =A0However, it's possible that what you're
>> trying to accomplish (big picture) is. =A0What is it that you're trying
>> to accomplish with connect / disconnect triggers?
>>
>>
>
>
> yes really need it !
> also need for transaction !

OK, but what do you need it to do, why are you doing it? I can't
offer possible alternatives if I don't know why you're trying to do
it. Do you want the user to have certain schemas in their search
path? Set values for random_page_cost? Set logging to a certain
level? All of those things can be done without a trigger.

Are you wanting to log access from a user? More detail gets better answers.

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin