Skip to content

Commit 9e17f2a

Browse files
author
Alexander Korotkov
committed
Convert spaces to tabs in SQL-files.
1 parent 51f148b commit 9e17f2a

File tree

5 files changed

+1137
-1137
lines changed

5 files changed

+1137
-1137
lines changed

‎contrib/pg_pathman/expected/pg_pathman.out

Lines changed: 17 additions & 17 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,8 @@ CREATE SCHEMA pathman;
33
CREATE EXTENSION pg_pathman SCHEMA pathman;
44
CREATE SCHEMA test;
55
CREATE TABLE test.hash_rel (
6-
id SERIAL PRIMARY KEY,
7-
value INTEGER);
6+
id SERIAL PRIMARY KEY,
7+
value INTEGER);
88
INSERT INTO test.hash_rel VALUES (1, 1);
99
INSERT INTO test.hash_rel VALUES (2, 2);
1010
INSERT INTO test.hash_rel VALUES (3, 3);
@@ -48,9 +48,9 @@ SELECT COUNT(*) FROM ONLY test.hash_rel;
4848
(1 row)
4949

5050
CREATE TABLE test.range_rel (
51-
id SERIAL PRIMARY KEY,
52-
dt TIMESTAMP,
53-
txt TEXT);
51+
id SERIAL PRIMARY KEY,
52+
dt TIMESTAMP,
53+
txt TEXT);
5454
CREATE INDEX ON test.range_rel (dt);
5555
INSERT INTO test.range_rel (dt, txt)
5656
SELECT g, md5(g::TEXT) FROM generate_series('2015-01-01', '2015-04-30', '1 day'::interval) as g;
@@ -80,8 +80,8 @@ SELECT COUNT(*) FROM ONLY test.range_rel;
8080
(1 row)
8181

8282
CREATE TABLE test.num_range_rel (
83-
id SERIAL PRIMARY KEY,
84-
txt TEXT);
83+
id SERIAL PRIMARY KEY,
84+
txt TEXT);
8585
SELECT pathman.create_range_partitions('test.num_range_rel', 'id', 0, 1000, 4);
8686
NOTICE: sequence "num_range_rel_seq" does not exist, skipping
8787
NOTICE: Copying data to partitions...
@@ -103,7 +103,7 @@ SELECT COUNT(*) FROM ONLY test.num_range_rel;
103103
(1 row)
104104

105105
INSERT INTO test.num_range_rel
106-
SELECT g, md5(g::TEXT) FROM generate_series(1, 3000) as g;
106+
SELECT g, md5(g::TEXT) FROM generate_series(1, 3000) as g;
107107
SELECT COUNT(*) FROM test.num_range_rel;
108108
count
109109
-------
@@ -620,8 +620,8 @@ DROP TABLE test.range_rel CASCADE;
620620
NOTICE: drop cascades to 7 other objects
621621
/* Test automatic partition creation */
622622
CREATE TABLE test.range_rel (
623-
id SERIAL PRIMARY KEY,
624-
dt TIMESTAMP NOT NULL);
623+
id SERIAL PRIMARY KEY,
624+
dt TIMESTAMP NOT NULL);
625625
SELECT pathman.create_range_partitions('test.range_rel', 'dt', '2015-01-01'::DATE, '10 days'::INTERVAL, 1);
626626
NOTICE: Copying data to partitions...
627627
create_range_partitions
@@ -670,8 +670,8 @@ SELECT * FROM pathman.pathman_config;
670670

671671
/* Check overlaps */
672672
CREATE TABLE test.num_range_rel (
673-
id SERIAL PRIMARY KEY,
674-
txt TEXT);
673+
id SERIAL PRIMARY KEY,
674+
txt TEXT);
675675
SELECT pathman.create_range_partitions('test.num_range_rel', 'id', 1000, 1000, 4);
676676
NOTICE: Copying data to partitions...
677677
create_range_partitions
@@ -726,8 +726,8 @@ DROP EXTENSION pg_pathman;
726726
CREATE EXTENSION pg_pathman;
727727
/* Hash */
728728
CREATE TABLE hash_rel (
729-
id SERIAL PRIMARY KEY,
730-
value INTEGER NOT NULL);
729+
id SERIAL PRIMARY KEY,
730+
value INTEGER NOT NULL);
731731
INSERT INTO hash_rel (value) SELECT g FROM generate_series(1, 10000) as g;
732732
SELECT create_hash_partitions('hash_rel', 'value', 3);
733733
NOTICE: function hash_rel_hash_insert_trigger_func() does not exist, skipping
@@ -752,9 +752,9 @@ EXPLAIN (COSTS OFF) SELECT * FROM hash_rel WHERE id = 1234;
752752

753753
/* Range */
754754
CREATE TABLE range_rel (
755-
id SERIAL PRIMARY KEY,
756-
dt TIMESTAMP NOT NULL,
757-
value INTEGER);
755+
id SERIAL PRIMARY KEY,
756+
dt TIMESTAMP NOT NULL,
757+
value INTEGER);
758758
INSERT INTO range_rel (dt, value) SELECT g, extract(day from g) FROM generate_series('2010-01-01'::date, '2010-12-31'::date, '1 day') as g;
759759
SELECT create_range_partitions('range_rel', 'dt', '2010-01-01'::date, '1 month'::interval, 12);
760760
NOTICE: sequence "range_rel_seq" does not exist, skipping

0 commit comments

Comments
 (0)