pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFirebird To postgresql migration help needed
8+ messages / 4 participants
[nested] [flat]
* Firebird To postgresql migration help needed
@ 2010-05-19 15:39 mnavahan <mnavahan@yahoo.com>
0 siblings, 1 reply; 8+ messages in thread
From: mnavahan @ 2010-05-19 15:39 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Firebird To postgresql migration help needed
@ 2010-05-19 16:08 Scott Marlowe <scott.marlowe@gmail.com>
parent: mnavahan <mnavahan@yahoo.com>
0 siblings, 1 reply; 8+ messages in thread
From: Scott Marlowe @ 2010-05-19 16:08 UTC (permalink / raw)
To: mnavahan <mnavahan@yahoo.com>; +Cc: pgsql-admin
On Wed, May 19, 2010 at 9:39 AM, mnavahan <mnavahan@yahoo.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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Firebird To postgresql migration help needed
@ 2010-05-19 16:38 mnavahan <mnavahan@yahoo.com>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: mnavahan @ 2010-05-19 16:38 UTC (permalink / raw)
To: pgsql-admin
>>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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Firebird To postgresql migration help needed
@ 2010-05-19 18:00 Scott Marlowe <scott.marlowe@gmail.com>
parent: mnavahan <mnavahan@yahoo.com>
0 siblings, 2 replies; 8+ messages in thread
From: Scott Marlowe @ 2010-05-19 18:00 UTC (permalink / raw)
To: mnavahan <mnavahan@yahoo.com>; +Cc: pgsql-admin
On Wed, May 19, 2010 at 10:38 AM, mnavahan <mnavahan@yahoo.com> 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 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. Both can do color coding quite nicely
> for .sql files.
>
> i need powerful IDE for it with modernize options (extended editor) rich
> good ....
Got me. Maybe eclipse has a nice plugin?
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Firebird To postgresql migration help needed
@ 2010-05-19 21:29 Lew <noone@lewscanon.com>
parent: Scott Marlowe <scott.marlowe@gmail.com>
1 sibling, 1 reply; 8+ messages in thread
From: Lew @ 2010-05-19 21:29 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Firebird To postgresql migration help needed
@ 2010-06-03 16:34 Dimitri Fontaine <dfontaine@hi-media.com>
parent: Lew <noone@lewscanon.com>
0 siblings, 0 replies; 8+ messages in thread
From: Dimitri Fontaine @ 2010-06-03 16:34 UTC (permalink / raw)
To: Lew <noone@lewscanon.com>; +Cc: pgsql-admin
I can't help it.
Lew <noone@lewscanon.com> 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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Firebird To postgresql migration help needed
@ 2010-06-05 04:24 mnavahan <mnavahan@yahoo.com>
parent: Scott Marlowe <scott.marlowe@gmail.com>
1 sibling, 1 reply; 8+ messages in thread
From: mnavahan @ 2010-06-05 04:24 UTC (permalink / raw)
To: pgsql-admin
Scott Marlowe-2 wrote:
>
> On Wed, May 19, 2010 at 10:38 AM, mnavahan <mnavahan@yahoo.com> 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 you're
> trying to accomplish (big picture) is. What is it that you're trying
> to accomplish with connect / disconnect triggers?
>
>
yes really need it !
also need for transaction !
--
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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Firebird To postgresql migration help needed
@ 2010-06-05 04:48 Scott Marlowe <scott.marlowe@gmail.com>
parent: mnavahan <mnavahan@yahoo.com>
0 siblings, 0 replies; 8+ messages in thread
From: Scott Marlowe @ 2010-06-05 04:48 UTC (permalink / raw)
To: mnavahan <mnavahan@yahoo.com>; +Cc: pgsql-admin
On Fri, Jun 4, 2010 at 10:24 PM, mnavahan <mnavahan@yahoo.com> wrote:
>
>
>
> Scott Marlowe-2 wrote:
>>
>> On Wed, May 19, 2010 at 10:38 AM, mnavahan <mnavahan@yahoo.com> 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 you're
>> trying to accomplish (big picture) is. What 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.
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2010-06-05 04:48 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-05-19 15:39 Firebird To postgresql migration help needed mnavahan <mnavahan@yahoo.com>
2010-05-19 16:08 ` Scott Marlowe <scott.marlowe@gmail.com>
2010-05-19 16:38 ` mnavahan <mnavahan@yahoo.com>
2010-05-19 18:00 ` Scott Marlowe <scott.marlowe@gmail.com>
2010-05-19 21:29 ` Lew <noone@lewscanon.com>
2010-06-03 16:34 ` Dimitri Fontaine <dfontaine@hi-media.com>
2010-06-05 04:24 ` mnavahan <mnavahan@yahoo.com>
2010-06-05 04:48 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox