pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: mnavahan <mnavahan@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Firebird To postgresql migration help needed
Date: Wed, 19 May 2010 08:39:57 -0700 (PDT)
Message-ID: <28610086.post@talk.nabble.com> (raw)


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.




view thread (8+ messages)  latest in thread

Message-ID: <28610086.post@talk.nabble.com>
Permalink:  ../28610086.post@talk.nabble.com/
Also on:    postgresql.org/message-id/28610086.post@talk.nabble.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: mnavahan@yahoo.com
  Subject: Re: Firebird To postgresql migration help needed
  In-Reply-To: <28610086.post@talk.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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