On 2010-12-06, - wrote:
> --0016364d26cf7fa4970496bf2224
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi everyone,
> I have a question about how best to insert and manipulate the table with
> primary key id for better productivity. I need to insert data into the table
> and get last id.
>
>
Quoting - :
I know you can skip SEQUENCE - ((SELECT nextval ('seq_table')) do not put
this in the query, my question was that such concurrency, and ids
omitted which can not be inserted but increased with SEQUENCE ?
In the initial message you have been wondering, if you should be worried
abou
Quoting - :
I have a question about how best to insert and manipulate the table with
primary key id for better productivity. I need to insert data into the table
and get last id.
1. First option to take counter Postgres SEQUENCE:
INSERT INTO table (id, ...) VALUES ((SELECT nextval ('seq_table')
Hi everyone,
I have a question about how best to insert and manipulate the table with
primary key id for better productivity. I need to insert data into the table
and get last id.
1. First option to take counter Postgres SEQUENCE:
INSERT INTO table (id, ...) VALUES ((SELECT nextval ('seq_table'))
