Skip site navigation (1) Skip section navigation (2)

Re: Copying data from table to table (cloned tables)

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Fourat Zouari <fourat(at)gmail(dot)com>
Cc: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>, Bricklen Anderson <banderson(at)presinet(dot)com>, pgsql-novice(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: Copying data from table to table (cloned tables)
Date: 2006-10-11 15:14:39
Message-ID: 20061011151439.GA11039@wolff.to (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-novice
On Wed, Oct 11, 2006 at 13:30:22 +0200,
  Fourat Zouari <fourat(at)gmail(dot)com> wrote:
> what's the benefits using a serialized trans ?

All of the queries in the transaction see a consistant view of the database.
So that two identical select queries will return the same information
within a serialized transaction. (As long as the current transaction doesn't
make any changes between the two selects that would affect their output.)

In response to

pgsql-novice by date

Next:From: Laura HornbeckDate: 2006-10-12 17:27:10
Subject: FATAL: the database system is in recovery mode
Previous:From: Brandon AikenDate: 2006-10-11 12:56:09
Subject: Re: [ADMIN] Copying data from table to table (cloned tables)

pgsql-admin by date

Next:From: Jim C. NasbyDate: 2006-10-11 21:12:46
Subject: Re: postgres in HA constellation
Previous:From: Sebastian ReitenbachDate: 2006-10-11 14:42:22
Subject: Re: postgres in HA constellation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group