if (strcmp(accessMethodName,"hash")==0)

ereport(WARNING,

(errmsg("hash indexes are not WAL-loggedso they are not crash-safe and cannot be used onstreaming standbys")));

(errmsg("hash indexes are not WAL-loggedand thus are not crash-safe and cannot be used onstandby servers")));

if (stmt->unique&& !accessMethodForm->amcanunique)

ereport(ERROR,

-- HASH

--

CREATE INDEX hash_i4_index ON hash_i4_heap USING hash (random int4_ops);

WARNING: hash indexes are not WAL-loggedso they are not crash-safe and cannot be used onstreaming standbys

WARNING: hash indexes are not WAL-loggedand thus are not crash-safe and cannot be used onstandby servers

CREATE INDEX hash_name_index ON hash_name_heap USING hash (random name_ops);

WARNING: hash indexes are not WAL-loggedso they are not crash-safe and cannot be used onstreaming standbys

WARNING: hash indexes are not WAL-loggedand thus are not crash-safe and cannot be used onstandby servers

CREATE INDEX hash_txt_index ON hash_txt_heap USING hash (random text_ops);

WARNING: hash indexes are not WAL-loggedso they are not crash-safe and cannot be used onstreaming standbys

WARNING: hash indexes are not WAL-loggedand thus are not crash-safe and cannot be used onstandby servers

CREATE INDEX hash_f8_index ON hash_f8_heap USING hash (random float8_ops);

WARNING: hash indexes are not WAL-loggedso they are not crash-safe and cannot be used onstreaming standbys

WARNING: hash indexes are not WAL-loggedand thus are not crash-safe and cannot be used onstandby servers

-- CREATE INDEX hash_ovfl_index ON hash_ovfl_heap USING hash (x int4_ops);

--

-- Test functional index

-- Hash index / opclass with the = operator

--

CREATE INDEX enumtest_hash ON enumtest USING hash (col);

WARNING: hash indexes are not WAL-loggedso they are not crash-safe and cannot be used onstreaming standbys

WARNING: hash indexes are not WAL-loggedand thus are not crash-safe and cannot be used onstandby servers

SELECT * FROM enumtest WHERE col = 'orange';

col

--------

CREATE INDEX macaddr_data_btree ON macaddr_data USING btree (b);

CREATE INDEX macaddr_data_hash ON macaddr_data USING hash (b);

WARNING: hash indexes are not WAL-loggedso they are not crash-safe and cannot be used onstreaming standbys

WARNING: hash indexes are not WAL-loggedand thus are not crash-safe and cannot be used onstandby servers

SELECT a, b, trunc(b) FROM macaddr_data ORDER BY 2, 1;

a | b | trunc

----+-------------------+-------------------

CREATE UNIQUE INDEX test_replica_identity_keyab_key ON test_replica_identity (keya, keyb);

CREATE UNIQUE INDEX test_replica_identity_nonkey ON test_replica_identity (keya, nonkey);

CREATE INDEX test_replica_identity_hash ON test_replica_identity USING hash (nonkey);

WARNING: hash indexes are not WAL-loggedso they are not crash-safe and cannot be used onstreaming standbys

WARNING: hash indexes are not WAL-loggedand thus are not crash-safe and cannot be used onstandby servers

CREATE UNIQUE INDEX test_replica_identity_expr ON test_replica_identity (keya, keyb, (3));

CREATE UNIQUE INDEX test_replica_identity_partial ON test_replica_identity (keya, keyb) WHERE keyb != '3';

-- default is 'd'/DEFAULT for user created tables

-- btree and hash index creation test

CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field);

CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field);

WARNING: hash indexes are not WAL-loggedso they are not crash-safe and cannot be used onstreaming standbys

WARNING: hash indexes are not WAL-loggedand thus are not crash-safe and cannot be used onstandby servers

-- unique index test

CREATE UNIQUE INDEX guid1_unique_BTREE ON guid1 USING BTREE (guid_field);

-- should fail