Re: updating records - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: updating records
Date
Msg-id 20031003161607.GA19820@wolff.to
Whole thread Raw
In response to updating records  (Gene Vital <genevital@karibe.com>)
List pgsql-general
On Fri, Oct 03, 2003 at 11:27:11 -0400,
  Gene Vital <genevital@karibe.com> wrote:
> Hi all.
>     I am using Visual FoxPro via ODBC to update records on a 7.3.4
> PostgreSql server and it appears that it always uses delete/insert
> instead of updating the current record. Can this be changed to update
> the existing record instead?

Depneding on why you want to do this, it might not help. Postgres
uses MVCC and updates are effectively inserts and deletes.

pgsql-general by date:

Previous
From: "Andrew L. Gould"
Date:
Subject: Re: Schema backup
Next
From: "Robert Wille"
Date:
Subject: Re: LC_COLLATE=C not working