Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit366c7fc

Browse files
committed
Merge branch 'PGPROEE9_6' into PGPROEE9_6_RDMA
2 parents5d16dfb +86242c1 commit366c7fc

File tree

5 files changed

+1494
-952
lines changed

5 files changed

+1494
-952
lines changed

‎contrib/rum/expected/orderby_1.out

Lines changed: 5 additions & 19 deletions
Original file line numberDiff line numberDiff line change
@@ -332,7 +332,7 @@ RESET enable_bitmapscan;
332332
SET enable_seqscan = off;
333333
DROP INDEX tsts_idx;
334334
CREATE INDEX tsts_id_idx ON tsts USING rum (t rum_tsvector_addon_ops, id, d)
335-
WITH (attach = 'd', to = 't');
335+
WITH (attach = 'd', to = 't');
336336
EXPLAIN (costs off)
337337
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 1::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
338338
QUERY PLAN
@@ -344,10 +344,7 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 1::int ORDER BY d <=> '2016-0
344344
(4 rows)
345345

346346
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 1::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
347-
id | d
348-
----+---
349-
(0 rows)
350-
347+
ERROR: doesn't support order by over pass-by-reference column
351348
EXPLAIN (costs off)
352349
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 355::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
353350
QUERY PLAN
@@ -359,11 +356,7 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 355::int ORDER BY d <=> '2016
359356
(4 rows)
360357

361358
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 355::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
362-
id | d
363-
-----+---------------------------------
364-
355 | Mon May 16 14:21:22.326724 2016
365-
(1 row)
366-
359+
ERROR: doesn't support order by over pass-by-reference column
367360
EXPLAIN (costs off)
368361
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2016-05-11 11:21:22.326724'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
369362
QUERY PLAN
@@ -375,11 +368,7 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2016-05-11 11:21:22.326724'::
375368
(4 rows)
376369

377370
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2016-05-11 11:21:22.326724'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
378-
id | d
379-
-----+---------------------------------
380-
232 | Wed May 11 11:21:22.326724 2016
381-
(1 row)
382-
371+
ERROR: doesn't support order by over pass-by-reference column
383372
EXPLAIN (costs off)
384373
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2000-05-01'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
385374
QUERY PLAN
@@ -391,7 +380,4 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2000-05-01'::timestamp ORDER
391380
(4 rows)
392381

393382
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2000-05-01'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
394-
id | d
395-
----+---
396-
(0 rows)
397-
383+
ERROR: doesn't support order by over pass-by-reference column

‎contrib/rum/expected/orderby_hash_1.out

Lines changed: 4 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -344,10 +344,7 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 1::int ORDER BY d <=> '2016-0
344344
(4 rows)
345345

346346
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 1::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
347-
id | d
348-
----+---
349-
(0 rows)
350-
347+
ERROR: doesn't support order by over pass-by-reference column
351348
EXPLAIN (costs off)
352349
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 355::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
353350
QUERY PLAN
@@ -359,11 +356,7 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 355::int ORDER BY d <=> '2016
359356
(4 rows)
360357

361358
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 355::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
362-
id | d
363-
-----+---------------------------------
364-
355 | Mon May 16 14:21:22.326724 2016
365-
(1 row)
366-
359+
ERROR: doesn't support order by over pass-by-reference column
367360
EXPLAIN (costs off)
368361
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2016-05-11 11:21:22.326724'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
369362
QUERY PLAN
@@ -375,11 +368,7 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2016-05-11 11:21:22.326724'::
375368
(4 rows)
376369

377370
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2016-05-11 11:21:22.326724'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
378-
id | d
379-
-----+---------------------------------
380-
232 | Wed May 11 11:21:22.326724 2016
381-
(1 row)
382-
371+
ERROR: doesn't support order by over pass-by-reference column
383372
EXPLAIN (costs off)
384373
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2000-05-01'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
385374
QUERY PLAN
@@ -391,7 +380,4 @@ SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2000-05-01'::timestamp ORDER
391380
(4 rows)
392381

393382
SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2000-05-01'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5;
394-
id | d
395-
----+---
396-
(0 rows)
397-
383+
ERROR: doesn't support order by over pass-by-reference column

‎doc/src/sgml/multimaster.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -127,8 +127,8 @@ of tables without primary keys by setting the <varname>multimaster.ignore_tables
127127
</listitem>
128128
</itemizedlist>
129129
<para>If you have any data that must be present on one of the nodes only, you can exclude a particular table from replication, as follows:
130-
<programlisting>SELECT * FROM <function>mtm.make_table_local</function>(::regclass::oid) </programlisting>
131-
where <literal>regclass</literal> is the name of the table and <literal>oid</literal> is the unique table identifier.</para>
130+
<programlisting>SELECT * FROM <function>mtm.make_table_local</function>('table_name') </programlisting>
131+
</para>
132132
</sect2>
133133

134134
<sect2 id="multimaster-architecture">

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp