COLLATE: Hash partition vs UPDATE
От | Jesper Pedersen |
---|---|
Тема | COLLATE: Hash partition vs UPDATE |
Дата | |
Msg-id | a620f85a-42ab-e0f3-3337-b04b97e2e2f5@redhat.com обсуждение исходный текст |
Ответы |
Re: COLLATE: Hash partition vs UPDATE
|
Список | pgsql-hackers |
Hi, The following case -- test.sql -- CREATE TABLE test (a text PRIMARY KEY, b text) PARTITION BY HASH (a); CREATE TABLE test_p0 PARTITION OF test FOR VALUES WITH (MODULUS 2, REMAINDER 0); CREATE TABLE test_p1 PARTITION OF test FOR VALUES WITH (MODULUS 2, REMAINDER 1); -- CREATE INDEX idx_test_b ON test USING HASH (b); INSERT INTO test VALUES ('aaaa', 'aaaa'); -- Regression UPDATE test SET b = 'bbbb' WHERE a = 'aaaa'; -- test.sql -- fails on master, which includes [1], with psql:test.sql:9: ERROR: could not determine which collation to use for string hashing HINT: Use the COLLATE clause to set the collation explicitly. It passes on 11.x. I'll add it to the open items list. [1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5e1963fb764e9cc092e0f7b58b28985c311431d9 Best regards, Jesper
В списке pgsql-hackers по дате отправления: