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

Commitd68ccf5

Browse files
committed
Remove double-quoting of table names in clusterdb. BACKWARD COMPABILITY
BREAKAGE.Remove double-quoting of index/table names in reindexdb. BACKWARDCOMPABILITY BREAKAGE.Document thate user/database names are preserved with double-quoting bycommand-line tools like vacuumdb.
1 parent52ce205 commitd68ccf5

File tree

8 files changed

+21
-6
lines changed

8 files changed

+21
-6
lines changed

‎doc/src/sgml/ref/createdb.sgml

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -90,7 +90,8 @@ PostgreSQL documentation
9090
<term><option>--tablespace=<replaceable class="parameter">tablespace</replaceable></></term>
9191
<listitem>
9292
<para>
93-
Specifies the default tablespace for the database.
93+
Specifies the default tablespace for the database. (This name
94+
is processed as a double-quoted identifier.)
9495
</para>
9596
</listitem>
9697
</varlistentry>
@@ -154,6 +155,7 @@ PostgreSQL documentation
154155
<listitem>
155156
<para>
156157
Specifies the database user who will own the new database.
158+
(This name is processed as a double-quoted identifier.)
157159
</para>
158160
</listitem>
159161
</varlistentry>
@@ -163,7 +165,8 @@ PostgreSQL documentation
163165
<term><option>--template=<replaceable class="parameter">template</replaceable></></term>
164166
<listitem>
165167
<para>
166-
Specifies the template database from which to build this database.
168+
Specifies the template database from which to build this
169+
database. (This name is processed as a double-quoted identifier.)
167170
</para>
168171
</listitem>
169172
</varlistentry>

‎doc/src/sgml/ref/createlang.sgml

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -70,7 +70,8 @@ PostgreSQL documentation
7070
<term><replaceable class="parameter">langname</replaceable></term>
7171
<listitem>
7272
<para>
73-
Specifies the name of the procedural language to be installed.
73+
Specifies the name of the procedural language to be
74+
installed. (This name is lower-cased.)
7475
</para>
7576
</listitem>
7677
</varlistentry>

‎doc/src/sgml/ref/droplang.sgml

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -73,6 +73,7 @@ PostgreSQL documentation
7373
<listitem>
7474
<para>
7575
Specifies the name of the procedural language to be removed.
76+
(This name is lower-cased.)
7677
</para>
7778
</listitem>
7879
</varlistentry>

‎doc/src/sgml/reference.sgml

Lines changed: 8 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -198,6 +198,14 @@
198198
applications is that they can be run on any host, independent of
199199
where the database server resides.
200200
</para>
201+
202+
<para>
203+
When specified on the command line, user and databases names have
204+
their case preserved &mdash; the presence of spaces or special
205+
characters might require quoting. Table names and other identifiers
206+
do not have their case preserved, except where documented, and
207+
might require quoting.
208+
</para>
201209
</partintro>
202210

203211
&clusterdb;

‎src/bin/scripts/clusterdb.c

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -177,7 +177,7 @@ cluster_one_database(const char *dbname, bool verbose, const char *table,
177177
if (verbose)
178178
appendPQExpBuffer(&sql," VERBOSE");
179179
if (table)
180-
appendPQExpBuffer(&sql," %s",fmtId(table));
180+
appendPQExpBuffer(&sql," %s",table);
181181
appendPQExpBuffer(&sql,";\n");
182182

183183
conn=connectDatabase(dbname,host,port,username,prompt_password,progname);

‎src/bin/scripts/createlang.c

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -164,6 +164,7 @@ main(int argc, char *argv[])
164164
exit(1);
165165
}
166166

167+
/* lower case language name */
167168
for (p=langname;*p;p++)
168169
if (*p >='A'&&*p <='Z')
169170
*p+= ('a'-'A');

‎src/bin/scripts/droplang.c

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -165,6 +165,7 @@ main(int argc, char *argv[])
165165
exit(1);
166166
}
167167

168+
/* lower case language name */
168169
for (p=langname;*p;p++)
169170
if (*p >='A'&&*p <='Z')
170171
*p+= ('a'-'A');

‎src/bin/scripts/reindexdb.c

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -223,9 +223,9 @@ reindex_one_database(const char *name, const char *dbname, const char *type,
223223

224224
appendPQExpBuffer(&sql,"REINDEX");
225225
if (strcmp(type,"TABLE")==0)
226-
appendPQExpBuffer(&sql," TABLE %s",fmtId(name));
226+
appendPQExpBuffer(&sql," TABLE %s",name);
227227
elseif (strcmp(type,"INDEX")==0)
228-
appendPQExpBuffer(&sql," INDEX %s",fmtId(name));
228+
appendPQExpBuffer(&sql," INDEX %s",name);
229229
elseif (strcmp(type,"DATABASE")==0)
230230
appendPQExpBuffer(&sql," DATABASE %s",fmtId(name));
231231
appendPQExpBuffer(&sql,";\n");

0 commit comments

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