Re: cache problem (v2) - Mailing list pgsql-admin

From De Leeuw Guy
Subject Re: cache problem (v2)
Date
Msg-id 469C5AC4.7040903@eurofer.be
Whole thread Raw
In response to Re: cache problem (v2)  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: cache problem (v2)
List pgsql-admin
Hello Andrew

> You can see things that happened in your own transaction, but nobody
> else can.  If you're working READ COMMITTED, you can also see work
> that other transactions commit while you were working.  Could any of
> that be affecting you?  Unless your own function is doing something
> with some cache, I am positive there's no cache issue here as you
> describe it.
>
>
I read the documentation :
http://www.postgresql.org/docs/8.2/interactive/transaction-iso.html#XACT-SERIALIZABLE
and it's maybe my problem

the COPY start a transaction ? if yes each time my trigger select a data
and update then the value returned by the read are the value before the
transaction. It's true ? if yes my question are : also in the same
transaction (like my trigger) ?

Great thanks

Guy




pgsql-admin by date:

Previous
From: "Jayakumar_Mukundaraju"
Date:
Subject: PgAgent Job Scheduling-Backup
Next
From: Jürgen Ulrich
Date:
Subject: compiling C Funktion for PostgreSQL