diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2003-11-06 22:08:15 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2003-11-06 22:08:15 +0000 |
| commit | 96889392e915e5c77384d274db2a2c42b684c274 (patch) | |
| tree | 06f115dec005a18d591bf4a389391a84cf6cef00 /src/backend/parser | |
| parent | 144a2ecd57590c6cce9981a2b28cee5f5805bd5d (diff) | |
| download | postgresql-96889392e915e5c77384d274db2a2c42b684c274.tar.gz postgresql-96889392e915e5c77384d274db2a2c42b684c274.zip | |
Implement isolation levels read uncommitted and repeatable read as acting
like the next higher one.
Diffstat (limited to 'src/backend/parser')
| -rw-r--r-- | src/backend/parser/gram.y | 14 | ||||
| -rw-r--r-- | src/backend/parser/keywords.c | 4 |
2 files changed, 12 insertions, 6 deletions
diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y index b73aa6f9eef..5f0b0f4e5da 100644 --- a/src/backend/parser/gram.y +++ b/src/backend/parser/gram.y @@ -11,7 +11,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.436 2003/10/02 06:34:04 petere Exp $ + * $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.437 2003/11/06 22:08:14 petere Exp $ * * HISTORY * AUTHOR DATE MAJOR EVENT @@ -342,7 +342,7 @@ static void doNegateFloat(Value *v); DATABASE DAY_P DEALLOCATE DEC DECIMAL_P DECLARE DEFAULT DEFAULTS DEFERRABLE DEFERRED DEFINER DELETE_P DELIMITER DELIMITERS - DESC DISTINCT DO DOMAIN_P DOUBLE_P DROP + DESC DISTINCT DO DOMAIN_P DOUBLE_P DROP EACH ELSE ENCODING ENCRYPTED END_P ESCAPE EXCEPT EXCLUDING EXCLUSIVE EXECUTE EXISTS EXPLAIN EXTERNAL EXTRACT @@ -380,7 +380,7 @@ static void doNegateFloat(Value *v); PRECISION PRESERVE PREPARE PRIMARY PRIOR PRIVILEGES PROCEDURAL PROCEDURE - READ REAL RECHECK REFERENCES REINDEX RELATIVE_P RENAME REPLACE + READ REAL RECHECK REFERENCES REINDEX RELATIVE_P RENAME REPEATABLE REPLACE RESET RESTART RESTRICT RETURNS REVOKE RIGHT ROLLBACK ROW ROWS RULE @@ -393,7 +393,7 @@ static void doNegateFloat(Value *v); TO TOAST TRAILING TRANSACTION TREAT TRIGGER TRIM TRUE_P TRUNCATE TRUSTED TYPE_P - UNENCRYPTED UNION UNIQUE UNKNOWN UNLISTEN UNTIL + UNCOMMITTED UNENCRYPTED UNION UNIQUE UNKNOWN UNLISTEN UNTIL UPDATE USAGE USER USING VACUUM VALID VALIDATOR VALUES VARCHAR VARYING @@ -922,7 +922,9 @@ var_value: opt_boolean { $$ = makeAConst($1); } ; -iso_level: READ COMMITTED { $$ = "read committed"; } +iso_level: READ UNCOMMITTED { $$ = "read uncommitted"; } + | READ COMMITTED { $$ = "read committed"; } + | REPEATABLE READ { $$ = "repeatable read"; } | SERIALIZABLE { $$ = "serializable"; } ; @@ -7407,6 +7409,7 @@ unreserved_keyword: | REINDEX | RELATIVE_P | RENAME + | REPEATABLE | REPLACE | RESET | RESTART @@ -7445,6 +7448,7 @@ unreserved_keyword: | TRUNCATE | TRUSTED | TYPE_P + | UNCOMMITTED | UNENCRYPTED | UNKNOWN | UNLISTEN diff --git a/src/backend/parser/keywords.c b/src/backend/parser/keywords.c index c4048b4c1d8..6d42a13ef87 100644 --- a/src/backend/parser/keywords.c +++ b/src/backend/parser/keywords.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/parser/keywords.c,v 1.141 2003/08/04 02:40:01 momjian Exp $ + * $Header: /cvsroot/pgsql/src/backend/parser/keywords.c,v 1.142 2003/11/06 22:08:15 petere Exp $ * *------------------------------------------------------------------------- */ @@ -251,6 +251,7 @@ static const ScanKeyword ScanKeywords[] = { {"reindex", REINDEX}, {"relative", RELATIVE_P}, {"rename", RENAME}, + {"repeatable", REPEATABLE}, {"replace", REPLACE}, {"reset", RESET}, {"restart", RESTART}, @@ -307,6 +308,7 @@ static const ScanKeyword ScanKeywords[] = { {"truncate", TRUNCATE}, {"trusted", TRUSTED}, {"type", TYPE_P}, + {"uncommitted", UNCOMMITTED}, {"unencrypted", UNENCRYPTED}, {"union", UNION}, {"unique", UNIQUE}, |