oops -- forgot to send this back to list.
---------- Forwarded Message ----------
Subject: Re: [GENERAL] Updating a table on local machine from remote
linux server
Date: Friday 04 February 2005 01:34 pm
From: "Andrew L. Gould" <algould@datawok.com>
To: Art Fore <art.fore@comcast.net>
On Friday 04 February 2005 12:28 pm, you wrote:
> I have a postgresql 7.5.1 database with one table on a SuSE 9.2
> server. I also have the same database on my windowsxp laptop. I done
> a backup-restore operation to get the original database on the
> windows machine, but seem I cannot update using that. It comes up
> with duplicate primary key errors.
>
> I have tried MS Access, but it does strange things, like not updating
> the values that have changed in a table on a make table query and not
> updating the access table with an update query because it is locked
> by access itself. OOo Base is not quite ready yet to do anything
> except connect to the database and run queries but no update or
> append queries as you cannot link two databases at the same time.
>
> So, how is the best way to do an update-append from one table in a
> postgresql database on a remote machine to a postresql database with
> the same table with old values?
>
> I have PgAdmin running also and can connect to both databases.
>
> Any suggestionsd would be appreciated. I only need to do the one
> table really.
>
> Art
If you want to use MS Access:
1. Link both tables (Linux and Windows) into the MS Access database.
2. Use the query creation wizard to create an unmatched query to find
rows in the Linux table that are missing in the Windows query.
3. Open the unmatched query in Design view and change the query type to
"Append". Choose the Windows table as the table to append to. Make
sure the query columns with "null" as a criteria do not have
destination field names in the "append to" row of the query design.
Save and run the query.
Best of luck,
Andrew Gould
-------------------------------------------------------