Inconsistent capitalisation of keywords
21ALTER TABLE midprimarykeyswapcleanup ALTER COLUMN a SET NOT NULL;
22ALTER TABLE midprimarykeyswapcleanup ALTER PRIMARY KEY USING COLUMNS (a);
23BACKUP defaultdb.* TO 'nodelocal://1/midprimarykeyswapcleanup';
24DROP TABLE midprimarykeyswapcleanup;Inconsistent capitalisation of keywords
21ALTER TABLE midprimarykeyswapcleanup ALTER COLUMN a SET NOT NULL;
22ALTER TABLE midprimarykeyswapcleanup ALTER PRIMARY KEY USING COLUMNS (a);
23BACKUP defaultdb.* TO 'nodelocal://1/midprimarykeyswapcleanup';
24DROP TABLE midprimarykeyswapcleanup;Inconsistent capitalisation of keywords
19CREATE TABLE midprimarykeyswapcleanup AS SELECT * FROM generate_series(1,3) AS a;
20-- This schema change is used to enable the primary key swap. The backup is not taken during this schema change.
21ALTER TABLE midprimarykeyswapcleanup ALTER COLUMN a SET NOT NULL;
22ALTER TABLE midprimarykeyswapcleanup ALTER PRIMARY KEY USING COLUMNS (a);23BACKUP defaultdb.* TO 'nodelocal://1/midprimarykeyswapcleanup';
24DROP TABLE midprimarykeyswapcleanup;Inconsistent capitalisation of keywords
19CREATE TABLE midprimarykeyswapcleanup AS SELECT * FROM generate_series(1,3) AS a;
20-- This schema change is used to enable the primary key swap. The backup is not taken during this schema change.
21ALTER TABLE midprimarykeyswapcleanup ALTER COLUMN a SET NOT NULL;
22ALTER TABLE midprimarykeyswapcleanup ALTER PRIMARY KEY USING COLUMNS (a);23BACKUP defaultdb.* TO 'nodelocal://1/midprimarykeyswapcleanup';
24DROP TABLE midprimarykeyswapcleanup;Inconsistent capitalisation of keywords
18
19CREATE TABLE midprimarykeyswapcleanup AS SELECT * FROM generate_series(1,3) AS a;
20-- This schema change is used to enable the primary key swap. The backup is not taken during this schema change.
21ALTER TABLE midprimarykeyswapcleanup ALTER COLUMN a SET NOT NULL;22ALTER TABLE midprimarykeyswapcleanup ALTER PRIMARY KEY USING COLUMNS (a);
23BACKUP defaultdb.* TO 'nodelocal://1/midprimarykeyswapcleanup';
24DROP TABLE midprimarykeyswapcleanup;Inconsistent capitalisation of keywords
18
19CREATE TABLE midprimarykeyswapcleanup AS SELECT * FROM generate_series(1,3) AS a;
20-- This schema change is used to enable the primary key swap. The backup is not taken during this schema change.
21ALTER TABLE midprimarykeyswapcleanup ALTER COLUMN a SET NOT NULL;22ALTER TABLE midprimarykeyswapcleanup ALTER PRIMARY KEY USING COLUMNS (a);
23BACKUP defaultdb.* TO 'nodelocal://1/midprimarykeyswapcleanup';
24DROP TABLE midprimarykeyswapcleanup;Inconsistent capitalisation of keywords
14 a+(b*c), (a+b)*c -- ditto
15
16
17INSERT INTO mnop (m, n) SELECT i, (1e9 + i/2e4)::float FROM generate_series(1, 2e4) AS i(i) RETURNING NOTHING18
19CREATE TABLE midprimarykeyswapcleanup AS SELECT * FROM generate_series(1,3) AS a;
20-- This schema change is used to enable the primary key swap. The backup is not taken during this schema change.Inconsistent capitalisation of keywords
14 a+(b*c), (a+b)*c -- ditto
15
16
17INSERT INTO mnop (m, n) SELECT i, (1e9 + i/2e4)::float FROM generate_series(1, 2e4) AS i(i) RETURNING NOTHING18
19CREATE TABLE midprimarykeyswapcleanup AS SELECT * FROM generate_series(1,3) AS a;
20-- This schema change is used to enable the primary key swap. The backup is not taken during this schema change.
Description
All keywords should be of same case to maintain consistency.
The defaults can be configured per your needs with the following parameters.
| Parameter | Type | Default value |
|---|---|---|
| capitalisation_policy | String | "consistent" |
Other vaules are: "upper", "lower", "capitalise".
Bad practice
In this example, ‘select ‘is in lower-case whereas ‘FROM’ is in upper-case.
select
a
FROM foo
Recommended
Make all keywords either in upper-case or in lower-case
SELECT
a
FROM foo
-- Also good
select
a
from foo