Re: [ADMIN] Query failed: ERROR: deadlock detected

2005-08-29 Thread Aldor
thanks for the explanation... i found the mistake in a new pl/pgsql function i wrote before this error occured;-) Oliver Elphick wrote: > On Mon, 2005-08-29 at 16:50 +0100, Aldor wrote: > >>PostgreSQL 8.0.3: Any idea what this is? >> >>--- >>Warning: pg_query(): Query failed: ERROR: deadlock det

Re: [ADMIN] Query failed: ERROR: deadlock detected

2005-08-29 Thread Oliver Elphick
On Mon, 2005-08-29 at 16:50 +0100, Aldor wrote: > PostgreSQL 8.0.3: Any idea what this is? > > --- > Warning: pg_query(): Query failed: ERROR: deadlock detected > DETAIL: Process 8835 waits for ShareLock on transaction 193588236; > blocked by process 8834. > Process 8834 waits for ShareLock on t

[ADMIN] Query failed: ERROR: deadlock detected

2005-08-29 Thread Aldor
PostgreSQL 8.0.3: Any idea what this is? --- Warning: pg_query(): Query failed: ERROR: deadlock detected DETAIL: Process 8835 waits for ShareLock on transaction 193588236; blocked by process 8834. Process 8834 waits for ShareLock on transaction 193588228; blocked by process 8835 --- I have neve