Question #256

Author: admin
tags: PostgreSQL   backend  
There is a regular table in a PostgreSQL database with "id" field (serial) and some other columns.
Someone tried to add data to this table and an error occured with message "duplicate key value violates unique constraint..." during add because of UNIQUE constraint. So no data was added.
Was the sequence value of "id" column increased?
No
No if the addition was in a transaction, and yes if there was no transaction
Yes, in any case
Rate the difficulty of the question:
easyhard