Update and cursor

From: Patrick COLLIN <patrick(at)felixfr(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Update and cursor
Date: 2001-06-19 09:53:08
Message-ID: 3B2F2104.63BD9FD5@felixfr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need to update 300,000 records with many tests on each before
updating.

I first tried a global update on each column, but I have not enough
memory and swap to do that.

Is it possible to do that, one row at time, whithout locking more than
one record ?

Patrick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2001-06-19 10:08:55 Re: front ends for postgres under linux
Previous Message Michael Meskes 2001-06-19 09:50:46 Re: front ends for postgres under linux