Re: updating records

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Gene Vital <genevital(at)karibe(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: updating records
Date: 2003-10-03 16:16:07
Message-ID: 20031003161607.GA19820@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Oct 03, 2003 at 11:27:11 -0400,
Gene Vital <genevital(at)karibe(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2003-10-03 16:30:41 Re: validation of postgresql functions
Previous Message Tom Lane 2003-10-03 16:14:56 Re: Query FKey Constraint Table and Column Names