Meanwhile, database names with single quotes in names don't work very well

Bruce Momjian <bruce@momjian.us>

Commit: 11023eb1f5bd4fe6ddff652957848437b5d16f14
Author: Bruce Momjian <bruce@momjian.us>
Date: 1999-12-12T05:15:10Z
Releases: 7.1.1
Meanwhile, database names with single quotes in names don't work very well
at all, and because of shell quoting rules this can't be fixed, so I put
in error messages to that end.

Also, calling create or drop database in a transaction block is not so
good either, because the file system mysteriously refuses to roll back rm
calls on transaction aborts. :) So I put in checks to see if a transaction
is in progress and signal an error.

Also I put the whole call in a transaction of its own to be able to roll
back changes to pg_database in case the file system operations fail.

The alternative location issues I posted recently were untouched, awaiting
the outcome of that discussion. Other than that, this should be much more
fool-proof now.

The docs I cleaned up as well.

Peter Eisentraut                  Sernanders väg 10:115

Files

PathChange+/−
doc/src/sgml/ref/create_database.sgml modified +94 −33
doc/src/sgml/ref/drop_database.sgml modified +73 −23
doc/TODO modified +1 −1
src/backend/commands/dbcommands.c modified +67 −21