Re: Insert into VIEW using RULE. Not possible to use nextval()? - Mailing list pgsql-sql

--- Collin Peters <cadiolis@gmail.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 doINSERT 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.