summaryrefslogtreecommitdiff
path: root/docs/ref/databases.txt
diff options
context:
space:
mode:
authorJacob Kaplan-Moss <jacob@jacobian.org>2011-04-22 12:14:54 +0000
committerJacob Kaplan-Moss <jacob@jacobian.org>2011-04-22 12:14:54 +0000
commit5b0e4e49d4ab5e976fbfdde70c525a13220f3259 (patch)
tree5e09c9c9eedefb8b0d815c0214afc09b4db76653 /docs/ref/databases.txt
parent598032b8c4ec7d642b6223af8569bef81d183385 (diff)
Fixed #14091 - be more correct about logging queries in connection.queries.
Thanks to Aymeric Augustin for figuring out how to make this work across multiple databases. git-svn-id: http://code.djangoproject.com/svn/django/trunk@16081 bcc190cf-cafb-0310-a4f2-bffc1f526a37
Diffstat (limited to 'docs/ref/databases.txt')
-rw-r--r--docs/ref/databases.txt12
1 files changed, 11 insertions, 1 deletions
diff --git a/docs/ref/databases.txt b/docs/ref/databases.txt
index fb97c9f045..82c780cb0f 100644
--- a/docs/ref/databases.txt
+++ b/docs/ref/databases.txt
@@ -465,7 +465,7 @@ itself to versions newer than the ones included with your particular Python
binary distribution, if needed.
"Database is locked" errors
------------------------------------------------
+---------------------------
SQLite is meant to be a lightweight database, and thus can't support a high
level of concurrency. ``OperationalError: database is locked`` errors indicate
@@ -506,6 +506,16 @@ If you're getting this error, you can solve it by:
SQLite does not support the ``SELECT ... FOR UPDATE`` syntax. Calling it will
have no effect.
+.. _sqlite-connection-queries:
+
+Parameters not quoted in ``connection.queries``
+-----------------------------------------------
+
+``sqlite3`` does not provide a way to retrieve the SQL after quoting and
+substituting the parameters. Instead, the SQL in ``connection.queries`` is
+rebuilt with a simple string interpolation. It may be incorrect. Make sure
+you add quotes where necessary before copying a query into a SQLite shell.
+
.. _oracle-notes:
Oracle notes