English 中文(简体)
Postgres hstore 是否支持每个元素的原子更新?
原标题:Does Postgres hstore support atomic updates per element?

或者你必须更新吗? 在一个历史专栏里说整个收藏/阵列?

问题回答

是的,在两个方面。

第一次更新是ACID意义上的“ 原子 ” 。 其次, 您可以在您的新定义中引用旧变量值, 所以根据这个数字是肯定的 。

唯一的警告是,由于MVCC每一份更新都产生一个只有在交易发生后才可见的副本 < /em>。 我并不认为这与原子论相反。





相关问题
摘录数据

我如何将Excel板的数据输入我的Django应用? I m将PosgreSQL数据库作为数据库。

Postgres dump of only parts of tables for a dev snapshot

On production our database is a few hundred gigabytes in size. For development and testing, we need to create snapshots of this database that are functionally equivalent, but which are only 10 or 20 ...

How to join attributes in sql select statement?

I want to join few attributes in select statement as one for example select id, (name + + surname + + age) as info from users this doesn t work, how to do it? I m using postgreSQL.

What text encoding to use?

I need to setup my PostgreSQL DB s text encoding to handle non-American English characters that you d find showing up in languages such as German, Spanish, and French. What character encoding should ...

SQL LIKE condition to check for integer?

I am using a set of SQL LIKE conditions to go through the alphabet and list all items beginning with the appropriate letter, e.g. to get all books where the title starts with the letter "A": SELECT * ...