Re: [SQL] Meaning of ERROR: tuple concurrently updated

2005-05-19 Thread KÖPFERL Robert
|PFERL_Robert?= <[EMAIL PROTECTED]> writes: |> Thus I run VACUUM ANALYZE; every night by cron. However I |keep getting |> ERROR: tuple concurrently updated | |Have you got other processes also doing VACUUM ANALYZE? The only known |reason for this to happen is that two processes concurrently |A

Re: [SQL] Meaning of ERROR: tuple concurrently updated

2005-05-18 Thread Tom Lane
=?ISO-8859-1?Q?K=D6PFERL_Robert?= <[EMAIL PROTECTED]> writes: > Thus I run VACUUM ANALYZE; every night by cron. However I keep getting > ERROR: tuple concurrently updated Have you got other processes also doing VACUUM ANALYZE? The only known reason for this to happen is that two processes concur

[SQL] Meaning of ERROR: tuple concurrently updated

2005-05-18 Thread KÖPFERL Robert
Hi, I have got some kind of FIFO-queue table. New records are inserted and the oldest are DELETEd. Thus I run VACUUM ANALYZE; every night by cron. However I keep getting ERROR: tuple concurrently updated My research lead me to the point that this is VACUUM tothether with the INSERTs being issued