Re: [SQL] Insert into VIEW using RULE. Not possible to use nextval()?

[Richard Broersma Jr]

--- Collin Peters <[EMAIL PROTECTED]> wrote:

> 2. currval() is guaranteed to be correct within the RULE.  This was my
> second question.  If I call "INSERT INTO Vschematic_insert(..."
> simultaneously 1000 times is it guaranteed to be correct?

To illistrate using psudo code:

//This will always work:

For i = 1 to 1000 do
 INSERT INTO Vschematic VALUES ( .. some unique values .. );
Next i

//These will always fail:
INSERT INTO Vschematic SELECT * FROM A_TABLE LIMIT 1000;
or
INSERT INTO Vschematic VALUES ( unique vals 1),(unique vals 2), ..., (unique 
vals n);

Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend