From 155b5808cac496eef1dd2602694a934530cedcd7 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 3 Jun 1999 20:42:18 +0000 Subject: [PATCH] Thanks for this, but SET TRANSACTION ISOLATION LEVEL should be described like SET TIME ZONE: TO is not allowed, as well as DEFAULT option. There are only two forms: for Vadim. --- doc/src/sgml/ref/set.sgml | 4 ++-- src/bin/psql/psqlHelp.h | 4 ++-- src/man/set.l | 6 +++--- 3 files changed, 7 insertions(+), 7 deletions(-) diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index f60577f39b..cf9fbf22fb 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -530,7 +530,7 @@ SET TIME ZONE { 'timezone' | LOCAL - XACTISOLEVEL | TRANSACTION ISOLATION LEVEL + TRANSACTION ISOLATION LEVEL @@ -544,7 +544,7 @@ SET TIME ZONE { 'timezone' | LOCAL Sets the isolation level for transactions to - 'SERIALIZABLE' or 'COMMITTED'. + 'SERIALIZABLE' or 'READ COMMITTED'. diff --git a/src/bin/psql/psqlHelp.h b/src/bin/psql/psqlHelp.h index a14154345a..8f67df922b 100644 --- a/src/bin/psql/psqlHelp.h +++ b/src/bin/psql/psqlHelp.h @@ -5,7 +5,7 @@ * * Copyright (c) 1994, Regents of the University of California * - * $Id: psqlHelp.h,v 1.68 1999/06/03 19:52:08 momjian Exp $ + * $Id: psqlHelp.h,v 1.69 1999/06/03 20:42:17 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -331,7 +331,7 @@ TIMEZONE|XACTISOLEVEL|CLIENT_ENCODING|SERVER_ENCODING"}, \tSET KSQO TO 'ON'|'OFF'\n\ \tSET QUERY_LIMIT TO #\n\ \tSET TIMEZONE TO 'value'\n\ -\tSET XACTISOLEVEL|TRANSACTION ISOLATION LEVEL TO 'SERIALIZABLE'|'COMMITTED'\n\ +\tSET TRANSACTION ISOLATION LEVEL 'SERIALIZABLE'|'READ COMMITTED'\n\ \tSET CLIENT_ENCODING|NAMES TO 'EUC_JP'|'SJIS'|'EUC_CN'|'EUC_KR'|'EUC_TW'|\n\ \t 'BIG5'|'MULE_INTERNAL'|'LATIN1'|'LATIN2'|'LATIN3'|'LATIN4'|'LATIN5'|\n\ \t 'KOI8|'WIN'|'ALT'\n\ diff --git a/src/man/set.l b/src/man/set.l index b838341530..c281e9eaac 100644 --- a/src/man/set.l +++ b/src/man/set.l @@ -1,6 +1,6 @@ .\" This is -*-nroff-*- .\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.18 1999/06/03 18:38:00 momjian Exp $ +.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.19 1999/06/03 20:42:18 momjian Exp $ .TH SET SQL 05/14/97 PostgreSQL PostgreSQL .SH NAME set - set run-time parameters for session @@ -81,11 +81,11 @@ The default is unlimited. .IR TIMEZONE sets your timezone. .PP -.I XACTISOLEVEL|TRANSACTION ISOLATION LEVEL +.I TRANSACTION ISOLATION LEVEL sets the transaction isolation level to .IR SERIALIZABLE or -.IR COMMITTED . +.IR READ COMMITTED . .PP .IR CLIENT_ENCODING|NAMES sets the character set encoding of the client. Only available if multi-byte -- 2.40.0