[pgadmin-support] database link

2003-12-11 Thread llepc
are there any way to access other database from
postgresql database ?
on oracle there is a database link objetc that you can
access other 
databases. is it possible ? I would like to access a
specific table on 
a microsoft access or oracle.

thanks a lot
Leonardo
 
__
Acabe com aquelas janelinhas que pulam na sua tela.
AntiPop-up UOL - É grátis!
http://antipopup.uol.com.br/



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [pgadmin-support] database link

2003-12-11 Thread Andreas Pflug
llepc wrote:

are there any way to access other database from
postgresql database ?
 

Leonardo, this is the wrong list.

on oracle there is a database link objetc that you can
access other 
databases. is it possible ? I would like to access a
specific table on 
a microsoft access or oracle.
 

AFAIK, for Oracle there's a contrib module oralink.
For microsoft access, there's a heartily laughter from the world of real 
databases: "What the h*ll is Access?!?"

Regards,
Andreas


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly


Re: [pgadmin-support] database properties don't pop up

2003-12-11 Thread Andreas Pflug
Michael Shapiro wrote:

Andeas, the new snapshot is an improvement, but there are still 
problems. I can now get the database properties to come up, but the 
privileges for users is showing no privileges for any of the users, 
even though the ACL in the main Properties window shows 
postgres=CT,tgam=C. I have included a jpg image for you to see.


Argh...
this was a 7.4 fix. Just upgrade your 7.3 machine... :-)
Or wait until I have a solution.
Regards,
Andreas


---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org


Re: [pgadmin-support] database properties don't pop up

2003-12-11 Thread Michael Shapiro
I'll wait. Upgrading to 7.4 isn't an option at this time. This used to work 
in previous versions of PgAdmin even with 7.3

At 11:15 PM 12/11/2003 +0100, Andreas Pflug wrote:
Michael Shapiro wrote:

Andeas, the new snapshot is an improvement, but there are still problems. 
I can now get the database properties to come up, but the privileges for 
users is showing no privileges for any of the users, even though the ACL 
in the main Properties window shows postgres=CT,tgam=C. I have included a 
jpg image for you to see.


Argh...
this was a 7.4 fix. Just upgrade your 7.3 machine... :-)
Or wait until I have a solution.
Regards,
Andreas
---
Michael 

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
 joining column's datatypes do not match