Re: [HACKERS] RI_FKey_check: foreign key constraint blocks

2002-11-13 Thread Peter Schindler
Stephan Szabo wrote: > I've been working on something of the sort. I've got a test patch > (against about 7.3b2) that I'm trying to validate which cases it does and > does not work for. I'm still looking for more volunteers if you've got a > dev system you're willing to use. :) I'd willing to do

[HACKERS] RI_FKey_check: foreign key constraint blocks parallel independentinserts

2002-11-13 Thread Peter Schindler
ID); ALTER TABLE child ADD CONSTRAINT child_parent_id FOREIGN KEY (parent_id) REFERENCES parent (ID); insert into parent values (1); insert into parent values (2); begin; insert into child values (1,1); in session2 after the last insert in session1: ==

Re: [HACKERS] stuck spinlock

2001-02-28 Thread Peter Schindler
Tom Lane wrote: > Judging from the line number, this is in CreateCheckPoint. I'm > betting that your platform (Solaris 2.7, you said?) has the same odd > behavior that I discovered a couple days ago on HPUX: a select with > a delay of tv_sec = 0, tv_usec = 100 doesn't delay 1 second like > a

[HACKERS] stuck spinlock

2001-02-26 Thread Peter Schindler
ero len at (0, 3663163376) DEBUG: Formatting logfile 0 seg 218 block 699 at offset 4080 DEBUG: The last logId/logSeg is (0, 218) DEBUG: redo done at (0, 3663163336) -- Best regards, Peter Schindler Synchronicity Inc.| [EMAIL PROTECTED] http://www.synchronicity.com | +49 89 89 66 99 42 (Germany)