[pgadmin-support] Syncronization of two databases

2007-07-05 Thread Art Fore
Have been looking on the internet, but have not found anything about PGAdmin or Postgres database syncronization other the navicat which is expensive. Is it possible to syncronizes two databases with PGadmin and if so, can some one point me to the way to do it? Art ---(en

[pgadmin-support] case conversion

2007-02-15 Thread Art Fore
Is there any way to convert a text column to uppercase with pgadmin? I can do it with Access, but it does not appear to work with a linked table. Art ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [pgadmin-support] Query (view) question

2007-02-12 Thread Art Fore
On Mon, 2007-02-12 at 12:00 +0100, Joris Dobbelsteen wrote: > >-Original Message- > >From: [EMAIL PROTECTED] > >[mailto:[EMAIL PROTECTED] On Behalf Of Art Fore > >Sent: maandag 12 februari 2007 11:40 > >To: Pgadmin-Support > >Subject: [pgadmin-suppor

[pgadmin-support] Query (view) question

2007-02-12 Thread Art Fore
I have been trying to get a query going in a postgres database, a simple on at that, and have had no success expcept using Access. Here is the query that works in Access. SELECT remote_ALL_PARTS.PARTNUM, public_datasheet_address.Datasheet & remote_ALL_PARTS.Datasheet AS Expr1, public_datasheet_ad

Re: [pgadmin-support] Firewall Locks Windows Version

2005-08-31 Thread Art Fore
I have pgadminIII running on WinXP with no problems. I am using Computer Associates EZfirewall and have the WinXP firewall turned off. I also had norton firewall at one time, an it worked with it, but I had to turn off the winxp firewall. Art Tino Wildenhain wrote: Stephen McConnell schrieb

Re: [pgadmin-support] backup-restore does not work

2005-02-08 Thread Art Fore
changed other than dopping it and restoring it? Seems like there should be an easier way that backup-restore. Art Art Fore wrote: Using PGadminIII, I backup my database on linux machine (Postgresql 7.4), and try to restore it on the windows machine (Postgresql 8.0 beta5). Alway comes up with

[pgadmin-support] backup-restore does not work

2005-02-08 Thread Art Fore
Using PGadminIII, I backup my database on linux machine (Postgresql 7.4), and try to restore it on the windows machine (Postgresql 8.0 beta5). Alway comes up with duplicate key on the first item. I drop all views and the only table in the database and try again. Still same thing. I do a refres

Re: [pgadmin-support] Export funtion

2005-02-04 Thread Art Fore
Never min, I finally found it. It is well hidden. Art Art Fore wrote: The help file for PGAdmin 1.2 shows an export dialog box for exporting data to a file in Windows. Can anyone tell me where this export function is located? Art ---(end of broadcast

[pgadmin-support] Export funtion

2005-02-04 Thread Art Fore
The help file for PGAdmin 1.2 shows an export dialog box for exporting data to a file in Windows. Can anyone tell me where this export function is located? Art ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTE

Re: [pgadmin-support] phpPgAdmin cannot login to server

2005-02-03 Thread Art Fore
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Art Fore Sent: Thursday, February 03, 2005 3:13 AM To: pgadmin-support@postgresql.org Subject: [pgadmin-support] phpPgAdmin cannot login to server I have asked this once, but never got a definitive answer, so am asking again. Hav

[pgadmin-support] phpPgAdmin cannot login to server

2005-02-03 Thread Art Fore
I have asked this once, but never got a definitive answer, so am asking again. Have Suse 9.2 server running postgresql 7.4, apache 2. and phpPgAdmin. I can loginto to the server using either pgadminIII, OOoBase, or MS Acess from my windows machine with no problem. When I try to login with phpP

[pgadmin-support] Backup/restore with pgadminIII ver 1.2

2005-02-01 Thread Art Fore
Last Friday, I done a backup of a postgresql database on a linux server and restored it to a server on Windows, all went fine. Now I try to do the same thing, I get either a duplicate index item, where there is not one, or the restore does not recognize the file as being valic archive. tried ev