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

--- Collin Peters <cadiolis(at)gmail(dot)com> 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.