On Tue, Sep 26, 2006 at 03:59:48PM +0200, Kai Hessing wrote: > No one any idea? *sigh* It probably has something to with the fact that you didn't explain what you meant by "deadlock". Also, you refer to a temp table, yet don't indicate which table it is. You'll need to be a lot more specific about your problem before we can help. For example, a script to reproduce the problem, or a copy of psql output demonstrating it. Hope this helps, > Kai Hessing wrote: > > Hi Folks, > > > > I have a strange Problem (to be honest there are more than one, but this > > is one of it) after Upgrading to Postgres 8.1.3. The following SQL seems > > to produce a deadlock while doing an endless reading of a temp table: > > > > SELECT s.sid FROM stud s, stud_vera v WHERE s.sid = v.sid AND v.veraid = > > 34 AND s.sid NOT IN ( SELECT sid FROM stud_vera WHERE veraid = 2 ); Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
