Search.setIndex({"alltitles": {"Access to PostgreSQL large objects": [[17, "access-to-postgresql-large-objects"]], "Adaptation of Python values to SQL types": [[17, "adaptation-of-python-values-to-sql-types"]], "Adapting new Python types to SQL syntax": [[0, "adapting-new-python-types-to-sql-syntax"]], "Additional data types": [[6, "additional-data-types"]], "Additional database types": [[5, "additional-database-types"]], "Additional exceptions": [[5, "additional-exceptions"]], "Alternative licenses": [[10, "alternative-licenses"]], "Asynchronous notifications": [[0, "asynchronous-notifications"]], "Asynchronous support": [[0, "asynchronous-support"]], "Basic module usage": [[17, null]], "Best practices": [[7, "best-practices"]], "Binary adaptation": [[17, "binary-adaptation"]], "Build prerequisites": [[9, "build-prerequisites"]], "Change in binary packages between Psycopg 2.7 and 2.8": [[9, "change-in-binary-packages-between-psycopg-2-7-and-2-8"]], "Classes definitions": [[5, "classes-definitions"]], "Composite types casting": [[6, "composite-types-casting"]], "Connection and cursor factories": [[0, "connection-and-cursor-factories"]], "Connection and cursor subclasses": [[6, "connection-and-cursor-subclasses"]], "Connection status constants": [[5, "connection-status-constants"]], "Constants adaptation": [[17, "constants-adaptation"]], "Coroutine support": [[6, "coroutine-support"]], "Coroutines support functions": [[5, "coroutines-support-functions"]], "Creating a debug build": [[9, "creating-a-debug-build"]], "Current release": [[12, "current-release"]], "DB API extension": [[1, null], [1, null], [2, null], [2, null], [2, null], [2, null], [2, null], [2, null], [2, null], [2, null], [2, null], [2, null], [11, null], [11, null], [11, null]], "Database types casting functions": [[5, "database-types-casting-functions"]], "Date/Time objects adaptation": [[17, "date-time-objects-adaptation"]], "Dictionary-like cursor": [[6, "dictionary-like-cursor"]], "Exceptions": [[11, "exceptions"]], "Fast execution helpers": [[6, "fast-execution-helpers"]], "Frequently Asked Questions": [[7, null]], "Hstore data type": [[6, "hstore-data-type"]], "If you still have problems": [[9, "if-you-still-have-problems"]], "Infinite dates handling": [[17, "infinite-dates-handling"]], "Installation": [[9, null]], "Isolation level constants": [[5, "isolation-level-constants"]], "JSON adaptation": [[6, "json-adaptation"]], "License": [[10, null]], "Lists adaptation": [[17, "lists-adaptation"]], "Logging cursor": [[6, "logging-cursor"]], "Logical replication Quick-Start": [[0, "logical-replication-quick-start"]], "Meta": [[7, "meta"]], "Module usage": [[14, "module-usage"]], "More advanced topics": [[0, null]], "Networking data types": [[6, "networking-data-types"]], "Non-standard Python Implementation": [[9, "non-standard-python-implementation"]], "Non-standard builds": [[9, "non-standard-builds"]], "Numbers adaptation": [[17, "numbers-adaptation"]], "Other functions": [[5, "other-functions"]], "Passing parameters to SQL queries": [[17, "passing-parameters-to-sql-queries"]], "Poll constants": [[5, "poll-constants"]], "Prerequisites": [[9, "prerequisites"]], "Problems compiling and installing psycopg2": [[7, "problems-compiling-and-installing-psycopg2"]], "Problems with transactions handling": [[7, "problems-with-transactions-handling"]], "Problems with type conversions": [[7, "problems-with-type-conversions"]], "Psycopg \u2013 PostgreSQL database adapter for Python": [[8, null]], "Quick Install": [[9, "quick-install"]], "Range data types": [[6, "range-data-types"]], "Real dictionary cursor": [[6, "real-dictionary-cursor"]], "Release notes": [[12, null]], "Replication protocol support": [[0, "replication-protocol-support"]], "Replication support objects": [[6, "replication-support-objects"]], "Running the test suite": [[9, "running-the-test-suite"]], "Runtime requirements": [[9, "runtime-requirements"]], "SQL adaptation protocol objects": [[5, "sql-adaptation-protocol-objects"]], "SQLSTATE exception classes": [[4, "sqlstate-exception-classes"]], "Server side cursors": [[17, "server-side-cursors"]], "Strings adaptation": [[17, "strings-adaptation"]], "Support for coroutine libraries": [[0, "support-for-coroutine-libraries"]], "The connection class": [[1, null]], "The cursor class": [[2, null]], "The problem with the query parameters": [[17, "the-problem-with-the-query-parameters"]], "The psycopg2 module content": [[11, null]], "Thread and process safety": [[17, "thread-and-process-safety"]], "Time handling": [[17, "time-handling"]], "Time zones handling": [[17, "time-zones-handling"]], "Transaction status constants": [[5, "transaction-status-constants"]], "Transactions control": [[17, "transactions-control"]], "Tuples adaptation": [[17, "tuples-adaptation"]], "Two-Phase Commit protocol support": [[17, "two-phase-commit-protocol-support"]], "Type Objects and Constructors": [[11, "type-objects-and-constructors"]], "Type casting of SQL types into Python objects": [[0, "type-casting-of-sql-types-into-python-objects"]], "UUID data type": [[6, "uuid-data-type"]], "Unicode handling": [[17, "unicode-handling"]], "Using COPY TO and COPY FROM": [[17, "using-copy-to-and-copy-from"]], "Values containing backslashes and LIKE": [[17, "values-containing-backslashes-and-like"]], "What\u2019s new in psycopg 1.99.0": [[12, "what-s-new-in-psycopg-1-99-0"]], "What\u2019s new in psycopg 1.99.1": [[12, "what-s-new-in-psycopg-1-99-1"]], "What\u2019s new in psycopg 1.99.10": [[12, "what-s-new-in-psycopg-1-99-10"]], "What\u2019s new in psycopg 1.99.11": [[12, "what-s-new-in-psycopg-1-99-11"]], "What\u2019s new in psycopg 1.99.12": [[12, "what-s-new-in-psycopg-1-99-12"]], "What\u2019s new in psycopg 1.99.13": [[12, "what-s-new-in-psycopg-1-99-13"]], "What\u2019s new in psycopg 1.99.2": [[12, "what-s-new-in-psycopg-1-99-2"]], "What\u2019s new in psycopg 1.99.3": [[12, "what-s-new-in-psycopg-1-99-3"], [12, "id2"]], "What\u2019s new in psycopg 1.99.6": [[12, "what-s-new-in-psycopg-1-99-6"]], "What\u2019s new in psycopg 1.99.7": [[12, "what-s-new-in-psycopg-1-99-7"]], "What\u2019s new in psycopg 1.99.8": [[12, "what-s-new-in-psycopg-1-99-8"]], "What\u2019s new in psycopg 1.99.9": [[12, "what-s-new-in-psycopg-1-99-9"]], "What\u2019s new in psycopg 2.0": [[12, "what-s-new-in-psycopg-2-0"]], "What\u2019s new in psycopg 2.0 beta 1": [[12, "what-s-new-in-psycopg-2-0-beta-1"]], "What\u2019s new in psycopg 2.0 beta 2": [[12, "what-s-new-in-psycopg-2-0-beta-2"]], "What\u2019s new in psycopg 2.0 beta 3": [[12, "what-s-new-in-psycopg-2-0-beta-3"]], "What\u2019s new in psycopg 2.0 beta 4": [[12, "what-s-new-in-psycopg-2-0-beta-4"]], "What\u2019s new in psycopg 2.0 beta 5": [[12, "what-s-new-in-psycopg-2-0-beta-5"]], "What\u2019s new in psycopg 2.0 beta 6": [[12, "what-s-new-in-psycopg-2-0-beta-6"]], "What\u2019s new in psycopg 2.0 beta 7": [[12, "what-s-new-in-psycopg-2-0-beta-7"]], "What\u2019s new in psycopg 2.0.1": [[12, "what-s-new-in-psycopg-2-0-1"]], "What\u2019s new in psycopg 2.0.10": [[12, "what-s-new-in-psycopg-2-0-10"]], "What\u2019s new in psycopg 2.0.11": [[12, "what-s-new-in-psycopg-2-0-11"]], "What\u2019s new in psycopg 2.0.12": [[12, "what-s-new-in-psycopg-2-0-12"]], "What\u2019s new in psycopg 2.0.13": [[12, "what-s-new-in-psycopg-2-0-13"]], "What\u2019s new in psycopg 2.0.14": [[12, "what-s-new-in-psycopg-2-0-14"]], "What\u2019s new in psycopg 2.0.2": [[12, "what-s-new-in-psycopg-2-0-2"]], "What\u2019s new in psycopg 2.0.3": [[12, "what-s-new-in-psycopg-2-0-3"]], "What\u2019s new in psycopg 2.0.4": [[12, "what-s-new-in-psycopg-2-0-4"]], "What\u2019s new in psycopg 2.0.5": [[12, "what-s-new-in-psycopg-2-0-5"]], "What\u2019s new in psycopg 2.0.5.1": [[12, "what-s-new-in-psycopg-2-0-5-1"]], "What\u2019s new in psycopg 2.0.6": [[12, "what-s-new-in-psycopg-2-0-6"]], "What\u2019s new in psycopg 2.0.7": [[12, "what-s-new-in-psycopg-2-0-7"]], "What\u2019s new in psycopg 2.0.8": [[12, "what-s-new-in-psycopg-2-0-8"]], "What\u2019s new in psycopg 2.0.9": [[12, "what-s-new-in-psycopg-2-0-9"], [12, "id1"]], "What\u2019s new in psycopg 2.2": [[12, "what-s-new-in-psycopg-2-2"]], "What\u2019s new in psycopg 2.2.1": [[12, "what-s-new-in-psycopg-2-2-1"]], "What\u2019s new in psycopg 2.2.2": [[12, "what-s-new-in-psycopg-2-2-2"]], "What\u2019s new in psycopg 2.3": [[12, "what-s-new-in-psycopg-2-3"]], "What\u2019s new in psycopg 2.3.1": [[12, "what-s-new-in-psycopg-2-3-1"]], "What\u2019s new in psycopg 2.3.2": [[12, "what-s-new-in-psycopg-2-3-2"]], "What\u2019s new in psycopg 2.4": [[12, "what-s-new-in-psycopg-2-4"]], "What\u2019s new in psycopg 2.4.1": [[12, "what-s-new-in-psycopg-2-4-1"]], "What\u2019s new in psycopg 2.4.2": [[12, "what-s-new-in-psycopg-2-4-2"]], "What\u2019s new in psycopg 2.4.3": [[12, "what-s-new-in-psycopg-2-4-3"]], "What\u2019s new in psycopg 2.4.4": [[12, "what-s-new-in-psycopg-2-4-4"]], "What\u2019s new in psycopg 2.4.5": [[12, "what-s-new-in-psycopg-2-4-5"]], "What\u2019s new in psycopg 2.4.6": [[12, "what-s-new-in-psycopg-2-4-6"]], "What\u2019s new in psycopg 2.5": [[12, "what-s-new-in-psycopg-2-5"]], "What\u2019s new in psycopg 2.5.1": [[12, "what-s-new-in-psycopg-2-5-1"]], "What\u2019s new in psycopg 2.5.2": [[12, "what-s-new-in-psycopg-2-5-2"]], "What\u2019s new in psycopg 2.5.3": [[12, "what-s-new-in-psycopg-2-5-3"]], "What\u2019s new in psycopg 2.5.4": [[12, "what-s-new-in-psycopg-2-5-4"]], "What\u2019s new in psycopg 2.5.5": [[12, "what-s-new-in-psycopg-2-5-5"]], "What\u2019s new in psycopg 2.6": [[12, "what-s-new-in-psycopg-2-6"]], "What\u2019s new in psycopg 2.6.1": [[12, "what-s-new-in-psycopg-2-6-1"]], "What\u2019s new in psycopg 2.6.2": [[12, "what-s-new-in-psycopg-2-6-2"]], "What\u2019s new in psycopg 2.7": [[12, "what-s-new-in-psycopg-2-7"]], "What\u2019s new in psycopg 2.7.1": [[12, "what-s-new-in-psycopg-2-7-1"]], "What\u2019s new in psycopg 2.7.2": [[12, "what-s-new-in-psycopg-2-7-2"]], "What\u2019s new in psycopg 2.7.3": [[12, "what-s-new-in-psycopg-2-7-3"]], "What\u2019s new in psycopg 2.7.3.1": [[12, "what-s-new-in-psycopg-2-7-3-1"]], "What\u2019s new in psycopg 2.7.3.2": [[12, "what-s-new-in-psycopg-2-7-3-2"]], "What\u2019s new in psycopg 2.7.4": [[12, "what-s-new-in-psycopg-2-7-4"]], "What\u2019s new in psycopg 2.7.5": [[12, "what-s-new-in-psycopg-2-7-5"]], "What\u2019s new in psycopg 2.7.6": [[12, "what-s-new-in-psycopg-2-7-6"]], "What\u2019s new in psycopg 2.7.6.1": [[12, "what-s-new-in-psycopg-2-7-6-1"]], "What\u2019s new in psycopg 2.7.7": [[12, "what-s-new-in-psycopg-2-7-7"]], "What\u2019s new in psycopg 2.8": [[12, "what-s-new-in-psycopg-2-8"]], "What\u2019s new in psycopg 2.8.1": [[12, "what-s-new-in-psycopg-2-8-1"]], "What\u2019s new in psycopg 2.8.2": [[12, "what-s-new-in-psycopg-2-8-2"]], "What\u2019s new in psycopg 2.8.3": [[12, "what-s-new-in-psycopg-2-8-3"]], "What\u2019s new in psycopg 2.8.4": [[12, "what-s-new-in-psycopg-2-8-4"]], "What\u2019s new in psycopg 2.8.5": [[12, "what-s-new-in-psycopg-2-8-5"]], "What\u2019s new in psycopg 2.8.6": [[12, "what-s-new-in-psycopg-2-8-6"]], "What\u2019s new in psycopg 2.8.7": [[12, "what-s-new-in-psycopg-2-8-7"]], "What\u2019s new in psycopg 2.9": [[12, "what-s-new-in-psycopg-2-9"]], "What\u2019s new in psycopg 2.9.1": [[12, "what-s-new-in-psycopg-2-9-1"]], "What\u2019s new in psycopg 2.9.10": [[12, "what-s-new-in-psycopg-2-9-10"]], "What\u2019s new in psycopg 2.9.2": [[12, "what-s-new-in-psycopg-2-9-2"]], "What\u2019s new in psycopg 2.9.3": [[12, "what-s-new-in-psycopg-2-9-3"]], "What\u2019s new in psycopg 2.9.4": [[12, "what-s-new-in-psycopg-2-9-4"]], "What\u2019s new in psycopg 2.9.5": [[12, "what-s-new-in-psycopg-2-9-5"]], "What\u2019s new in psycopg 2.9.6": [[12, "what-s-new-in-psycopg-2-9-6"]], "What\u2019s new in psycopg 2.9.7": [[12, "what-s-new-in-psycopg-2-9-7"]], "What\u2019s new in psycopg 2.9.8": [[12, "what-s-new-in-psycopg-2-9-8"]], "What\u2019s new in psycopg 2.9.9": [[12, "what-s-new-in-psycopg-2-9-9"]], "namedtuple cursor": [[6, "namedtuple-cursor"]], "psycopg vs psycopg-binary": [[9, "psycopg-vs-psycopg-binary"]], "psycopg2 and the LGPL": [[10, "psycopg2-and-the-lgpl"]], "psycopg2.errorcodes \u2013 Error codes defined by PostgreSQL": [[3, null]], "psycopg2.errors \u2013 Exception classes mapping PostgreSQL errors": [[4, null]], "psycopg2.extensions \u2013 Extensions to the DB API": [[5, null]], "psycopg2.extras \u2013 Miscellaneous goodies for Psycopg 2": [[6, null]], "psycopg2.pool \u2013 Connections pooling": [[13, null]], "psycopg2.sql \u2013 SQL string composition": [[14, null]], "psycopg2.tz \u2013  tzinfo implementations for Psycopg 2": [[16, null]], "sql objects": [[14, "sql-objects"]], "with statement": [[17, "with-statement"]]}, "docnames": ["advanced", "connection", "cursor", "errorcodes", "errors", "extensions", "extras", "faq", "index", "install", "license", "module", "news", "pool", "sql", "sqlstate_errors", "tz", "usage"], "envversion": {"sphinx": 62, "sphinx.domains.c": 3, "sphinx.domains.changeset": 1, "sphinx.domains.citation": 1, "sphinx.domains.cpp": 9, "sphinx.domains.index": 1, "sphinx.domains.javascript": 3, "sphinx.domains.math": 2, "sphinx.domains.python": 4, "sphinx.domains.rst": 2, "sphinx.domains.std": 2, "sphinx.ext.intersphinx": 1, "sphinx.ext.todo": 2}, "filenames": ["advanced.rst", "connection.rst", "cursor.rst", "errorcodes.rst", "errors.rst", "extensions.rst", "extras.rst", "faq.rst", "index.rst", "install.rst", "license.rst", "module.rst", "news.rst", "pool.rst", "sql.rst", "sqlstate_errors.rst", "tz.rst", "usage.rst"], "indexentries": {"__libpq_version__ (in module psycopg2)": [[11, "psycopg2.__libpq_version__", false]], "_wrapped (psycopg2.extensions.isqlquote attribute)": [[5, "psycopg2.extensions.ISQLQuote._wrapped", false]], "abstractconnectionpool (class in psycopg2.pool)": [[13, "psycopg2.pool.AbstractConnectionPool", false]], "adapt() (in module psycopg2.extensions)": [[5, "psycopg2.extensions.adapt", false]], "adaptation": [[0, "index-2", false], [6, "index-10", false], [6, "index-8", false], [6, "index-9", false], [17, "index-12", false], [17, "index-13", false], [17, "index-3", false], [17, "index-4", false], [17, "index-5", false], [17, "index-6", false], [17, "index-8", false], [17, "index-9", false]], "adapter (psycopg2.extras.rangecaster attribute)": [[6, "psycopg2.extras.RangeCaster.adapter", false]], "adapters (in module psycopg2.extensions)": [[5, "psycopg2.extensions.adapters", false]], "additional": [[5, "index-3", false], [6, "index-7", false]], "apilevel (in module psycopg2)": [[11, "psycopg2.apilevel", false]], "archflags": [[9, "index-16", false]], "array": [[17, "index-12", false]], "array_oid (psycopg2.extras.compositecaster attribute)": [[6, "psycopg2.extras.CompositeCaster.array_oid", false]], "array_typecaster (psycopg2.extras.rangecaster attribute)": [[6, "psycopg2.extras.RangeCaster.array_typecaster", false]], "arraysize (cursor attribute)": [[2, "cursor.arraysize", false]], "as_string() (psycopg2.sql.composable method)": [[14, "psycopg2.sql.Composable.as_string", false]], "asis (class in psycopg2.extensions)": [[5, "psycopg2.extensions.AsIs", false]], "async (connection attribute)": [[1, "connection.async", false]], "async_ (connection attribute)": [[1, "connection.async_", false]], "asynchronous": [[0, "index-6", false], [0, "index-7", false]], "attnames (psycopg2.extras.compositecaster attribute)": [[6, "psycopg2.extras.CompositeCaster.attnames", false]], "atttypes (psycopg2.extras.compositecaster attribute)": [[6, "psycopg2.extras.CompositeCaster.atttypes", false]], "autocommit": [[1, "index-9", false], [17, "index-14", false]], "autocommit (connection attribute)": [[1, "connection.autocommit", false]], "backend": [[1, "index-17", false]], "backend_pid (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.backend_pid", false]], "begin": [[17, "index-14", false]], "binary (class in psycopg2.extensions)": [[5, "psycopg2.extensions.Binary", false]], "binary (in module psycopg2)": [[11, "psycopg2.BINARY", false]], "binary string": [[17, "index-8", false]], "binary() (in module psycopg2)": [[11, "psycopg2.Binary", false]], "binaryarray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.BINARYARRAY", false]], "boolean": [[17, "index-4", false]], "boolean (class in psycopg2.extensions)": [[5, "psycopg2.extensions.Boolean", false]], "boolean (in module psycopg2.extensions)": [[5, "psycopg2.extensions.BOOLEAN", false]], "booleanarray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.BOOLEANARRAY", false]], "bqual (psycopg2.extensions.xid attribute)": [[5, "psycopg2.extensions.Xid.bqual", false]], "buffer": [[17, "index-8", false]], "bytea": [[17, "index-8", false]], "bytearray": [[17, "index-8", false]], "bytes": [[17, "index-8", false]], "bytes (in module psycopg2.extensions)": [[5, "psycopg2.extensions.BYTES", false]], "bytesarray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.BYTESARRAY", false]], "callproc() (cursor method)": [[2, "cursor.callproc", false]], "cancel() (connection method)": [[1, "connection.cancel", false]], "cast() (cursor method)": [[2, "cursor.cast", false]], "channel (psycopg2.extensions.notify attribute)": [[5, "psycopg2.extensions.Notify.channel", false]], "cidr": [[6, "index-13", false]], "class": [[4, "index-0", false]], "client": [[1, "index-10", false], [1, "index-11", false]], "close() (connection method)": [[1, "connection.close", false]], "close() (cursor method)": [[2, "cursor.close", false]], "close() (psycopg2.extensions.lobject method)": [[5, "psycopg2.extensions.lobject.close", false]], "closeall() (psycopg2.pool.abstractconnectionpool method)": [[13, "psycopg2.pool.AbstractConnectionPool.closeall", false]], "closed (connection attribute)": [[1, "connection.closed", false]], "closed (cursor attribute)": [[2, "cursor.closed", false]], "closed (psycopg2.extensions.lobject attribute)": [[5, "psycopg2.extensions.lobject.closed", false]], "codes": [[3, "index-0", false]], "column (class in psycopg2.extensions)": [[5, "psycopg2.extensions.Column", false]], "column_name (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.column_name", false]], "commit": [[1, "index-0", false], [1, "index-6", false], [17, "index-14", false]], "commit() (connection method)": [[1, "connection.commit", false]], "composable (class in psycopg2.sql)": [[14, "psycopg2.sql.Composable", false]], "composed (class in psycopg2.sql)": [[14, "psycopg2.sql.Composed", false]], "composite types": [[6, "index-10", false]], "compositecaster (class in psycopg2.extras)": [[6, "psycopg2.extras.CompositeCaster", false]], "connect() (in module psycopg2)": [[11, "psycopg2.connect", false]], "connection": [[0, "index-0", false], [0, "index-7", false], [1, "index-12", false], [1, "index-13", false], [1, "index-19", false], [6, "index-3", false], [11, "index-0", false], [13, "index-0", false]], "connection (built-in class)": [[1, "connection", false]], "connection (class in psycopg2.extensions)": [[5, "psycopg2.extensions.connection", false]], "connection (cursor attribute)": [[2, "cursor.connection", false]], "connection pooling": [[13, "index-1", false]], "connection status": [[5, "index-6", false]], "connection string": [[11, "index-0", false]], "connectioninfo (class in psycopg2.extensions)": [[5, "psycopg2.extensions.ConnectionInfo", false]], "constants": [[5, "index-4", false], [5, "index-5", false], [5, "index-6", false], [5, "index-7", false]], "constraint_name (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.constraint_name", false]], "consume_stream() (psycopg2.extras.replicationcursor method)": [[6, "psycopg2.extras.ReplicationCursor.consume_stream", false]], "context (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.context", false]], "copy": [[17, "index-18", false]], "copy_expert() (cursor method)": [[2, "cursor.copy_expert", false]], "copy_from() (cursor method)": [[2, "cursor.copy_from", false]], "copy_to() (cursor method)": [[2, "cursor.copy_to", false]], "coroutine": [[0, "index-8", false]], "coroutine;": [[6, "index-14", false]], "create_replication_slot() (psycopg2.extras.replicationcursor method)": [[6, "psycopg2.extras.ReplicationCursor.create_replication_slot", false]], "creating new adapters": [[0, "index-2", false]], "cursor": [[0, "index-0", false], [6, "index-0", false], [6, "index-1", false], [6, "index-2", false], [6, "index-5", false], [6, "index-6", false], [17, "index-16", false]], "cursor (built-in class)": [[2, "cursor", false]], "cursor (class in psycopg2.extensions)": [[5, "psycopg2.extensions.cursor", false]], "cursor (psycopg2.error attribute)": [[11, "psycopg2.Error.cursor", false]], "cursor (psycopg2.extras.replicationmessage attribute)": [[6, "psycopg2.extras.ReplicationMessage.cursor", false]], "cursor subclass": [[0, "index-1", false]], "cursor() (connection method)": [[1, "connection.cursor", false]], "cursor_factory (connection attribute)": [[1, "connection.cursor_factory", false]], "data types": [[0, "index-2", false], [6, "index-10", false], [6, "index-11", false], [6, "index-12", false], [6, "index-13", false], [6, "index-7", false], [6, "index-8", false], [6, "index-9", false], [17, "index-3", false]], "data_size (psycopg2.extras.replicationmessage attribute)": [[6, "psycopg2.extras.ReplicationMessage.data_size", false]], "data_start (psycopg2.extras.replicationmessage attribute)": [[6, "psycopg2.extras.ReplicationMessage.data_start", false]], "database (psycopg2.extensions.xid attribute)": [[5, "psycopg2.extensions.Xid.database", false]], "databaseerror": [[11, "psycopg2.DatabaseError", false]], "dataerror": [[11, "psycopg2.DataError", false]], "datatype_name (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.datatype_name", false]], "date (in module psycopg2.extensions)": [[5, "psycopg2.extensions.DATE", false]], "date objects": [[17, "index-11", false], [17, "index-9", false]], "date() (in module psycopg2)": [[11, "psycopg2.Date", false]], "date/time objects": [[17, "index-9", false]], "datearray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.DATEARRAY", false]], "datefrompy (class in psycopg2.extensions)": [[5, "psycopg2.extensions.DateFromPy", false]], "datefromticks() (in module psycopg2)": [[11, "psycopg2.DateFromTicks", false]], "daterange (class in psycopg2.extras)": [[6, "psycopg2.extras.DateRange", false]], "datetime (in module psycopg2)": [[11, "psycopg2.DATETIME", false]], "datetimearray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.DATETIMEARRAY", false]], "datetimerange (class in psycopg2.extras)": [[6, "psycopg2.extras.DateTimeRange", false]], "datetimetzrange (class in psycopg2.extras)": [[6, "psycopg2.extras.DateTimeTZRange", false]], "db api": [[11, "index-1", false]], "dbname (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.dbname", false]], "debug": [[9, "index-9", false]], "decimal": [[17, "index-5", false]], "decimal (in module psycopg2.extensions)": [[5, "psycopg2.extensions.DECIMAL", false]], "decimalarray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.DECIMALARRAY", false]], "declare": [[17, "index-16", false]], "deferrable (connection attribute)": [[1, "connection.deferrable", false]], "description (cursor attribute)": [[2, "cursor.description", false]], "diag (psycopg2.error attribute)": [[11, "psycopg2.Error.diag", false]], "diagnostics (class in psycopg2.extensions)": [[5, "psycopg2.extensions.Diagnostics", false]], "dict": [[6, "index-9", false]], "dictconnection (class in psycopg2.extras)": [[6, "psycopg2.extras.DictConnection", false]], "dictcursor (class in psycopg2.extras)": [[6, "psycopg2.extras.DictCursor", false]], "dictionary": [[6, "index-0", false]], "dictrow (class in psycopg2.extras)": [[6, "psycopg2.extras.DictRow", false]], "disable": [[9, "index-1", false]], "disable wheel": [[9, "index-1", false]], "display_size (psycopg2.extensions.column attribute)": [[5, "psycopg2.extensions.Column.display_size", false]], "drop_replication_slot() (psycopg2.extras.replicationcursor method)": [[6, "psycopg2.extras.ReplicationCursor.drop_replication_slot", false]], "dsn (connection attribute)": [[1, "connection.dsn", false]], "dsn (database source name)": [[11, "index-0", false]], "dsn_parameters (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.dsn_parameters", false]], "dumps() (psycopg2.extras.json method)": [[6, "psycopg2.extras.Json.dumps", false]], "encoding": [[1, "index-10", false], [5, "index-2", false]], "encoding (connection attribute)": [[1, "connection.encoding", false]], "encodings (in module psycopg2.extensions)": [[5, "psycopg2.extensions.encodings", false]], "encrypt_password() (in module psycopg2.extensions)": [[5, "psycopg2.extensions.encrypt_password", false]], "environment variable": [[5, "index-1", false], [7, "index-0", false], [9, "index-10", false], [9, "index-12", false], [9, "index-13", false], [9, "index-14", false], [9, "index-15", false], [9, "index-16", false], [9, "index-3", false], [9, "index-4", false], [9, "index-5", false], [9, "index-6", false], [9, "index-8", false]], "error": [[3, "index-0", false], [4, "index-0", false], [11, "psycopg2.Error", false]], "error_message (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.error_message", false]], "eventlet": [[0, "index-8", false]], "example": [[0, "index-1", false], [0, "index-4", false], [6, "index-14", false], [17, "index-0", false]], "exceptions": [[1, "index-3", false], [5, "index-3", false], [11, "index-1", false]], "execute() (cursor method)": [[2, "cursor.execute", false]], "execute_batch() (in module psycopg2.extras)": [[6, "psycopg2.extras.execute_batch", false]], "execute_values() (in module psycopg2.extras)": [[6, "psycopg2.extras.execute_values", false]], "executemany() (cursor method)": [[2, "cursor.executemany", false]], "export() (psycopg2.extensions.lobject method)": [[5, "psycopg2.extensions.lobject.export", false]], "feedback_timestamp (psycopg2.extras.replicationcursor attribute)": [[6, "psycopg2.extras.ReplicationCursor.feedback_timestamp", false]], "fetch": [[17, "index-16", false]], "fetchall() (cursor method)": [[2, "cursor.fetchall", false]], "fetchmany() (cursor method)": [[2, "cursor.fetchmany", false]], "fetchone() (cursor method)": [[2, "cursor.fetchone", false]], "fileno() (connection method)": [[1, "connection.fileno", false]], "fileno() (psycopg2.extras.replicationcursor method)": [[6, "psycopg2.extras.ReplicationCursor.fileno", false]], "filter() (psycopg2.extras.loggingconnection method)": [[6, "psycopg2.extras.LoggingConnection.filter", false]], "filter() (psycopg2.extras.mintimeloggingconnection method)": [[6, "psycopg2.extras.MinTimeLoggingConnection.filter", false]], "fixedoffsettimezone (class in psycopg2.tz)": [[16, "psycopg2.tz.FixedOffsetTimezone", false]], "float": [[17, "index-5", false]], "float (class in psycopg2.extensions)": [[5, "psycopg2.extensions.Float", false]], "float (in module psycopg2.extensions)": [[5, "psycopg2.extensions.FLOAT", false]], "floatarray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.FLOATARRAY", false]], "format() (psycopg2.sql.sql method)": [[14, "psycopg2.sql.SQL.format", false]], "format_id (psycopg2.extensions.xid attribute)": [[5, "psycopg2.extensions.Xid.format_id", false]], "from pypi": [[9, "index-0", false]], "from_string() (psycopg2.extensions.xid static method)": [[5, "psycopg2.extensions.Xid.from_string", false]], "get_backend_pid() (connection method)": [[1, "connection.get_backend_pid", false]], "get_dsn_parameters() (connection method)": [[1, "connection.get_dsn_parameters", false]], "get_native_connection() (connection method)": [[1, "connection.get_native_connection", false]], "get_parameter_status() (connection method)": [[1, "connection.get_parameter_status", false]], "get_transaction_status() (connection method)": [[1, "connection.get_transaction_status", false]], "get_wait_callback() (in module psycopg2.extensions)": [[5, "psycopg2.extensions.get_wait_callback", false]], "getconn() (psycopg2.pool.abstractconnectionpool method)": [[13, "psycopg2.pool.AbstractConnectionPool.getconn", false]], "getquoted() (psycopg2.extensions.asis method)": [[5, "psycopg2.extensions.AsIs.getquoted", false]], "getquoted() (psycopg2.extensions.binary method)": [[5, "psycopg2.extensions.Binary.getquoted", false]], "getquoted() (psycopg2.extensions.isqlquote method)": [[5, "psycopg2.extensions.ISQLQuote.getquoted", false]], "getquoted() (psycopg2.extensions.quotedstring method)": [[5, "psycopg2.extensions.QuotedString.getquoted", false]], "gevent": [[0, "index-8", false]], "greenlet": [[0, "index-8", false]], "gtrid (psycopg2.extensions.xid attribute)": [[5, "psycopg2.extensions.Xid.gtrid", false]], "host": [[11, "index-0", false]], "host (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.host", false]], "hstore": [[6, "index-9", false]], "identifier (class in psycopg2.sql)": [[14, "psycopg2.sql.Identifier", false]], "in operator": [[17, "index-13", false]], "in the connection class": [[1, "index-3", false]], "inet": [[6, "index-13", false]], "inet (class in psycopg2.extras)": [[6, "psycopg2.extras.Inet", false]], "infinite": [[17, "index-11", false]], "info": [[1, "index-12", false]], "info (connection attribute)": [[1, "connection.info", false]], "initialize() (psycopg2.extras.loggingconnection method)": [[6, "psycopg2.extras.LoggingConnection.initialize", false]], "initialize() (psycopg2.extras.mintimeloggingconnection method)": [[6, "psycopg2.extras.MinTimeLoggingConnection.initialize", false]], "install": [[9, "index-0", false], [9, "index-1", false]], "integer": [[17, "index-5", false]], "integer (in module psycopg2.extensions)": [[5, "psycopg2.extensions.INTEGER", false]], "integerarray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.INTEGERARRAY", false]], "integrityerror": [[11, "psycopg2.IntegrityError", false]], "interfaceerror": [[11, "psycopg2.InterfaceError", false]], "internal_position (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.internal_position", false]], "internal_query (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.internal_query", false]], "internal_size (psycopg2.extensions.column attribute)": [[5, "psycopg2.extensions.Column.internal_size", false]], "internalerror": [[11, "psycopg2.InternalError", false]], "interval (in module psycopg2.extensions)": [[5, "psycopg2.extensions.INTERVAL", false]], "interval objects": [[17, "index-9", false]], "intervalarray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.INTERVALARRAY", false]], "intervalfrompy (class in psycopg2.extensions)": [[5, "psycopg2.extensions.IntervalFromPy", false]], "io_timestamp (psycopg2.extras.replicationcursor attribute)": [[6, "psycopg2.extras.ReplicationCursor.io_timestamp", false]], "isempty (psycopg2.extras.range attribute)": [[6, "psycopg2.extras.Range.isempty", false]], "isexecuting() (connection method)": [[1, "connection.isexecuting", false]], "isolation level": [[1, "index-9", false], [5, "index-4", false]], "isolation_level (connection attribute)": [[1, "connection.isolation_level", false]], "isolation_level_autocommit (in module psycopg2.extensions)": [[5, "psycopg2.extensions.ISOLATION_LEVEL_AUTOCOMMIT", false]], "isolation_level_default (in module psycopg2.extensions)": [[5, "psycopg2.extensions.ISOLATION_LEVEL_DEFAULT", false]], "isolation_level_read_committed (in module psycopg2.extensions)": [[5, "psycopg2.extensions.ISOLATION_LEVEL_READ_COMMITTED", false]], "isolation_level_read_uncommitted (in module psycopg2.extensions)": [[5, "psycopg2.extensions.ISOLATION_LEVEL_READ_UNCOMMITTED", false]], "isolation_level_repeatable_read (in module psycopg2.extensions)": [[5, "psycopg2.extensions.ISOLATION_LEVEL_REPEATABLE_READ", false]], "isolation_level_serializable (in module psycopg2.extensions)": [[5, "psycopg2.extensions.ISOLATION_LEVEL_SERIALIZABLE", false]], "isqlquote (class in psycopg2.extensions)": [[5, "psycopg2.extensions.ISQLQuote", false]], "itersize (cursor attribute)": [[2, "cursor.itersize", false]], "join() (psycopg2.sql.composed method)": [[14, "psycopg2.sql.Composed.join", false]], "join() (psycopg2.sql.sql method)": [[14, "psycopg2.sql.SQL.join", false]], "json": [[6, "index-8", false]], "json (class in psycopg2.extras)": [[6, "psycopg2.extras.Json", false]], "large objects": [[17, "index-19", false]], "lastrowid (cursor attribute)": [[2, "cursor.lastrowid", false]], "ld_library_path": [[9, "index-6", false]], "libpq_version() (in module psycopg2.extensions)": [[5, "psycopg2.extensions.libpq_version", false]], "license": [[10, "index-0", false]], "listen": [[0, "index-6", false]], "lists": [[17, "index-12", false]], "literal (class in psycopg2.sql)": [[14, "psycopg2.sql.Literal", false]], "lobject (class in psycopg2.extensions)": [[5, "psycopg2.extensions.lobject", false]], "lobject() (connection method)": [[1, "connection.lobject", false]], "localtimezone (class in psycopg2.tz)": [[16, "psycopg2.tz.LocalTimezone", false]], "logging": [[1, "index-11", false], [6, "index-2", false]], "loggingconnection (class in psycopg2.extras)": [[6, "psycopg2.extras.LoggingConnection", false]], "loggingcursor (class in psycopg2.extras)": [[6, "psycopg2.extras.LoggingCursor", false]], "logicalreplicationconnection (class in psycopg2.extras)": [[6, "psycopg2.extras.LogicalReplicationConnection", false]], "longinteger (in module psycopg2.extensions)": [[5, "psycopg2.extensions.LONGINTEGER", false]], "longintegerarray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.LONGINTEGERARRAY", false]], "lookup() (in module psycopg2.errorcodes)": [[3, "psycopg2.errorcodes.lookup", false]], "lookup() (in module psycopg2.errors)": [[4, "psycopg2.errors.lookup", false]], "lower (psycopg2.extras.range attribute)": [[6, "psycopg2.extras.Range.lower", false]], "lower_inc (psycopg2.extras.range attribute)": [[6, "psycopg2.extras.Range.lower_inc", false]], "lower_inf (psycopg2.extras.range attribute)": [[6, "psycopg2.extras.Range.lower_inf", false]], "macaddr": [[6, "index-13", false]], "make() (psycopg2.extras.compositecaster method)": [[6, "psycopg2.extras.CompositeCaster.make", false]], "make_dsn() (in module psycopg2.extensions)": [[5, "psycopg2.extensions.make_dsn", false]], "mapping": [[5, "index-2", false]], "memoryview": [[17, "index-8", false]], "message": [[6, "index-4", false]], "message_detail (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.message_detail", false]], "message_hint (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.message_hint", false]], "message_primary (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.message_primary", false]], "methods": [[1, "index-4", false]], "mintimeloggingconnection (class in psycopg2.extras)": [[6, "psycopg2.extras.MinTimeLoggingConnection", false]], "mintimeloggingcursor (class in psycopg2.extras)": [[6, "psycopg2.extras.MinTimeLoggingCursor", false]], "mode (psycopg2.extensions.lobject attribute)": [[5, "psycopg2.extensions.lobject.mode", false]], "module": [[3, "module-psycopg2.errorcodes", false], [4, "module-psycopg2.errors", false], [5, "module-psycopg2.extensions", false], [6, "module-psycopg2.extras", false], [11, "module-psycopg2", false], [13, "module-psycopg2.pool", false], [14, "module-psycopg2.sql", false], [16, "module-psycopg2.tz", false]], "mogrify() (cursor method)": [[2, "cursor.mogrify", false]], "move": [[17, "index-16", false]], "multiprocess": [[17, "index-17", false]], "multithread": [[13, "index-1", false], [17, "index-17", false]], "name (cursor attribute)": [[2, "cursor.name", false]], "name (psycopg2.extensions.column attribute)": [[5, "psycopg2.extensions.Column.name", false]], "name (psycopg2.extras.compositecaster attribute)": [[6, "psycopg2.extras.CompositeCaster.name", false]], "name (psycopg2.sql.placeholder attribute)": [[14, "psycopg2.sql.Placeholder.name", false]], "named": [[17, "index-16", false]], "namedtuple": [[6, "index-1", false], [6, "index-10", false]], "namedtupleconnection (class in psycopg2.extras)": [[6, "psycopg2.extras.NamedTupleConnection", false]], "namedtuplecursor (class in psycopg2.extras)": [[6, "psycopg2.extras.NamedTupleCursor", false]], "needs_password (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.needs_password", false]], "new_array_type() (in module psycopg2.extensions)": [[5, "psycopg2.extensions.new_array_type", false]], "new_type() (in module psycopg2.extensions)": [[5, "psycopg2.extensions.new_type", false]], "news": [[12, "index-0", false]], "nextset() (cursor method)": [[2, "cursor.nextset", false]], "none": [[17, "index-4", false]], "notices (connection attribute)": [[1, "connection.notices", false]], "notifications": [[0, "index-6", false]], "notifies (connection attribute)": [[1, "connection.notifies", false]], "notify": [[0, "index-6", false]], "notify (class in psycopg2.extensions)": [[5, "psycopg2.extensions.Notify", false]], "notsupportederror": [[11, "psycopg2.NotSupportedError", false]], "null": [[17, "index-4", false]], "null_ok (psycopg2.extensions.column attribute)": [[5, "psycopg2.extensions.Column.null_ok", false]], "number (in module psycopg2)": [[11, "psycopg2.NUMBER", false]], "numbers": [[17, "index-5", false]], "numericrange (class in psycopg2.extras)": [[6, "psycopg2.extras.NumericRange", false]], "objects": [[0, "index-2", false], [17, "index-3", false]], "oid": [[2, "index-0", false]], "oid (psycopg2.extensions.lobject attribute)": [[5, "psycopg2.extensions.lobject.oid", false]], "oid (psycopg2.extras.compositecaster attribute)": [[6, "psycopg2.extras.CompositeCaster.oid", false]], "operationalerror": [[11, "psycopg2.OperationalError", false]], "options (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.options", false]], "owner (psycopg2.extensions.xid attribute)": [[5, "psycopg2.extensions.Xid.owner", false]], "parameter_status() (psycopg2.extensions.connectioninfo method)": [[5, "psycopg2.extensions.ConnectionInfo.parameter_status", false]], "parameters": [[1, "index-18", false], [1, "index-19", false], [11, "index-0", false], [17, "index-1", false]], "paramstyle (in module psycopg2)": [[11, "psycopg2.paramstyle", false]], "parse_dsn() (in module psycopg2.extensions)": [[5, "psycopg2.extensions.parse_dsn", false]], "password": [[11, "index-0", false]], "password (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.password", false]], "path": [[9, "index-3", false], [9, "index-4", false], [9, "index-5", false], [9, "index-8", false]], "payload (psycopg2.extensions.notify attribute)": [[5, "psycopg2.extensions.Notify.payload", false]], "payload (psycopg2.extras.replicationmessage attribute)": [[6, "psycopg2.extras.ReplicationMessage.payload", false]], "pep 246": [[0, "index-3", false], [5, "index-0", false]], "pep 599": [[12, "index-1", false]], "pep 600": [[12, "index-2", false]], "pgbouncer": [[1, "index-2", false]], "pgcode (psycopg2.error attribute)": [[11, "psycopg2.Error.pgcode", false]], "pgconn_ptr (connection attribute)": [[1, "connection.pgconn_ptr", false]], "pgerror (psycopg2.error attribute)": [[11, "psycopg2.Error.pgerror", false]], "pgresult_ptr (cursor attribute)": [[2, "cursor.pgresult_ptr", false]], "physicalreplicationconnection (class in psycopg2.extras)": [[6, "psycopg2.extras.PhysicalReplicationConnection", false]], "pid": [[1, "index-17", false]], "pid (psycopg2.extensions.notify attribute)": [[5, "psycopg2.extensions.Notify.pid", false]], "placeholder (class in psycopg2.sql)": [[14, "psycopg2.sql.Placeholder", false]], "poll status": [[5, "index-7", false]], "poll() (connection method)": [[1, "connection.poll", false]], "poll_error (in module psycopg2.extensions)": [[5, "psycopg2.extensions.POLL_ERROR", false]], "poll_ok (in module psycopg2.extensions)": [[5, "psycopg2.extensions.POLL_OK", false]], "poll_read (in module psycopg2.extensions)": [[5, "psycopg2.extensions.POLL_READ", false]], "poll_write (in module psycopg2.extensions)": [[5, "psycopg2.extensions.POLL_WRITE", false]], "pooling": [[13, "index-0", false]], "port": [[11, "index-0", false]], "port (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.port", false]], "precision (psycopg2.extensions.column attribute)": [[5, "psycopg2.extensions.Column.precision", false]], "prepare": [[1, "index-5", false]], "prepare() (psycopg2.extensions.isqlquote method)": [[5, "psycopg2.extensions.ISQLQuote.prepare", false]], "prepared": [[1, "index-6", false], [1, "index-7", false]], "prepared (psycopg2.extensions.xid attribute)": [[5, "psycopg2.extensions.Xid.prepared", false]], "prerequisites": [[9, "index-2", false]], "programmingerror": [[11, "psycopg2.ProgrammingError", false]], "protocol": [[1, "index-15", false]], "protocol_version (connection attribute)": [[1, "connection.protocol_version", false]], "protocol_version (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.protocol_version", false]], "psycopg2": [[11, "module-psycopg2", false]], "psycopg2.errorcodes": [[3, "module-psycopg2.errorcodes", false]], "psycopg2.errors": [[4, "module-psycopg2.errors", false]], "psycopg2.extensions": [[5, "module-psycopg2.extensions", false]], "psycopg2.extras": [[6, "module-psycopg2.extras", false]], "psycopg2.pool": [[13, "module-psycopg2.pool", false]], "psycopg2.sql": [[14, "module-psycopg2.sql", false]], "psycopg2.tz": [[16, "module-psycopg2.tz", false]], "psycopg2_testdb": [[9, "index-12", false]], "psycopg2_testdb_host": [[9, "index-13", false]], "psycopg2_testdb_port": [[9, "index-14", false]], "psycopg2_testdb_user": [[9, "index-15", false]], "psycopg_debug": [[9, "index-10", false], [9, "index-9", false]], "putconn() (psycopg2.pool.abstractconnectionpool method)": [[13, "psycopg2.pool.AbstractConnectionPool.putconn", false]], "pydate (in module psycopg2.extensions)": [[5, "psycopg2.extensions.PYDATE", false]], "pydatearray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.PYDATEARRAY", false]], "pydatetime (in module psycopg2.extensions)": [[5, "psycopg2.extensions.PYDATETIME", false]], "pydatetimearray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.PYDATETIMEARRAY", false]], "pydatetimetz (in module psycopg2.extensions)": [[5, "psycopg2.extensions.PYDATETIMETZ", false]], "pydatetimetzarray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.PYDATETIMETZARRAY", false]], "pyinterval (in module psycopg2.extensions)": [[5, "psycopg2.extensions.PYINTERVAL", false]], "pyintervalarray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.PYINTERVALARRAY", false]], "python enhancement proposals": [[0, "index-3", false], [5, "index-0", false], [12, "index-1", false], [12, "index-2", false]], "python_egg_cache": [[7, "index-0", false]], "pytime (in module psycopg2.extensions)": [[5, "psycopg2.extensions.PYTIME", false]], "pytimearray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.PYTIMEARRAY", false]], "query": [[17, "index-1", false]], "query (cursor attribute)": [[2, "cursor.query", false]], "querycancelederror": [[5, "psycopg2.extensions.QueryCanceledError", false]], "quote_ident() (in module psycopg2.extensions)": [[5, "psycopg2.extensions.quote_ident", false]], "quotedstring (class in psycopg2.extensions)": [[5, "psycopg2.extensions.QuotedString", false]], "range": [[6, "index-11", false]], "range (class in psycopg2.extras)": [[6, "psycopg2.extras.Range", false]], "range (psycopg2.extras.rangecaster attribute)": [[6, "psycopg2.extras.RangeCaster.range", false]], "rangecaster (class in psycopg2.extras)": [[6, "psycopg2.extras.RangeCaster", false]], "read only": [[17, "index-14", false]], "read() (psycopg2.extensions.lobject method)": [[5, "psycopg2.extensions.lobject.read", false]], "read_message() (psycopg2.extras.replicationcursor method)": [[6, "psycopg2.extras.ReplicationCursor.read_message", false]], "readonly (connection attribute)": [[1, "connection.readonly", false]], "realdictconnection (class in psycopg2.extras)": [[6, "psycopg2.extras.RealDictConnection", false]], "realdictcursor (class in psycopg2.extras)": [[6, "psycopg2.extras.RealDictCursor", false]], "realdictrow (class in psycopg2.extras)": [[6, "psycopg2.extras.RealDictRow", false]], "recover": [[1, "index-8", false]], "register_adapter() (in module psycopg2.extensions)": [[5, "psycopg2.extensions.register_adapter", false]], "register_composite() (in module psycopg2.extras)": [[6, "psycopg2.extras.register_composite", false]], "register_default_json() (in module psycopg2.extras)": [[6, "psycopg2.extras.register_default_json", false]], "register_default_jsonb() (in module psycopg2.extras)": [[6, "psycopg2.extras.register_default_jsonb", false]], "register_hstore() (in module psycopg2.extras)": [[6, "psycopg2.extras.register_hstore", false]], "register_inet() (in module psycopg2.extras)": [[6, "psycopg2.extras.register_inet", false]], "register_ipaddress() (in module psycopg2.extras)": [[6, "psycopg2.extras.register_ipaddress", false]], "register_json() (in module psycopg2.extras)": [[6, "psycopg2.extras.register_json", false]], "register_range() (in module psycopg2.extras)": [[6, "psycopg2.extras.register_range", false]], "register_type() (in module psycopg2.extensions)": [[5, "psycopg2.extensions.register_type", false]], "register_uuid() (in module psycopg2.extras)": [[6, "psycopg2.extras.register_uuid", false]], "release notes": [[12, "index-0", false]], "replication": [[0, "index-9", false], [6, "index-6", false], [6, "index-3", false], [6, "index-4", false], [6, "index-5", false]], "replication_logical (in module psycopg2.extras)": [[6, "psycopg2.extras.REPLICATION_LOGICAL", false]], "replication_physical (in module psycopg2.extras)": [[6, "psycopg2.extras.REPLICATION_PHYSICAL", false]], "replicationcursor (class in psycopg2.extras)": [[6, "psycopg2.extras.ReplicationCursor", false]], "replicationmessage (class in psycopg2.extras)": [[6, "psycopg2.extras.ReplicationMessage", false]], "reset() (connection method)": [[1, "connection.reset", false]], "rollback": [[1, "index-1", false], [1, "index-7", false], [17, "index-14", false]], "rollback() (connection method)": [[1, "connection.rollback", false]], "rowcount (cursor attribute)": [[2, "cursor.rowcount", false]], "rowid (in module psycopg2)": [[11, "psycopg2.ROWID", false]], "rowidarray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.ROWIDARRAY", false]], "rownumber (cursor attribute)": [[2, "cursor.rownumber", false]], "scale (psycopg2.extensions.column attribute)": [[5, "psycopg2.extensions.Column.scale", false]], "schema (psycopg2.extras.compositecaster attribute)": [[6, "psycopg2.extras.CompositeCaster.schema", false]], "schema_name (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.schema_name", false]], "scroll() (cursor method)": [[2, "cursor.scroll", false]], "scrollable (cursor attribute)": [[2, "cursor.scrollable", false]], "security": [[17, "index-2", false]], "seek() (psycopg2.extensions.lobject method)": [[5, "psycopg2.extensions.lobject.seek", false]], "send_feedback() (psycopg2.extras.replicationcursor method)": [[6, "psycopg2.extras.ReplicationCursor.send_feedback", false]], "send_time (psycopg2.extras.replicationmessage attribute)": [[6, "psycopg2.extras.ReplicationMessage.send_time", false]], "seq (psycopg2.sql.composed attribute)": [[14, "psycopg2.sql.Composed.seq", false]], "server": [[1, "index-16", false], [1, "index-18", false]], "server side": [[17, "index-16", false]], "server_version (connection attribute)": [[1, "connection.server_version", false]], "server_version (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.server_version", false]], "set_client_encoding() (connection method)": [[1, "connection.set_client_encoding", false]], "set_isolation_level() (connection method)": [[1, "connection.set_isolation_level", false]], "set_session() (connection method)": [[1, "connection.set_session", false]], "set_wait_callback() (in module psycopg2.extensions)": [[5, "psycopg2.extensions.set_wait_callback", false]], "setinputsizes() (cursor method)": [[2, "cursor.setinputsizes", false]], "setoutputsize() (cursor method)": [[2, "cursor.setoutputsize", false]], "setup.cfg": [[9, "index-7", false]], "setup.py": [[9, "index-7", false]], "severity (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.severity", false]], "severity_nonlocalized (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.severity_nonlocalized", false]], "simpleconnectionpool (class in psycopg2.pool)": [[13, "psycopg2.pool.SimpleConnectionPool", false]], "socket (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.socket", false]], "source_file (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.source_file", false]], "source_function (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.source_function", false]], "source_line (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.source_line", false]], "sql (class in psycopg2.sql)": [[14, "psycopg2.sql.SQL", false]], "sql command": [[0, "index-6", false], [17, "index-16", false], [17, "index-18", false]], "sql injection": [[17, "index-2", false]], "sql_in (class in psycopg2.extensions)": [[5, "psycopg2.extensions.SQL_IN", false]], "sqlstate (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.sqlstate", false]], "ssl_attribute() (psycopg2.extensions.connectioninfo method)": [[5, "psycopg2.extensions.ConnectionInfo.ssl_attribute", false]], "ssl_attribute_names (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.ssl_attribute_names", false]], "ssl_in_use (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.ssl_in_use", false]], "standard_conforming_string": [[5, "index-1", false]], "start_replication() (psycopg2.extras.replicationcursor method)": [[6, "psycopg2.extras.ReplicationCursor.start_replication", false]], "start_replication_expert() (psycopg2.extras.replicationcursor method)": [[6, "psycopg2.extras.ReplicationCursor.start_replication_expert", false]], "statement_position (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.statement_position", false]], "status": [[1, "index-13", false], [1, "index-14", false]], "status (connection attribute)": [[1, "connection.status", false]], "status (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.status", false]], "status_begin (in module psycopg2.extensions)": [[5, "psycopg2.extensions.STATUS_BEGIN", false]], "status_in_transaction (in module psycopg2.extensions)": [[5, "psycopg2.extensions.STATUS_IN_TRANSACTION", false]], "status_prepared (in module psycopg2.extensions)": [[5, "psycopg2.extensions.STATUS_PREPARED", false]], "status_ready (in module psycopg2.extensions)": [[5, "psycopg2.extensions.STATUS_READY", false]], "statusmessage (cursor attribute)": [[2, "cursor.statusmessage", false]], "stopreplication (class in psycopg2.extras)": [[6, "psycopg2.extras.StopReplication", false]], "string (in module psycopg2)": [[11, "psycopg2.STRING", false]], "string (psycopg2.sql.sql attribute)": [[14, "psycopg2.sql.SQL.string", false]], "string_types (in module psycopg2.extensions)": [[5, "psycopg2.extensions.string_types", false]], "stringarray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.STRINGARRAY", false]], "strings": [[17, "index-6", false]], "strings (psycopg2.sql.identifier attribute)": [[14, "psycopg2.sql.Identifier.strings", false]], "subclassing": [[0, "index-0", false]], "table_column (psycopg2.extensions.column attribute)": [[5, "psycopg2.extensions.Column.table_column", false]], "table_name (psycopg2.extensions.diagnostics attribute)": [[5, "psycopg2.extensions.Diagnostics.table_name", false]], "table_oid (psycopg2.extensions.column attribute)": [[5, "psycopg2.extensions.Column.table_oid", false]], "tell() (psycopg2.extensions.lobject method)": [[5, "psycopg2.extensions.lobject.tell", false]], "tests": [[9, "index-11", false]], "thread safety": [[17, "index-17", false]], "threadedconnectionpool (class in psycopg2.pool)": [[13, "psycopg2.pool.ThreadedConnectionPool", false]], "threadsafety (in module psycopg2)": [[11, "psycopg2.threadsafety", false]], "time (in module psycopg2.extensions)": [[5, "psycopg2.extensions.TIME", false]], "time objects": [[17, "index-9", false]], "time zones": [[17, "index-10", false]], "time() (in module psycopg2)": [[11, "psycopg2.Time", false]], "timearray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.TIMEARRAY", false]], "timefrompy (class in psycopg2.extensions)": [[5, "psycopg2.extensions.TimeFromPy", false]], "timefromticks() (in module psycopg2)": [[11, "psycopg2.TimeFromTicks", false]], "timestamp() (in module psycopg2)": [[11, "psycopg2.Timestamp", false]], "timestampfrompy (class in psycopg2.extensions)": [[5, "psycopg2.extensions.TimestampFromPy", false]], "timestampfromticks() (in module psycopg2)": [[11, "psycopg2.TimestampFromTicks", false]], "tpc_begin() (connection method)": [[1, "connection.tpc_begin", false]], "tpc_commit() (connection method)": [[1, "connection.tpc_commit", false]], "tpc_prepare() (connection method)": [[1, "connection.tpc_prepare", false]], "tpc_recover() (connection method)": [[1, "connection.tpc_recover", false]], "tpc_rollback() (connection method)": [[1, "connection.tpc_rollback", false]], "transaction": [[1, "index-0", false], [1, "index-1", false], [1, "index-14", false], [1, "index-5", false], [1, "index-8", false], [1, "index-9", false], [17, "index-14", false], [17, "index-20", false]], "transaction status": [[5, "index-5", false]], "transaction_status (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.transaction_status", false]], "transaction_status_active (in module psycopg2.extensions)": [[5, "psycopg2.extensions.TRANSACTION_STATUS_ACTIVE", false]], "transaction_status_idle (in module psycopg2.extensions)": [[5, "psycopg2.extensions.TRANSACTION_STATUS_IDLE", false]], "transaction_status_inerror (in module psycopg2.extensions)": [[5, "psycopg2.extensions.TRANSACTION_STATUS_INERROR", false]], "transaction_status_intrans (in module psycopg2.extensions)": [[5, "psycopg2.extensions.TRANSACTION_STATUS_INTRANS", false]], "transaction_status_unknown (in module psycopg2.extensions)": [[5, "psycopg2.extensions.TRANSACTION_STATUS_UNKNOWN", false]], "transactionrollbackerror": [[5, "psycopg2.extensions.TransactionRollbackError", false]], "truncate() (psycopg2.extensions.lobject method)": [[5, "psycopg2.extensions.lobject.truncate", false]], "tuple": [[6, "index-10", false], [17, "index-13", false]], "two-phase commit": [[1, "index-4", false], [17, "index-20", false]], "type (psycopg2.extras.compositecaster attribute)": [[6, "psycopg2.extras.CompositeCaster.type", false]], "type casting": [[0, "index-5", false]], "type_code (psycopg2.extensions.column attribute)": [[5, "psycopg2.extensions.Column.type_code", false]], "typecaster (psycopg2.extras.rangecaster attribute)": [[6, "psycopg2.extras.RangeCaster.typecaster", false]], "types adaptation": [[0, "index-4", false]], "tzinfo_factory (cursor attribute)": [[2, "cursor.tzinfo_factory", false]], "unclean server": [[1, "index-2", false]], "unicode": [[17, "index-6", false], [17, "index-7", false]], "unicode (in module psycopg2.extensions)": [[5, "psycopg2.extensions.UNICODE", false]], "unicodearray (in module psycopg2.extensions)": [[5, "psycopg2.extensions.UNICODEARRAY", false]], "unlink() (psycopg2.extensions.lobject method)": [[5, "psycopg2.extensions.lobject.unlink", false]], "upper (psycopg2.extras.range attribute)": [[6, "psycopg2.extras.Range.upper", false]], "upper_inc (psycopg2.extras.range attribute)": [[6, "psycopg2.extras.Range.upper_inc", false]], "upper_inf (psycopg2.extras.range attribute)": [[6, "psycopg2.extras.Range.upper_inf", false]], "usage": [[17, "index-0", false]], "used_password (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.used_password", false]], "user (psycopg2.extensions.connectioninfo attribute)": [[5, "psycopg2.extensions.ConnectionInfo.user", false]], "username": [[11, "index-0", false]], "uuid": [[6, "index-12", false]], "uuid_adapter (class in psycopg2.extras)": [[6, "psycopg2.extras.UUID_adapter", false]], "version": [[1, "index-15", false], [1, "index-16", false]], "wait callback": [[0, "index-8", false]], "wait_select() (in module psycopg2.extras)": [[6, "psycopg2.extras.wait_select", false]], "wal_end (psycopg2.extras.replicationcursor attribute)": [[6, "psycopg2.extras.ReplicationCursor.wal_end", false]], "wal_end (psycopg2.extras.replicationmessage attribute)": [[6, "psycopg2.extras.ReplicationMessage.wal_end", false]], "warning": [[11, "psycopg2.Warning", false]], "wheel": [[9, "index-0", false], [9, "index-1", false], [9, "index-0", false]], "with statement": [[17, "index-15", false]], "withhold (cursor attribute)": [[2, "cursor.withhold", false]], "wrapped (psycopg2.sql.literal attribute)": [[14, "psycopg2.sql.Literal.wrapped", false]], "write() (psycopg2.extensions.lobject method)": [[5, "psycopg2.extensions.lobject.write", false]], "xid (class in psycopg2.extensions)": [[5, "psycopg2.extensions.Xid", false]], "xid() (connection method)": [[1, "connection.xid", false]]}, "objects": {"": [[1, 0, 1, "", "connection"], [2, 0, 1, "", "cursor"], [11, 3, 0, "-", "psycopg2"]], "connection": [[1, 1, 1, "", "async"], [1, 1, 1, "", "async_"], [1, 1, 1, "", "autocommit"], [1, 2, 1, "", "cancel"], [1, 2, 1, "", "close"], [1, 1, 1, "", "closed"], [1, 2, 1, "", "commit"], [1, 2, 1, "", "cursor"], [1, 1, 1, "", "cursor_factory"], [1, 1, 1, "", "deferrable"], [1, 1, 1, "", "dsn"], [1, 1, 1, "", "encoding"], [1, 2, 1, "", "fileno"], [1, 2, 1, "", "get_backend_pid"], [1, 2, 1, "", "get_dsn_parameters"], [1, 2, 1, "", "get_native_connection"], [1, 2, 1, "", "get_parameter_status"], [1, 2, 1, "", "get_transaction_status"], [1, 1, 1, "", "info"], [1, 2, 1, "", "isexecuting"], [1, 1, 1, "", "isolation_level"], [1, 2, 1, "", "lobject"], [1, 1, 1, "", "notices"], [1, 1, 1, "", "notifies"], [1, 1, 1, "", "pgconn_ptr"], [1, 2, 1, "", "poll"], [1, 1, 1, "", "protocol_version"], [1, 1, 1, "", "readonly"], [1, 2, 1, "", "reset"], [1, 2, 1, "", "rollback"], [1, 1, 1, "", "server_version"], [1, 2, 1, "", "set_client_encoding"], [1, 2, 1, "", "set_isolation_level"], [1, 2, 1, "", "set_session"], [1, 1, 1, "", "status"], [1, 2, 1, "", "tpc_begin"], [1, 2, 1, "", "tpc_commit"], [1, 2, 1, "", "tpc_prepare"], [1, 2, 1, "", "tpc_recover"], [1, 2, 1, "", "tpc_rollback"], [1, 2, 1, "", "xid"]], "cursor": [[2, 1, 1, "", "arraysize"], [2, 2, 1, "", "callproc"], [2, 2, 1, "", "cast"], [2, 2, 1, "", "close"], [2, 1, 1, "", "closed"], [2, 1, 1, "", "connection"], [2, 2, 1, "", "copy_expert"], [2, 2, 1, "", "copy_from"], [2, 2, 1, "", "copy_to"], [2, 1, 1, "", "description"], [2, 2, 1, "", "execute"], [2, 2, 1, "", "executemany"], [2, 2, 1, "", "fetchall"], [2, 2, 1, "", "fetchmany"], [2, 2, 1, "", "fetchone"], [2, 1, 1, "", "itersize"], [2, 1, 1, "", "lastrowid"], [2, 2, 1, "", "mogrify"], [2, 1, 1, "", "name"], [2, 2, 1, "", "nextset"], [2, 1, 1, "", "pgresult_ptr"], [2, 1, 1, "", "query"], [2, 1, 1, "", "rowcount"], [2, 1, 1, "", "rownumber"], [2, 2, 1, "", "scroll"], [2, 1, 1, "", "scrollable"], [2, 2, 1, "", "setinputsizes"], [2, 2, 1, "", "setoutputsize"], [2, 1, 1, "", "statusmessage"], [2, 1, 1, "", "tzinfo_factory"], [2, 1, 1, "", "withhold"]], "psycopg2": [[11, 4, 1, "", "BINARY"], [11, 5, 1, "", "Binary"], [11, 4, 1, "", "DATETIME"], [11, 6, 1, "", "DataError"], [11, 6, 1, "", "DatabaseError"], [11, 5, 1, "", "Date"], [11, 5, 1, "", "DateFromTicks"], [11, 6, 1, "", "Error"], [11, 6, 1, "", "IntegrityError"], [11, 6, 1, "", "InterfaceError"], [11, 6, 1, "", "InternalError"], [11, 4, 1, "", "NUMBER"], [11, 6, 1, "", "NotSupportedError"], [11, 6, 1, "", "OperationalError"], [11, 6, 1, "", "ProgrammingError"], [11, 4, 1, "", "ROWID"], [11, 4, 1, "", "STRING"], [11, 5, 1, "", "Time"], [11, 5, 1, "", "TimeFromTicks"], [11, 5, 1, "", "Timestamp"], [11, 5, 1, "", "TimestampFromTicks"], [11, 6, 1, "", "Warning"], [11, 4, 1, "", "__libpq_version__"], [11, 4, 1, "", "apilevel"], [11, 5, 1, "", "connect"], [3, 3, 0, "-", "errorcodes"], [4, 3, 0, "-", "errors"], [5, 3, 0, "-", "extensions"], [6, 3, 0, "-", "extras"], [11, 4, 1, "", "paramstyle"], [13, 3, 0, "-", "pool"], [14, 3, 0, "-", "sql"], [11, 4, 1, "", "threadsafety"], [16, 3, 0, "-", "tz"]], "psycopg2.Error": [[11, 1, 1, "", "cursor"], [11, 1, 1, "", "diag"], [11, 1, 1, "", "pgcode"], [11, 1, 1, "", "pgerror"]], "psycopg2.errorcodes": [[3, 5, 1, "", "lookup"]], "psycopg2.errors": [[4, 5, 1, "", "lookup"]], "psycopg2.extensions": [[5, 0, 1, "", "AsIs"], [5, 4, 1, "", "BINARYARRAY"], [5, 4, 1, "", "BOOLEAN"], [5, 4, 1, "", "BOOLEANARRAY"], [5, 4, 1, "", "BYTES"], [5, 4, 1, "", "BYTESARRAY"], [5, 0, 1, "", "Binary"], [5, 0, 1, "", "Boolean"], [5, 0, 1, "", "Column"], [5, 0, 1, "", "ConnectionInfo"], [5, 4, 1, "", "DATE"], [5, 4, 1, "", "DATEARRAY"], [5, 4, 1, "", "DATETIMEARRAY"], [5, 4, 1, "", "DECIMAL"], [5, 4, 1, "", "DECIMALARRAY"], [5, 0, 1, "", "DateFromPy"], [5, 0, 1, "", "Diagnostics"], [5, 4, 1, "", "FLOAT"], [5, 4, 1, "", "FLOATARRAY"], [5, 0, 1, "", "Float"], [5, 4, 1, "", "INTEGER"], [5, 4, 1, "", "INTEGERARRAY"], [5, 4, 1, "", "INTERVAL"], [5, 4, 1, "", "INTERVALARRAY"], [5, 4, 1, "", "ISOLATION_LEVEL_AUTOCOMMIT"], [5, 4, 1, "", "ISOLATION_LEVEL_DEFAULT"], [5, 4, 1, "", "ISOLATION_LEVEL_READ_COMMITTED"], [5, 4, 1, "", "ISOLATION_LEVEL_READ_UNCOMMITTED"], [5, 4, 1, "", "ISOLATION_LEVEL_REPEATABLE_READ"], [5, 4, 1, "", "ISOLATION_LEVEL_SERIALIZABLE"], [5, 0, 1, "", "ISQLQuote"], [5, 0, 1, "", "IntervalFromPy"], [5, 4, 1, "", "LONGINTEGER"], [5, 4, 1, "", "LONGINTEGERARRAY"], [5, 0, 1, "", "Notify"], [5, 4, 1, "", "POLL_ERROR"], [5, 4, 1, "", "POLL_OK"], [5, 4, 1, "", "POLL_READ"], [5, 4, 1, "", "POLL_WRITE"], [5, 4, 1, "", "PYDATE"], [5, 4, 1, "", "PYDATEARRAY"], [5, 4, 1, "", "PYDATETIME"], [5, 4, 1, "", "PYDATETIMEARRAY"], [5, 4, 1, "", "PYDATETIMETZ"], [5, 4, 1, "", "PYDATETIMETZARRAY"], [5, 4, 1, "", "PYINTERVAL"], [5, 4, 1, "", "PYINTERVALARRAY"], [5, 4, 1, "", "PYTIME"], [5, 4, 1, "", "PYTIMEARRAY"], [5, 6, 1, "", "QueryCanceledError"], [5, 0, 1, "", "QuotedString"], [5, 4, 1, "", "ROWIDARRAY"], [5, 0, 1, "", "SQL_IN"], [5, 4, 1, "", "STATUS_BEGIN"], [5, 4, 1, "", "STATUS_IN_TRANSACTION"], [5, 4, 1, "", "STATUS_PREPARED"], [5, 4, 1, "", "STATUS_READY"], [5, 4, 1, "", "STRINGARRAY"], [5, 4, 1, "", "TIME"], [5, 4, 1, "", "TIMEARRAY"], [5, 4, 1, "", "TRANSACTION_STATUS_ACTIVE"], [5, 4, 1, "", "TRANSACTION_STATUS_IDLE"], [5, 4, 1, "", "TRANSACTION_STATUS_INERROR"], [5, 4, 1, "", "TRANSACTION_STATUS_INTRANS"], [5, 4, 1, "", "TRANSACTION_STATUS_UNKNOWN"], [5, 0, 1, "", "TimeFromPy"], [5, 0, 1, "", "TimestampFromPy"], [5, 6, 1, "", "TransactionRollbackError"], [5, 4, 1, "", "UNICODE"], [5, 4, 1, "", "UNICODEARRAY"], [5, 0, 1, "", "Xid"], [5, 5, 1, "", "adapt"], [5, 4, 1, "", "adapters"], [5, 0, 1, "", "connection"], [5, 0, 1, "", "cursor"], [5, 4, 1, "", "encodings"], [5, 2, 1, "", "encrypt_password"], [5, 5, 1, "", "get_wait_callback"], [5, 5, 1, "", "libpq_version"], [5, 0, 1, "", "lobject"], [5, 5, 1, "", "make_dsn"], [5, 5, 1, "", "new_array_type"], [5, 5, 1, "", "new_type"], [5, 5, 1, "", "parse_dsn"], [5, 5, 1, "", "quote_ident"], [5, 5, 1, "", "register_adapter"], [5, 5, 1, "", "register_type"], [5, 5, 1, "", "set_wait_callback"], [5, 4, 1, "", "string_types"]], "psycopg2.extensions.AsIs": [[5, 2, 1, "", "getquoted"]], "psycopg2.extensions.Binary": [[5, 2, 1, "", "getquoted"]], "psycopg2.extensions.Column": [[5, 1, 1, "", "display_size"], [5, 1, 1, "", "internal_size"], [5, 1, 1, "", "name"], [5, 1, 1, "", "null_ok"], [5, 1, 1, "", "precision"], [5, 1, 1, "", "scale"], [5, 1, 1, "", "table_column"], [5, 1, 1, "", "table_oid"], [5, 1, 1, "", "type_code"]], "psycopg2.extensions.ConnectionInfo": [[5, 1, 1, "", "backend_pid"], [5, 1, 1, "", "dbname"], [5, 1, 1, "", "dsn_parameters"], [5, 1, 1, "", "error_message"], [5, 1, 1, "", "host"], [5, 1, 1, "", "needs_password"], [5, 1, 1, "", "options"], [5, 2, 1, "", "parameter_status"], [5, 1, 1, "", "password"], [5, 1, 1, "", "port"], [5, 1, 1, "", "protocol_version"], [5, 1, 1, "", "server_version"], [5, 1, 1, "", "socket"], [5, 2, 1, "", "ssl_attribute"], [5, 1, 1, "", "ssl_attribute_names"], [5, 1, 1, "", "ssl_in_use"], [5, 1, 1, "", "status"], [5, 1, 1, "", "transaction_status"], [5, 1, 1, "", "used_password"], [5, 1, 1, "", "user"]], "psycopg2.extensions.Diagnostics": [[5, 1, 1, "", "column_name"], [5, 1, 1, "", "constraint_name"], [5, 1, 1, "", "context"], [5, 1, 1, "", "datatype_name"], [5, 1, 1, "", "internal_position"], [5, 1, 1, "", "internal_query"], [5, 1, 1, "", "message_detail"], [5, 1, 1, "", "message_hint"], [5, 1, 1, "", "message_primary"], [5, 1, 1, "", "schema_name"], [5, 1, 1, "", "severity"], [5, 1, 1, "", "severity_nonlocalized"], [5, 1, 1, "", "source_file"], [5, 1, 1, "", "source_function"], [5, 1, 1, "", "source_line"], [5, 1, 1, "", "sqlstate"], [5, 1, 1, "", "statement_position"], [5, 1, 1, "", "table_name"]], "psycopg2.extensions.ISQLQuote": [[5, 1, 1, "", "_wrapped"], [5, 2, 1, "", "getquoted"], [5, 2, 1, "", "prepare"]], "psycopg2.extensions.Notify": [[5, 1, 1, "", "channel"], [5, 1, 1, "", "payload"], [5, 1, 1, "", "pid"]], "psycopg2.extensions.QuotedString": [[5, 2, 1, "", "getquoted"]], "psycopg2.extensions.Xid": [[5, 1, 1, "", "bqual"], [5, 1, 1, "", "database"], [5, 1, 1, "", "format_id"], [5, 2, 1, "", "from_string"], [5, 1, 1, "", "gtrid"], [5, 1, 1, "", "owner"], [5, 1, 1, "", "prepared"]], "psycopg2.extensions.lobject": [[5, 2, 1, "", "close"], [5, 1, 1, "", "closed"], [5, 2, 1, "", "export"], [5, 1, 1, "", "mode"], [5, 1, 1, "", "oid"], [5, 2, 1, "", "read"], [5, 2, 1, "", "seek"], [5, 2, 1, "", "tell"], [5, 2, 1, "", "truncate"], [5, 2, 1, "", "unlink"], [5, 2, 1, "", "write"]], "psycopg2.extras": [[6, 0, 1, "", "CompositeCaster"], [6, 0, 1, "", "DateRange"], [6, 0, 1, "", "DateTimeRange"], [6, 0, 1, "", "DateTimeTZRange"], [6, 0, 1, "", "DictConnection"], [6, 0, 1, "", "DictCursor"], [6, 0, 1, "", "DictRow"], [6, 0, 1, "", "Inet"], [6, 0, 1, "", "Json"], [6, 0, 1, "", "LoggingConnection"], [6, 0, 1, "", "LoggingCursor"], [6, 0, 1, "", "LogicalReplicationConnection"], [6, 0, 1, "", "MinTimeLoggingConnection"], [6, 0, 1, "", "MinTimeLoggingCursor"], [6, 0, 1, "", "NamedTupleConnection"], [6, 0, 1, "", "NamedTupleCursor"], [6, 0, 1, "", "NumericRange"], [6, 0, 1, "", "PhysicalReplicationConnection"], [6, 4, 1, "", "REPLICATION_LOGICAL"], [6, 4, 1, "", "REPLICATION_PHYSICAL"], [6, 0, 1, "", "Range"], [6, 0, 1, "", "RangeCaster"], [6, 0, 1, "", "RealDictConnection"], [6, 0, 1, "", "RealDictCursor"], [6, 0, 1, "", "RealDictRow"], [6, 0, 1, "", "ReplicationCursor"], [6, 0, 1, "", "ReplicationMessage"], [6, 0, 1, "", "StopReplication"], [6, 0, 1, "", "UUID_adapter"], [6, 5, 1, "", "execute_batch"], [6, 5, 1, "", "execute_values"], [6, 5, 1, "", "register_composite"], [6, 5, 1, "", "register_default_json"], [6, 5, 1, "", "register_default_jsonb"], [6, 5, 1, "", "register_hstore"], [6, 5, 1, "", "register_inet"], [6, 5, 1, "", "register_ipaddress"], [6, 5, 1, "", "register_json"], [6, 5, 1, "", "register_range"], [6, 5, 1, "", "register_uuid"], [6, 5, 1, "", "wait_select"]], "psycopg2.extras.CompositeCaster": [[6, 1, 1, "", "array_oid"], [6, 1, 1, "", "attnames"], [6, 1, 1, "", "atttypes"], [6, 2, 1, "", "make"], [6, 1, 1, "", "name"], [6, 1, 1, "", "oid"], [6, 1, 1, "", "schema"], [6, 1, 1, "", "type"]], "psycopg2.extras.Json": [[6, 2, 1, "", "dumps"]], "psycopg2.extras.LoggingConnection": [[6, 2, 1, "", "filter"], [6, 2, 1, "", "initialize"]], "psycopg2.extras.MinTimeLoggingConnection": [[6, 2, 1, "", "filter"], [6, 2, 1, "", "initialize"]], "psycopg2.extras.Range": [[6, 1, 1, "", "isempty"], [6, 1, 1, "", "lower"], [6, 1, 1, "", "lower_inc"], [6, 1, 1, "", "lower_inf"], [6, 1, 1, "", "upper"], [6, 1, 1, "", "upper_inc"], [6, 1, 1, "", "upper_inf"]], "psycopg2.extras.RangeCaster": [[6, 1, 1, "", "adapter"], [6, 1, 1, "", "array_typecaster"], [6, 1, 1, "", "range"], [6, 1, 1, "", "typecaster"]], "psycopg2.extras.ReplicationCursor": [[6, 2, 1, "", "consume_stream"], [6, 2, 1, "", "create_replication_slot"], [6, 2, 1, "", "drop_replication_slot"], [6, 1, 1, "", "feedback_timestamp"], [6, 2, 1, "", "fileno"], [6, 1, 1, "", "io_timestamp"], [6, 2, 1, "", "read_message"], [6, 2, 1, "", "send_feedback"], [6, 2, 1, "", "start_replication"], [6, 2, 1, "", "start_replication_expert"], [6, 1, 1, "", "wal_end"]], "psycopg2.extras.ReplicationMessage": [[6, 1, 1, "", "cursor"], [6, 1, 1, "", "data_size"], [6, 1, 1, "", "data_start"], [6, 1, 1, "", "payload"], [6, 1, 1, "", "send_time"], [6, 1, 1, "", "wal_end"]], "psycopg2.pool": [[13, 0, 1, "", "AbstractConnectionPool"], [13, 0, 1, "", "SimpleConnectionPool"], [13, 0, 1, "", "ThreadedConnectionPool"]], "psycopg2.pool.AbstractConnectionPool": [[13, 2, 1, "", "closeall"], [13, 2, 1, "", "getconn"], [13, 2, 1, "", "putconn"]], "psycopg2.sql": [[14, 0, 1, "", "Composable"], [14, 0, 1, "", "Composed"], [14, 0, 1, "", "Identifier"], [14, 0, 1, "", "Literal"], [14, 0, 1, "", "Placeholder"], [14, 0, 1, "", "SQL"]], "psycopg2.sql.Composable": [[14, 2, 1, "", "as_string"]], "psycopg2.sql.Composed": [[14, 2, 1, "", "join"], [14, 1, 1, "", "seq"]], "psycopg2.sql.Identifier": [[14, 1, 1, "", "strings"]], "psycopg2.sql.Literal": [[14, 1, 1, "", "wrapped"]], "psycopg2.sql.Placeholder": [[14, 1, 1, "", "name"]], "psycopg2.sql.SQL": [[14, 2, 1, "", "format"], [14, 2, 1, "", "join"], [14, 1, 1, "", "string"]], "psycopg2.tz": [[16, 0, 1, "", "FixedOffsetTimezone"], [16, 0, 1, "", "LocalTimezone"]]}, "objnames": {"0": ["py", "class", "Python class"], "1": ["py", "attribute", "Python attribute"], "2": ["py", "method", "Python method"], "3": ["py", "module", "Python module"], "4": ["py", "data", "Python data"], "5": ["py", "function", "Python function"], "6": ["py", "exception", "Python exception"]}, "objtypes": {"0": "py:class", "1": "py:attribute", "2": "py:method", "3": "py:module", "4": "py:data", "5": "py:function", "6": "py:exception"}, "terms": {"": [0, 2, 3, 5, 6, 7, 8, 9, 10, 11, 14, 16, 17], "0": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 16, 17], "00": [5, 12, 17], "000": 5, "01": 17, "010": 5, "017": 5, "02": [4, 15, 17], "02000": [4, 15], "02001": [4, 15], "03": [4, 15], "03000": [4, 15], "08": [4, 15, 17], "08000": [4, 15], "08001": [4, 15], "08003": [4, 15], "08004": [4, 15], "08006": [4, 15], "08007": [4, 15], "08p01": [4, 15], "08t01": 17, "08xxx": 12, "09": [4, 15], "09000": [4, 15], "0a": [4, 15], "0a000": [4, 15], "0b": [4, 15], "0b000": [4, 15], "0f": [4, 15], "0f000": [4, 15], "0f001": [4, 15], "0l": [4, 15], "0l000": [4, 15], "0lp01": [4, 15], "0p": [4, 15], "0p000": [4, 15], "0x": 6, "0z": [4, 15], "0z000": [4, 15], "0z002": [4, 15], "1": [0, 1, 2, 3, 4, 5, 6, 7, 9, 11, 14, 17], "10": [0, 2, 4, 5, 6, 7, 14, 16, 17], "100": [2, 6, 12, 17], "1000": [2, 12], "100002": 5, "100kb": 17, "1019": 12, "1026": 12, "103": 12, "1034": 12, "1040": 5, "105": 12, "1061": 12, "1073": 12, "108": 12, "10l": 17, "11": [2, 17], "110": 12, "1101": 12, "1125": 12, "113": 12, "1133": 12, "114": 12, "1141": 12, "1148": 12, "1197": 12, "1198": 12, "12": [1, 4, 6, 17], "1200": 12, "123": [2, 6, 12], "1234": 6, "12345678": 6, "125": 12, "1250": 12, "1252": 12, "1267": 12, "127": 6, "1272": 12, "1291": 12, "13": [4, 6, 9], "1307": 12, "131": 12, "133": 12, "135": 12, "1365": 12, "1376": 12, "1386": 12, "1388": 12, "1392": 12, "1396": 12, "14": [3, 4, 5, 17], "140": 12, "141": 12, "142": 12, "146": 12, "148": 12, "1482": 12, "1487": 12, "149": 12, "1497": 12, "15": [3, 4, 12], "152": 12, "153": 12, "1598": 12, "1599": 12, "16": 12, "1630": 12, "164": 12, "166": 12, "168": 6, "17": [4, 9, 12], "170": 12, "1728": 12, "173": 12, "177": 12, "18": [12, 17], "180": 12, "184": 12, "186": 12, "187": 12, "188": 12, "1900": 17, "191": 12, "192": [6, 12], "19260": 17, "19270": 17, "193": 12, "194": 12, "195": 12, "196": 12, "1b": 12, "1d": 12, "1g": 12, "1k": 12, "1l": 12, "1q": 12, "1r": 12, "1t": 12, "1v": 12, "2": [0, 1, 2, 3, 4, 5, 7, 8, 10, 11, 13, 14, 15, 17], "20": [0, 4, 6, 14, 15, 17], "200": 17, "2000": [2, 17], "20000": [4, 15], "2005": 17, "201": 12, "2010": 17, "2014": 12, "2015": 12, "203": 12, "209": 12, "21": [4, 15, 17], "210": 12, "21000": [4, 15], "211": 12, "219": 12, "21m": 17, "22": [4, 15], "220": 12, "2200": [4, 15], "22000": [4, 15], "22001": [4, 15], "22002": [4, 15], "22003": [4, 15], "22004": [4, 15], "22005": [4, 15], "22007": [4, 15], "22008": [4, 15], "22009": [4, 15], "2200b": [4, 15], "2200c": [4, 15], "2200d": [4, 15], "2200f": [4, 15], "2200g": [4, 15], "2200h": [4, 15], "2200l": [4, 15], "2200m": [4, 15], "2200n": [4, 15], "2200t": [4, 15], "22010": [4, 15], "22011": [4, 15], "22012": [4, 15], "22013": [4, 15], "22014": [4, 15], "22015": [4, 15], "22016": [4, 15], "22018": [4, 15], "22019": [4, 15], "2201b": [4, 15], "2201e": [4, 15], "2201f": [4, 15], "2201g": [4, 15], "2201w": [4, 15], "2201x": [4, 15], "22021": [4, 15], "22022": [4, 15], "22023": [4, 15], "22024": [4, 15], "22025": [4, 15], "22026": [4, 15], "22027": [4, 15], "2202e": [4, 15], "2202g": [4, 15], "2202h": [4, 15], "22030": [4, 15], "22031": [4, 15], "22032": [4, 15], "22033": [4, 15], "22034": [4, 15], "22035": [4, 15], "22036": [4, 15], "22037": [4, 15], "22038": [4, 15], "22039": [4, 15], "2203a": [4, 15], "2203b": [4, 15], "2203c": [4, 15], "2203d": [4, 15], "2203e": [4, 15], "2203f": [4, 15], "2203g": [4, 15], "226": 12, "228": 12, "229": 12, "22p01": [4, 15], "22p02": [4, 15], "22p03": [4, 15], "22p04": [4, 15], "22p05": [4, 15], "22p06": [4, 15], "23": [0, 2, 4, 6, 12, 15, 17], "23000": [4, 15], "23001": [4, 15], "23502": [4, 15], "23503": [4, 15], "23505": [4, 15], "23514": [4, 15], "23p01": [4, 15], "24": [4, 6, 12, 15, 17], "24000": [4, 15], "246": [0, 5, 12], "25": [4, 15], "25000": [4, 15], "25001": [4, 15], "25002": [4, 15], "25003": [4, 15], "25004": [4, 15], "25005": [4, 15], "25006": [4, 15], "25007": [4, 15], "25008": [4, 15], "256": 12, "25p01": [4, 15], "25p02": [4, 15], "25p03": [4, 15], "25p04": [4, 15], "26": [4, 12, 15], "26000": [4, 15], "262": 12, "263": 12, "265": 12, "27": [4, 15, 17], "270": 12, "27000": [4, 15], "272": 12, "278": 12, "28": [4, 15], "28000": [4, 15], "281": 12, "285": 12, "28p01": [4, 15], "290": 12, "294": 12, "2b": [4, 15], "2b000": [4, 15], "2bp01": [4, 15], "2d": [4, 15], "2d000": [4, 15], "2f": [4, 15], "2f000": [4, 15], "2f002": [4, 15], "2f003": [4, 15], "2f004": [4, 15], "2f005": [4, 15], "2gb": [5, 12, 17], "2l": 12, "2n": 12, "2o": 12, "2p": 12, "2q": 12, "2r": 12, "2to3": 12, "3": [0, 1, 2, 5, 6, 7, 8, 9, 10, 11, 16, 17], "30": [0, 12, 17], "308": 12, "309": 12, "31": [6, 17], "311": 12, "317": 12, "32": [5, 6, 17], "321": 12, "322": 12, "323": 12, "325": 12, "326": 12, "331": 12, "333": 12, "34": [4, 15], "34000": [4, 15], "343": 12, "346": 12, "348": 12, "35": 12, "350": 12, "352": 12, "353": 12, "359": 12, "3600": 17, "361": 12, "363": 12, "364": 12, "365": 12, "370": 12, "38": [4, 15, 17], "380": 12, "38000": [4, 15], "38001": [4, 15], "38002": [4, 15], "38003": [4, 15], "38004": [4, 15], "3802": 7, "3807": 7, "381": 12, "382": 12, "384": 12, "387": 12, "39": [4, 15], "39000": [4, 15], "39001": [4, 15], "39004": [4, 15], "39p01": [4, 15], "39p02": [4, 15], "39p03": [4, 15], "3b": [4, 15], "3b000": [4, 15], "3b001": [4, 15], "3d": [4, 15], "3d000": [4, 15], "3f": [4, 15], "3f000": [4, 15], "4": [0, 1, 2, 4, 5, 6, 7, 8, 9, 11, 17], "40": [4, 12, 15, 17], "40000": [4, 15], "40001": [4, 15], "40002": [4, 15], "40003": [4, 15], "40p01": [4, 15], "410": 12, "412": 12, "42": [0, 2, 3, 4, 5, 6, 7, 14, 15], "420": 12, "42000": [4, 15], "424": 12, "42501": [4, 15], "425337": 17, "42601": [4, 15], "42602": [4, 15], "42611": [4, 15], "42622": [4, 15], "42701": [4, 15], "42702": [4, 15], "42703": [4, 15], "42704": [4, 15], "42710": [4, 15], "42712": [4, 15], "42723": [4, 15], "42725": [4, 15], "42803": [4, 15], "42804": [4, 15], "42809": [4, 15], "42830": [4, 15], "42846": [4, 15], "42883": [4, 15], "428c9": [4, 15], "42939": [4, 15], "42p01": [3, 4, 11, 15], "42p02": [4, 15], "42p03": [4, 15], "42p04": [4, 15], "42p05": [4, 15], "42p06": [4, 15], "42p07": [4, 15], "42p08": [4, 15], "42p09": [4, 15], "42p10": [4, 15], "42p11": [4, 15], "42p12": [4, 15], "42p13": [4, 15], "42p14": [4, 15], "42p15": [4, 15], "42p16": [4, 15], "42p17": [4, 15], "42p18": [4, 15], "42p19": [4, 15], "42p20": [4, 15], "42p21": [4, 15], "42p22": [4, 15], "44": [4, 15], "44000": [4, 15], "443": 12, "45": 17, "456": 12, "46": 12, "462": 12, "473": 12, "48": 12, "483": 12, "489": 12, "491": 12, "495": 12, "4ef8": 6, "5": [0, 1, 2, 5, 6, 7, 8, 11, 17], "50": [1, 6], "503": 12, "506": 12, "512": 12, "517": 12, "518": 12, "52": 12, "520": 12, "528": 12, "53": [4, 12, 15], "53000": [4, 15], "53100": [4, 15], "532": 12, "53200": [4, 15], "53300": [4, 15], "53400": [4, 15], "536": 12, "54": [4, 15], "54000": [4, 15], "54001": [4, 15], "54011": [4, 15], "54023": [4, 15], "541": 12, "543": 12, "5432": [1, 5, 11], "544": 12, "545": 12, "547": 12, "55": [4, 12, 15], "550": 12, "55000": [4, 15], "55006": [4, 15], "551": 12, "554": 12, "558": 12, "55p02": [4, 15], "55p03": [4, 15], "55p04": [4, 15], "56": 0, "562": 12, "5678": 6, "567812345678": 6, "57": [4, 12, 15], "57000": [4, 15], "57014": [4, 15], "576": 12, "578": 12, "579": 12, "57p01": [4, 15], "57p02": [4, 15], "57p03": [4, 15], "57p04": [4, 15], "57p05": [4, 15], "58": [4, 12, 15], "580": 12, "58000": [4, 15], "58030": [4, 15], "58p01": [4, 15], "58p02": [4, 15], "59": [12, 17], "591": 12, "599": 12, "5h": 17, "6": [2, 3, 4, 5, 6, 7, 8, 17], "600": [0, 12], "601": 12, "602": 12, "6027": 17, "609": 12, "613": 12, "62": 12, "632": 12, "633": 12, "64": [5, 7, 12, 17], "649": 12, "65": 12, "6535": 0, "658": 12, "66": 12, "661": 12, "67": 12, "677": 12, "679": 12, "68": 12, "682": 12, "6bb9bd380a11": 6, "7": [0, 1, 2, 5, 6, 7, 8, 11, 14, 17], "711095": 12, "716": 12, "72": [4, 15], "72000": [4, 15], "726": 12, "73": 12, "732": 12, "74": [2, 17], "746": 12, "755": 12, "773": 12, "781": 12, "782": 12, "783": 12, "788": 12, "790": 12, "794": 12, "8": [1, 2, 3, 4, 5, 6, 7, 8, 14, 17], "80": 12, "800": 12, "80105": 1, "807": 12, "81": 12, "813": 12, "8192": 2, "82": 12, "829": 12, "835": 12, "836": 12, "838": 12, "84": 12, "854": 12, "856": 12, "88": 12, "884": 12, "886": 12, "887": 12, "898": 12, "9": [0, 1, 2, 4, 5, 6, 7, 8, 9, 16, 17], "90": 12, "90100": 11, "90300": 17, "90305": 5, "90611": 1, "913": 12, "928": 12, "94": 12, "940": 12, "941": 12, "95": 12, "951": 12, "961": 12, "996": 12, "9999": [6, 17], "9c0b": 6, "A": [0, 1, 2, 5, 6, 9, 10, 11, 12, 13, 14, 17], "AND": 0, "AS": [6, 17], "And": 7, "As": [2, 5, 6], "But": 7, "By": [1, 5, 6, 17], "FOR": [10, 17], "For": [0, 1, 2, 4, 5, 6, 7, 9, 11, 17], "IN": [4, 12, 17], "INTO": [0, 2, 6, 7, 17], "If": [0, 1, 2, 5, 6, 7, 8, 10, 11, 12, 13, 14, 17], "In": [0, 2, 4, 5, 6, 7, 9, 10, 11, 14, 15, 17], "It": [0, 1, 2, 5, 6, 7, 8, 9, 11, 12, 14, 17], "Its": 8, "NOT": [6, 7], "No": [4, 5, 6, 7, 9, 12, 15], "Not": [4, 6, 9, 15, 17], "ON": 0, "Of": [9, 17], "On": [1, 6, 17], "Or": 6, "Such": [0, 17], "TO": [2, 7, 8, 12], "The": [0, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 16], "Their": 5, "Then": 0, "There": [0, 5, 7], "These": [1, 5, 6], "To": [1, 6, 9, 11], "WILL": 17, "WITH": [2, 4, 12, 15, 17], "With": [0, 6, 7, 12], "_": 17, "__": [11, 14], "__call__": [0, 6], "__class__": 0, "__conform__": [0, 12], "__future__": 0, "__gcc__": 12, "__init__": [0, 16, 17], "__iter__": 12, "__libpq_version__": [5, 11, 12], "__name__": 0, "__slots__": 12, "__version__": 17, "_psycopg": [5, 6, 7, 9, 12], "_without_": 12, "_wrap": 5, "a0eebc99": 6, "a_dat": 17, "a_str": 17, "aarch64": 12, "aargh": 3, "abc": [2, 6, 17], "abl": [3, 5, 6, 17], "abort": [7, 12, 17], "about": [0, 1, 5, 6, 7, 9, 11, 12, 13, 17], "abov": [0, 1, 6, 17], "absolut": [2, 5], "abstract": 14, "abstractconnectionpool": 13, "accept": [0, 1, 5, 12, 17], "access": [1, 4, 5, 6, 8, 12, 15], "accid": 14, "accord": [0, 1, 2, 3, 5, 6, 7, 17], "accordingli": [11, 12], "account": 12, "accumul": 0, "accur": 11, "acknowledg": 10, "aconn": 0, "across": [3, 6, 7, 12, 13], "action": [1, 4, 12, 15, 17], "activ": [12, 17], "activesqltransact": [4, 15], "actual": [2, 5, 6, 11, 12], "acur": 0, "ad": [0, 1, 2, 3, 4, 5, 6, 9, 11, 12, 14, 17], "adam": 12, "adapt": [7, 9, 10, 11, 12, 14], "adapt_point": 0, "add": [0, 5, 6, 9, 12, 17], "addit": [1, 3, 8, 10], "addr": 6, "address": [5, 6, 11, 12], "adminshutdown": [4, 15], "advanc": [8, 12], "advantag": [0, 7, 11], "advic": 2, "advis": [0, 6, 9, 17], "affect": [2, 11, 17], "after": [0, 1, 2, 4, 5, 6, 7, 9, 12, 17], "again": [7, 9, 12, 13], "against": [2, 5, 6, 9, 17], "aim": 12, "aix": 12, "alexei": 12, "algorithm": [1, 5], "alia": [1, 5, 11, 12, 17], "align": 9, "all": [0, 1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 17], "alloc": [11, 12, 17], "allow": [0, 1, 2, 4, 5, 6, 7, 12, 14, 16, 17], "almost": [7, 12], "alon": 12, "along": 10, "alphanumer": 1, "alpin": 12, "alreadi": [1, 5, 6, 7, 9, 11, 12, 17], "also": [0, 1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 14, 15, 16, 17], "alter": 10, "altern": [6, 7, 8, 9, 12, 17], "although": [6, 7], "alwai": [0, 2, 5, 7, 9, 12, 17], "am": 7, "ambiguousalia": [4, 15], "ambiguouscolumn": [4, 15], "ambiguousfunct": [4, 15], "ambiguousparamet": [4, 15], "among": [1, 4, 9], "amount": [6, 17], "an": [0, 1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 17], "an_int": 17, "analog": 6, "analysi": 12, "ani": [0, 1, 2, 5, 6, 7, 9, 10, 11, 12, 14, 17], "another_d": 17, "answer": 7, "anticip": 12, "anymor": [7, 11, 12, 17], "anyon": 10, "anyth": [7, 17], "anywai": 12, "api": [0, 3, 4, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17], "apilevel": 11, "apoint": 0, "app": 12, "appear": [5, 17], "append": [0, 1, 2, 5, 12, 17], "appl": 12, "appli": [1, 6, 10, 12, 17], "applic": [0, 1, 2, 3, 5, 8, 10, 11, 13], "apply_lsn": 6, "appreci": 10, "approach": 17, "appropri": [6, 12, 17], "ar": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 17], "arbitrari": 12, "arch": 12, "archflag": 9, "architectur": 12, "arg": [0, 5, 6, 13, 14], "argslist": 6, "argtyp": [1, 2], "argument": [0, 1, 2, 5, 6, 7, 9, 11, 12, 14, 16, 17], "arm": 12, "arm64": 12, "around": [6, 9, 12], "arrai": [0, 5, 6, 7, 12, 17], "array_oid": [6, 7], "array_typecast": 6, "arrays": 2, "arraysubscripterror": [4, 15], "arriv": [0, 6], "as_str": 14, "ascii": 12, "asi": [0, 5, 12], "asia": 17, "ask": 8, "asp": 7, "asprintf": 12, "assert": 12, "assertfailur": [4, 15], "assign": [1, 3, 12, 17], "assist": 12, "associ": [1, 2, 5, 13, 17], "assum": [2, 6, 17], "async": [0, 1, 5, 7, 11, 12], "async_": [1, 5, 11, 12], "asynchron": [1, 5, 6, 8, 11, 12], "atabl": 0, "attach": [4, 5, 12], "attack": 17, "attempt": [0, 1, 2, 6], "attnam": 6, "attnum": 5, "attr": 6, "attribut": [0, 1, 2, 3, 4, 5, 6, 11, 12, 14, 16, 17], "atttyp": 6, "authent": [5, 11], "author": [0, 1, 4, 12, 15, 17], "auto": 14, "autocommit": [0, 1, 7, 12, 17], "automat": [0, 1, 2, 5, 6, 7, 9, 12, 13, 14, 17], "autotool": 12, "avail": [0, 1, 2, 3, 4, 5, 6, 7, 9, 11, 12, 17], "avoid": [0, 1, 7, 12], "awai": [12, 13], "awaken": 0, "b": [1, 2, 5, 7, 12, 17], "ba": 14, "back": [1, 2, 6, 12, 17], "backend": [1, 2, 5, 7, 11, 12, 17], "backend_pid": [1, 5], "backslash": [5, 12], "backward": [1, 2, 5, 12, 17], "bad": [0, 5, 12], "badcopyfileformat": [4, 15], "bar": [2, 6, 7, 14, 17], "barf": 11, "base": [0, 2, 4, 5, 6, 11, 12, 13, 14, 15], "base_cast": 5, "basic": [0, 5, 8, 11], "basicconfig": 12, "baz": [2, 6, 14], "bb6d": 6, "bc": 12, "bdist_rpm": 12, "becaus": [0, 2, 5, 6, 7, 9, 17], "becom": [0, 6, 7, 9, 12], "been": [0, 1, 2, 3, 4, 5, 6, 12, 16, 17], "befor": [0, 1, 2, 4, 5, 6, 7, 9, 12, 14, 17], "began": 5, "begin": [0, 1, 5, 6, 12, 17], "beginn": 9, "behav": [1, 5, 12, 17], "behavior": 6, "behaviour": [1, 5, 12], "being": [0, 1, 2, 5, 6, 8, 10, 12], "belong": [1, 5], "below": [1, 5, 9, 11], "benefici": 6, "benefit": 6, "best": [2, 8], "better": [0, 1, 2, 6, 12], "between": [0, 1, 3, 4, 6, 11, 12, 17], "bidirect": 17, "big": [6, 12], "bigint": 17, "bin": 9, "binari": [5, 6, 7, 11, 12], "binaryarrai": 5, "bind": [0, 2, 9, 11, 12, 17], "bit": [5, 7, 12, 17], "blake": 12, "bloat": [1, 17], "blob": [11, 17], "block": [0, 1, 2, 5, 6, 7, 12, 17], "blog": 9, "blue": 6, "bobbi": 17, "bodi": 2, "boil": 0, "bool": [5, 17], "boolean": [2, 5, 6, 17], "booleanarrai": 5, "borrow": 3, "borzenkov": 12, "both": [0, 1, 2, 5, 6, 8, 11, 12, 17], "bother": 0, "bound": [2, 6, 11, 12, 17], "box": [6, 8], "bqual": [1, 5], "branch": [5, 17], "branchtransactionalreadyact": [4, 15], "break": [0, 6, 12], "bring": 6, "broken": [1, 7, 12], "brought": 12, "brows": 12, "browser": 12, "bsd": 10, "btree": 6, "buffer": [2, 6, 12, 17], "bug": [7, 9, 12], "bugfix": [9, 12], "buglet": 12, "build": [0, 7, 8, 12, 17], "build_ext": 9, "built": [0, 5, 7, 9, 12, 17], "builtin": [5, 6, 12, 17], "bunch": 7, "bundl": 12, "button": 1, "bux": 12, "byte": [0, 1, 2, 5, 6, 7, 12, 17], "bytea": [7, 12, 17], "bytea_output": [7, 17], "bytearrai": [12, 17], "bytesarrai": [5, 7, 17], "c": [0, 1, 2, 6, 7, 8, 9, 10, 12, 17], "c_char_p": 2, "c_int": 1, "c_void_p": [1, 2], "cach": [6, 7, 12, 16], "calcul": 12, "calcutta": 17, "call": [0, 1, 2, 5, 6, 7, 9, 12, 13, 17], "callabl": [6, 11], "callback": [0, 5, 6, 7, 12], "caller": [0, 6], "callproc": [0, 2, 12, 17], "camelcas": 4, "can": [0, 1, 2, 3, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16, 17], "cancel": [1, 5, 6, 7, 12], "candid": 6, "cannot": [2, 6, 7, 14, 17], "cannotcoerc": [4, 15], "cannotconnectnow": [4, 15], "cantchangeruntimeparam": [4, 15], "capabl": [2, 11], "capac": 6, "capsul": [1, 12], "card": 6, "card_back": 6, "cardin": [4, 15], "cardinalityviol": [4, 15], "care": [6, 9, 17], "carri": 0, "case": [0, 1, 2, 4, 5, 6, 9, 11, 12, 14, 15, 17], "casenotfound": [4, 15], "cast": [2, 7, 8, 11, 12, 17], "cast_point": 0, "caster": [5, 6, 12, 17], "catalog": [0, 4, 5, 15], "catch": [2, 4, 11, 17], "caus": [1, 5, 6, 12], "cento": 12, "certain": [6, 12, 17], "cffi": 9, "cfg": [9, 12], "chang": [0, 1, 2, 3, 4, 5, 6, 7, 11, 12, 14, 15, 16, 17], "changelog": 12, "channel": [0, 1, 5], "char": [5, 11, 12], "charact": [1, 2, 3, 5, 14, 17], "characterist": [1, 12], "characternotinrepertoir": [4, 15], "charit": 6, "check": [0, 1, 2, 4, 5, 6, 7, 9, 11, 12, 15], "checkviol": [4, 15], "child": 7, "choos": [1, 12, 17], "chosen": [6, 12], "chri": 12, "chunk": [5, 7, 12], "cidr": [6, 17], "citizen": 12, "claim": 10, "class": [0, 3, 6, 7, 8, 11, 12, 13, 14, 15, 16, 17], "class_syntax_error_or_access_rule_viol": 3, "classic": 12, "claus": 6, "clean": 12, "cleanup": 12, "clearli": 14, "cleartext": 5, "client": [0, 1, 2, 5, 6, 7, 8, 9, 11, 12, 13, 17], "client_encod": 1, "client_min_messag": 1, "clobber": [6, 12], "close": [0, 1, 2, 5, 7, 12, 13, 17], "closeal": 13, "cnn": 7, "code": [0, 2, 4, 5, 6, 8, 9, 10, 11, 12, 13, 17], "codebas": 12, "codec": 12, "col": 17, "collationmismatch": [4, 15], "collect": [6, 12], "column": [0, 1, 2, 5, 6, 11, 12, 17], "column_nam": 5, "com": [5, 12], "combin": 10, "come": [0, 5, 9, 14, 17], "comma": [7, 14, 17], "command": [0, 1, 2, 5, 6, 7, 9, 12, 17], "commerci": 10, "commit": [0, 1, 2, 5, 7, 8, 12], "common": [12, 14, 17], "commun": [0, 1, 5, 6, 8, 12, 17], "comp": 14, "compani": 12, "companion": 6, "compar": [6, 11, 16], "comparison": 12, "compat": [0, 1, 2, 4, 5, 6, 9, 12], "compil": [5, 8, 9, 11, 12], "complain": 9, "complet": [0, 4, 5, 8, 9, 11, 12, 15, 17], "complex": [5, 6], "complianc": [2, 5, 11], "compliant": 2, "compon": [5, 6, 17], "compos": [1, 2, 6, 12, 14], "composit": [8, 12, 17], "compositecast": 6, "computation": 5, "concaten": 17, "concern": 5, "concurr": [0, 1, 5, 7, 8, 9, 12], "condit": [1, 3, 4, 5, 6, 7, 12, 17], "conf": [0, 12], "config": 9, "configfileerror": [4, 15], "configur": [0, 1, 4, 5, 9, 12, 15, 17], "configurationlimitexceed": [4, 15], "confirm": [6, 12], "conflict": 9, "conform": [0, 5], "confus": 17, "conjunct": 6, "conn": [0, 1, 2, 5, 6, 9, 11, 13, 14, 17], "conn_get_isolation_level": 12, "conn_or_cur": 6, "connect": [2, 4, 7, 8, 9, 11, 12, 14, 15, 17], "connect_timeout": 5, "connection_factori": [0, 5, 6, 11, 12], "connectiondoesnotexist": [4, 15], "connectionexcept": [4, 15], "connectionfailur": [4, 15], "connectioninfo": [1, 5], "consecut": 12, "consid": [11, 12], "consider": 2, "consist": [2, 5, 6, 12, 13], "constant": [1, 3, 6, 8, 11, 12, 14], "constantli": 6, "constraint": [1, 4, 15], "constraint_nam": 5, "construct": [6, 11], "constructor": [5, 6, 8, 12, 16], "consum": [6, 17], "consume_stream": [0, 6, 12], "contain": [0, 1, 2, 3, 4, 5, 6, 9, 11, 12, 14], "containingsqlnotpermit": [4, 15], "content": [2, 4, 5, 6, 8, 12, 14, 17], "context": [1, 2, 5, 6, 12, 14, 17], "continu": [0, 6, 12, 17], "contrib": 6, "control": [0, 1, 5, 6, 8, 11, 12], "conveni": [0, 6, 14, 17], "convent": 3, "convers": [0, 1, 5, 6, 8, 12, 17], "convert": [0, 1, 2, 4, 5, 6, 7, 11, 12, 17], "cooper": [0, 5], "copi": [0, 2, 6, 8, 10, 11, 12], "copiou": 9, "copy_expert": [2, 14, 17], "copy_from": [2, 12, 17], "copy_in": 12, "copy_to": [2, 12, 17], "copyright": 10, "core": 12, "corner": 12, "coroutin": [1, 8, 12, 17], "correct": [6, 7, 9, 12, 17], "correctli": [1, 7, 9, 12, 17], "correspond": 6, "corri": 12, "corrupt": 12, "could": [0, 1, 4, 5, 6, 11, 12, 17], "count": [2, 5, 12], "coupl": [9, 12], "cours": [0, 9, 17], "cpu": 0, "cpython": 9, "craft": 17, "craig": 12, "crash": [12, 14], "crashshutdown": [4, 15], "creat": [0, 1, 2, 5, 6, 7, 8, 11, 12, 13, 14, 16, 17], "create_replication_slot": [0, 6], "creation": [6, 12, 16], "csv": 2, "ctrl": [6, 7, 12], "ctype": [1, 2, 9, 12], "cupcic": 12, "cur": [0, 1, 2, 3, 4, 5, 6, 7, 9, 11, 14, 17], "cur1": 17, "cur2": 17, "curnam": 17, "current": [0, 1, 2, 5, 6, 7, 8, 9, 17], "cursor": [1, 4, 5, 7, 8, 9, 11, 12, 14, 15, 16], "cursor_factori": [0, 1, 5, 6, 11, 12], "custom": [0, 6, 7, 8, 11, 12], "customiz": 17, "d": [7, 17], "dada": 2, "dai": [11, 17], "danger": 14, "daniel": 12, "data": [0, 1, 2, 4, 5, 7, 8, 11, 12, 15, 17], "data_s": 6, "data_start": [0, 6], "databas": [0, 1, 2, 3, 4, 6, 7, 9, 11, 12, 14, 17], "databasedrop": [4, 15], "databaseerror": [4, 11, 12, 15], "datacorrupt": [4, 15], "dataerror": [4, 11, 15], "dataexcept": [4, 15], "dataset": 17, "datatype_nam": 5, "datatypemismatch": [4, 15], "date": [5, 6, 9, 11, 12], "datearrai": 5, "datefrompi": [5, 17], "datefromtick": 11, "daterang": 6, "datestyl": [1, 12], "datetim": [2, 5, 6, 11, 12, 16, 17], "datetimearrai": 5, "datetimedelta": 12, "datetimefieldoverflow": [4, 15], "datetimerang": 6, "datetimetz": 5, "datetimetzrang": 6, "dave": 12, "david": 12, "db": [0, 3, 4, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17], "dbapi": [1, 2, 12], "dbapi20": 12, "dbname": [0, 1, 5, 9, 11, 17], "deadlock": [0, 5, 12], "deadlockdetect": [4, 15], "deal": [5, 6, 12, 17], "deal_with_it": 2, "dealloc": [6, 12], "dealt": 2, "debian": 12, "debug": 12, "dec2float": 7, "decid": 5, "decim": [1, 2, 5, 6, 7, 12, 17], "decimalarrai": 5, "declar": [1, 2, 12, 17], "decod": [0, 1, 2, 5, 6, 7, 12, 17], "decreas": 17, "decref": 12, "def": [0, 2, 6, 17], "default": [1, 2, 5, 6, 7, 11, 12, 16, 17], "default_transaction_": [0, 1, 12], "default_transaction_deferr": 1, "default_transaction_isol": 1, "default_transaction_read_onli": 1, "defaulttest": 9, "deferr": [1, 12], "defin": [0, 1, 4, 5, 6, 8, 9, 11, 12, 17], "definit": 8, "del": [1, 2, 17], "deleg": [0, 5], "delet": 10, "delimit": 17, "demo": 0, "democonsum": 0, "denot": 3, "depend": [0, 2, 4, 5, 6, 7, 9, 12, 15], "dependentobjectsstillexist": [4, 15], "dependentprivilegedescriptorsstillexist": [4, 15], "deploi": 17, "deprec": [6, 11, 12, 14, 16], "dequ": 0, "derefer": 12, "deriv": 12, "describ": [2, 9, 11, 12], "descript": [0, 2, 5, 11, 12], "descriptor": [0, 1, 4, 5, 15], "deserv": 12, "design": [0, 8, 12], "desir": [5, 6], "desk": 17, "destin": 11, "destroi": [8, 12, 17], "destruct": 17, "detail": [0, 1, 2, 5, 6, 7, 9, 10, 11, 12, 17], "detect": [4, 5, 11, 12], "determin": [2, 17], "dev": [7, 9], "devel": 12, "develop": [6, 7, 12], "diag": [5, 11], "diagnosi": 12, "diagnost": [4, 5, 9, 11, 12, 15], "diagnosticsexcept": [4, 15], "dict": [5, 6, 12, 17], "dict_cur": 6, "dictcomposit": 6, "dictconnect": 6, "dictcursor": [6, 12], "dictionari": [1, 2, 5, 12, 17], "dictrow": [6, 12], "did": [1, 2, 12], "differ": [0, 1, 2, 5, 6, 9, 11, 12, 13, 14, 16, 17], "digit": [1, 2, 5, 6], "dir": 12, "direct": [6, 7], "directli": [0, 6, 13, 14, 16], "directori": [5, 6, 7, 9, 10, 12], "disabl": [6, 9], "disadvantag": 7, "disallow": 6, "disappear": 6, "discard": [1, 2, 6, 7, 12, 13, 17], "disconnect": [6, 11, 12], "discov": 9, "discuss": 12, "disk": 6, "diskful": [4, 15], "dislik": 12, "displai": [9, 12], "display_s": [2, 5], "dispos": [7, 17], "distinct": 5, "distinguish": 5, "distribut": [6, 9, 10, 12, 17], "divis": 11, "division_by_zero": 4, "divisionbyzero": [4, 15], "django": 12, "dll": 9, "dml": 2, "do": [1, 2, 3, 7, 10, 12, 17], "doc": [1, 5, 7, 10, 12], "docstr": 12, "document": [0, 1, 2, 3, 4, 5, 7, 10, 11, 12, 16, 17], "doe": [0, 1, 2, 3, 5, 6, 7, 9, 11, 12], "doesn": [0, 1, 2, 5, 6, 7, 11, 12, 14, 17], "don": [1, 11, 12, 17], "done": [2, 6], "dot": 14, "doubl": [5, 12, 14, 17], "doubt": 9, "down": 0, "download": 9, "dql": 2, "driver": [1, 17], "drop": [0, 1, 5, 6, 12, 16], "drop_replication_slot": 6, "dsn": [0, 1, 5, 6, 11, 12, 17], "dsn_paramet": [1, 5], "dt": [12, 17], "due": [2, 3, 5, 7, 11], "dump": 6, "dunklau": 12, "duplic": 4, "duplicatealia": [4, 15], "duplicatecolumn": [4, 15], "duplicatecursor": [4, 15], "duplicatedatabas": [4, 15], "duplicatefil": [4, 15], "duplicatefunct": [4, 15], "duplicatejsonobjectkeyvalu": [4, 15], "duplicateobject": [4, 15], "duplicatepreparedstat": [4, 15], "duplicateschema": [4, 15], "duplicatet": [4, 15], "dure": [1, 2, 5, 6, 7, 11, 12, 16, 17], "dynam": [2, 5, 6, 7, 12, 14, 17], "e": [0, 1, 2, 3, 4, 5, 6, 7, 9, 11, 12, 14, 17], "each": [2, 4, 5, 6, 7, 11, 12, 17], "earlier": 7, "eas": 17, "easi": [0, 2, 5, 7, 12], "easiest": 7, "easili": 17, "east": 16, "easy_instal": 7, "ecosystem": 12, "edit": 9, "effect": [1, 2, 5, 6, 17], "effici": [2, 5, 6, 8, 9, 12, 17], "egg": 7, "eisentraut": 12, "either": [0, 1, 2, 5, 6, 10, 11, 12, 16, 17], "element": [6, 12, 14, 17], "elif": [0, 17], "els": [0, 4, 6, 7, 17], "embed": 6, "emerton": 12, "emit": [3, 9, 17], "emploi": 17, "empti": [0, 2, 5, 6, 12, 17], "enabl": [0, 6, 12, 17], "enc": 1, "encapsul": [1, 17], "enclos": 5, "encod": [1, 2, 5, 6, 7, 12, 17], "encount": [7, 11], "encrypt": 5, "encrypt_password": [5, 12], "end": [0, 1, 2, 6, 7, 17], "endless": 6, "enough": [5, 12], "ensur": [1, 12], "enter": 6, "entir": [0, 1, 2, 12, 17], "entri": [2, 4, 5, 7, 17], "enum": 5, "env": 7, "environ": [0, 5, 9, 11, 12], "epoch": 11, "epydoc": 12, "equal": [6, 11], "equival": [1, 5, 6], "eric": 12, "error": [0, 1, 5, 6, 7, 8, 9, 11, 12, 15, 17], "error_messag": 5, "errorcod": [4, 8, 11, 12], "errorinassign": [4, 15], "escap": [5, 7, 12, 14, 17], "escapecharacterconflict": [4, 15], "especi": [9, 17], "establish": [0, 1, 5], "etc": [0, 1, 5, 6, 11, 12, 17], "euc_cn": 12, "euc_jis_2004": 12, "europ": 17, "evalu": [6, 14], "even": [2, 4, 6, 7, 10, 12, 14, 17], "event": 12, "eventlet": [0, 5], "eventtriggerprotocolviol": [4, 15], "eventu": [1, 6, 13, 14, 17], "ever": 9, "everi": [0, 1, 2, 4, 5, 6, 11, 12, 17], "everyth": [4, 9], "evil": 6, "exact": [6, 16], "exactli": [2, 16], "examin": 17, "exampl": [0, 1, 2, 3, 5, 6, 7, 11, 12, 14, 17], "exc": [0, 2], "exce": 17, "exceed": [4, 15], "except": [0, 1, 2, 3, 6, 7, 8, 10, 12, 15, 17], "excess": 1, "exchang": 17, "exclus": 4, "exclusionviol": [4, 15], "execut": [0, 1, 2, 3, 4, 5, 7, 8, 9, 11, 12, 14, 17], "execute_batch": [6, 12], "execute_valu": [6, 12], "executemani": [0, 2, 6, 12, 14, 17], "exist": [0, 4, 6, 9, 11, 12, 14, 15, 17], "exit": [1, 12, 17], "expand": 0, "expect": [2, 5, 6, 11, 12, 13, 17], "expens": [12, 13], "explain": 1, "explan": 1, "explicit": [1, 7, 12], "explicitli": [2, 5, 6, 7, 12], "exploit": 14, "export": [1, 2, 5, 9, 11, 12, 17], "expos": [0, 1, 2, 4, 5, 7, 11, 12, 14, 17], "express": [0, 14], "ext": 14, "extend": [2, 5, 8, 10, 12, 17], "extens": [0, 4, 6, 7, 8, 9, 12, 17], "extern": [1, 4, 12, 15], "externalroutineexcept": [4, 15], "externalroutineinvocationexcept": [4, 15], "extra": [0, 1, 2, 7, 8, 12, 17], "extrem": [6, 17], "f": [2, 5, 17], "f0": [4, 15], "f0000": [4, 15], "f0001": [4, 15], "f1": [0, 6], "f2": [0, 6], "face": 6, "facil": [0, 6, 12, 17], "factori": [1, 2, 5, 6, 8, 11, 12, 17], "fail": [5, 7, 11, 12, 17], "failur": [4, 5, 6, 9, 12, 15], "fairli": 17, "fall": 17, "fals": [1, 2, 5, 6, 11, 13, 17], "faq": [5, 6, 7, 9], "far": 5, "fast": [2, 7, 8], "fastcgi": 17, "faster": [2, 6, 12], "fatal": 12, "favor": 12, "fdwcolumnnamenotfound": [4, 15], "fdwdynamicparametervalueneed": [4, 15], "fdwerror": [4, 15], "fdwfunctionsequenceerror": [4, 15], "fdwinconsistentdescriptorinform": [4, 15], "fdwinvalidattributevalu": [4, 15], "fdwinvalidcolumnnam": [4, 15], "fdwinvalidcolumnnumb": [4, 15], "fdwinvaliddatatyp": [4, 15], "fdwinvaliddatatypedescriptor": [4, 15], "fdwinvaliddescriptorfieldidentifi": [4, 15], "fdwinvalidhandl": [4, 15], "fdwinvalidoptionindex": [4, 15], "fdwinvalidoptionnam": [4, 15], "fdwinvalidstringformat": [4, 15], "fdwinvalidstringlengthorbufferlength": [4, 15], "fdwinvaliduseofnullpoint": [4, 15], "fdwnoschema": [4, 15], "fdwoptionnamenotfound": [4, 15], "fdwoutofmemori": [4, 15], "fdwreplyhandl": [4, 15], "fdwschemanotfound": [4, 15], "fdwtablenotfound": [4, 15], "fdwtoomanyhandl": [4, 15], "fdwunabletocreateexecut": [4, 15], "fdwunabletocreaterepli": [4, 15], "fdwunabletoestablishconnect": [4, 15], "fe": [7, 9], "featur": [0, 4, 6, 8, 9, 12, 15, 17], "featurenotsupport": [4, 15], "feedback": 6, "feedback_timestamp": 6, "feel": 7, "fetch": [2, 5, 6, 7, 12, 17], "fetchal": [2, 6, 9, 17], "fetchmani": [2, 7, 12, 17], "fetchon": [0, 2, 6, 17], "fetchxxx": 12, "few": [0, 4, 5, 6, 7, 9, 12, 13, 17], "fewer": [2, 6], "field": [2, 5, 6, 7, 12, 14, 17], "field1": 14, "field2": 14, "field3": 14, "figur": 9, "file": [0, 1, 2, 4, 5, 6, 7, 9, 10, 12, 15, 17], "file_nam": 5, "fileno": [0, 1, 5, 6, 12], "fill": [12, 17], "filter": 6, "final": 17, "find": [5, 6, 7, 9, 12, 17], "find_librari": [1, 2], "fine": 7, "finish": [1, 5], "first": [0, 1, 3, 5, 6, 7, 12, 17], "fit": [10, 12], "five": 3, "fix": [6, 12, 16], "fixedoffsettimezon": [2, 12, 16, 17], "flag": [5, 6, 9, 17], "flexibl": [2, 5, 8], "float": [0, 5, 6, 7, 12, 17], "floatarrai": 5, "floatingpointexcept": [4, 15], "flush": [6, 12], "flush_lsn": [0, 6], "fly": 14, "follow": [0, 1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 17], "foo": [1, 2, 5, 6, 7, 14, 17], "foo_id_seq": 1, "foo_pkei": 1, "forc": [6, 12], "foreign": [4, 11, 15], "foreignkeyviol": [4, 15], "forget": [12, 17], "forgot": 12, "forgotten": 14, "fork": [7, 17], "form": [0, 1, 2, 5, 6, 14, 16, 17], "format": [5, 6, 7, 11, 12, 14, 17], "format_id": [1, 5], "formula": 7, "forward": [1, 2, 7, 17], "found": [2, 3, 4, 5, 6, 7, 11, 12, 15, 16], "foundat": 10, "fraction": [2, 5, 6, 12], "framework": 0, "free": [7, 10, 12, 13], "freebsd": 12, "freed": 12, "freedom": 0, "freeli": 10, "frequent": 8, "friendli": [0, 8], "from": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16], "from_str": 5, "fromtick": 11, "frontend": [1, 5], "full": [6, 12], "fulli": [12, 17], "fun": 5, "function": [0, 1, 2, 6, 7, 8, 11, 12, 13, 14, 16, 17], "functionexecutednoreturnstat": [4, 15], "further": [0, 1, 2, 6, 7, 11, 17], "furthermor": [1, 6, 17], "futur": [0, 1, 2, 6, 7], "g": [0, 1, 2, 4, 5, 6, 7, 9, 11, 12, 14, 17], "gain": 17, "gangadharan": 12, "garbag": 12, "gc": 12, "gcc": 12, "gener": [1, 4, 5, 6, 7, 10, 11, 12, 13, 14, 17], "generatedalwai": [4, 15], "geometr": 0, "get": [0, 1, 5, 7, 9, 12, 13], "get_backend_pid": [1, 12], "get_dsn_paramet": [1, 12], "get_native_connect": [1, 12], "get_parameter_statu": [1, 12], "get_transaction_statu": [1, 12], "get_wait_callback": 5, "getconn": 13, "getlogg": 0, "getquot": [0, 5, 6, 12, 17], "gevent": [0, 5], "gil": 12, "gin": 6, "gist": 6, "git": 12, "github": [9, 12], "give": [0, 6, 10, 12], "given": [1, 2, 5, 6, 11, 12], "glibc": 12, "glitch": 12, "global": [1, 5, 6, 7, 17], "gnu": 10, "go": 12, "gone": 12, "good": [7, 12], "goodi": 8, "googl": [7, 9], "gori": 7, "got": [0, 6], "gotcha": 7, "grant": 10, "grantor": [4, 15], "greater": [0, 11, 17], "greatli": [6, 9], "green": [0, 7, 12, 17], "grep": 7, "group": [0, 5, 6], "groupingerror": [4, 15], "grumbl": 12, "grumpi": 7, "gtrid": [1, 5], "guarante": [1, 5], "guard": [1, 17], "guess": 12, "gunpoint": 17, "gz": 9, "h": [7, 9, 10, 12], "ha": [0, 1, 2, 3, 5, 6, 9, 11, 12, 16, 17], "hacker": 12, "had": [2, 14, 17], "hain": 12, "hand": [6, 17], "handl": [0, 1, 2, 5, 6, 8, 12, 13], "handler": [4, 11], "hang": [12, 17], "happen": [0, 1, 12, 14, 17], "hardcod": 14, "harsh": [7, 12], "hashabl": 6, "hat": 12, "have": [0, 1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 14, 17], "haven": 7, "header": [2, 9, 12], "heart": 6, "heavili": 8, "held": [1, 17], "heldcursorrequiressameisolationlevel": [4, 15], "hello": 0, "help": [6, 9, 12], "helper": [2, 8], "henc": [2, 6], "here": [4, 5, 7, 10, 11, 12, 17], "hex": [7, 12, 17], "hexadecim": 6, "hierarchi": 14, "hilbert": 12, "hint": 11, "histor": 17, "histori": 6, "hoc": 14, "hold": [1, 5, 6, 11, 12, 16, 17], "holder": 10, "honour": 12, "hook": 5, "hope": 10, "host": [1, 5, 9, 11], "hour": [11, 17], "how": [0, 5, 6, 7, 9, 17], "howev": [5, 14, 17], "hstore": [12, 17], "html": 12, "http": [10, 12], "huge": [12, 17], "human": 12, "hv": [4, 15], "hv000": [4, 15], "hv001": [4, 15], "hv002": [4, 15], "hv004": [4, 15], "hv005": [4, 15], "hv006": [4, 15], "hv007": [4, 15], "hv008": [4, 15], "hv009": [4, 15], "hv00a": [4, 15], "hv00b": [4, 15], "hv00c": [4, 15], "hv00d": [4, 15], "hv00j": [4, 15], "hv00k": [4, 15], "hv00l": [4, 15], "hv00m": [4, 15], "hv00n": [4, 15], "hv00p": [4, 15], "hv00q": [4, 15], "hv00r": [4, 15], "hv010": [4, 15], "hv014": [4, 15], "hv021": [4, 15], "hv024": [4, 15], "hv090": [4, 15], "hv091": [4, 15], "i": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17], "i686": 12, "icon": 12, "id": [1, 2, 5, 6, 11, 14, 17], "idea": 16, "identifi": [1, 5, 7, 12, 14, 17], "idiomat": 4, "idl": [1, 5, 7, 17], "idleintransactionsessiontimeout": [4, 15], "idlesessiontimeout": [4, 15], "iff": 6, "ignor": [7, 12], "ii": 12, "ilik": 17, "illumo": 12, "immedi": [1, 2, 6, 17], "immut": 6, "implement": [0, 1, 2, 5, 6, 7, 8, 11, 12, 13, 17], "impli": [10, 17], "implicit": 1, "implicitli": [0, 1, 6, 12], "import": [0, 1, 2, 5, 6, 7, 9, 11, 12, 14, 17], "importerror": 7, "imposs": [6, 12], "improv": [6, 12, 16], "inappropri": 1, "inappropriateaccessmodeforbranchtransact": [4, 15], "inappropriateisolationlevelforbranchtransact": [4, 15], "includ": [1, 2, 3, 4, 5, 6, 10, 12, 13, 14, 17], "inclus": 12, "incom": 6, "incompat": 12, "inconsist": [5, 12], "incorrectli": 1, "indeterminatecol": [4, 15], "indeterminatedatatyp": [4, 15], "index": [1, 2, 6, 7, 8, 12], "indexcorrupt": [4, 15], "indexerror": 2, "indic": [2, 3, 6, 8, 9], "indicatoroverflow": [4, 15], "individu": 6, "inet": [0, 6, 12, 17], "inf": 12, "infailedsqltransact": [4, 15], "infdateadapt": 17, "infer": 3, "infin": [6, 12, 17], "infinit": 6, "info": [0, 1, 5, 12], "inform": [0, 1, 5, 6, 7, 9, 11, 12], "infrastructur": 12, "infrequ": 12, "ing": 0, "inherit": [6, 11, 12, 14], "init": 12, "initi": [1, 4, 6, 7, 12, 15], "initialis": 12, "inject": [6, 17], "input": [2, 5, 11, 17], "insert": [0, 2, 6, 7, 8, 11, 12, 14, 17], "insid": 17, "inspect": [6, 12], "inspir": [5, 17], "instal": [1, 6, 8, 12, 17], "instanc": [0, 1, 2, 4, 5, 6, 9, 12, 14, 16, 17], "instant": 12, "instanti": [1, 6], "instead": [0, 2, 5, 6, 7, 11, 12, 14, 16, 17], "insuffici": [4, 15], "insufficientprivileg": [4, 15], "insufficientresourc": [4, 15], "int": [5, 6, 12, 17], "int4rang": 6, "int8rang": 6, "integ": [1, 2, 5, 6, 7, 11, 12, 14, 17], "integer_datetim": 1, "integerarrai": 5, "integr": [4, 11, 15], "integrityconstraintviol": [4, 15], "integrityerror": [4, 11, 15], "intend": [0, 1], "intens": 5, "intention": 6, "intenum": 12, "interact": [0, 7, 9, 12, 17], "interest": 0, "interfac": [0, 2, 4, 6, 11, 12, 14, 17], "interfaceerror": [0, 1, 2, 11], "intern": [1, 2, 4, 5, 6, 11, 12, 15], "internal_posit": 5, "internal_queri": 5, "internal_s": [2, 5], "internalerror": [4, 11, 15], "internalerror_": [4, 15], "interoper": [1, 2, 17], "interpol": 17, "interpos": 14, "interpret": [12, 14], "interrupt": [1, 7, 12], "interruptederror": 6, "interspers": 12, "interv": [5, 6, 12, 17], "interval_statu": 12, "intervalarrai": 5, "intervalfieldoverflow": [4, 15], "intervalfrompi": 5, "intervent": [4, 15], "introduc": [2, 4, 12], "introduct": [4, 5, 6], "introductori": 1, "introspect": 5, "invalid": [1, 4, 12, 14, 15, 17], "invalidargumentforlogarithm": [4, 15], "invalidargumentfornthvaluefunct": [4, 15], "invalidargumentforntilefunct": [4, 15], "invalidargumentforpowerfunct": [4, 15], "invalidargumentforsqljsondatetimefunct": [4, 15], "invalidargumentforwidthbucketfunct": [4, 15], "invalidauthorizationspecif": [4, 15], "invalidbinaryrepresent": [4, 15], "invalidcatalognam": [4, 15], "invalidcharactervalueforcast": [4, 15], "invalidcolumndefinit": [4, 15], "invalidcolumnrefer": [4, 15], "invalidcursordefinit": [4, 15], "invalidcursornam": [4, 15], "invalidcursorst": [4, 15], "invaliddatabasedefinit": [4, 15], "invaliddatetimeformat": [4, 15], "invalidescapecharact": [4, 15], "invalidescapeoctet": [4, 15], "invalidescapesequ": [4, 15], "invalidforeignkei": [4, 15], "invalidfunctiondefinit": [4, 15], "invalidgrantoper": [4, 15], "invalidgrantor": [4, 15], "invalidindicatorparametervalu": [4, 15], "invalidjsontext": [4, 15], "invalidlocatorspecif": [4, 15], "invalidnam": [4, 15], "invalidobjectdefinit": [4, 15], "invalidparametervalu": [4, 15], "invalidpassword": [4, 15], "invalidprecedingorfollowings": [4, 15], "invalidpreparedstatementdefinit": [4, 15], "invalidrecurs": [4, 15], "invalidregularexpress": [4, 15], "invalidrolespecif": [4, 15], "invalidrowcountinlimitclaus": [4, 15], "invalidrowcountinresultoffsetclaus": [4, 15], "invalidsavepointspecif": [4, 15], "invalidschemadefinit": [4, 15], "invalidschemanam": [4, 15], "invalidsqljsonsubscript": [4, 15], "invalidsqlstatementnam": [4, 15], "invalidsqlstatereturn": [4, 15], "invalidtabledefinit": [4, 15], "invalidtablesampleargu": [4, 15], "invalidtablesamplerepeat": [4, 15], "invalidtextrepresent": [4, 15], "invalidtimezonedisplacementvalu": [4, 15], "invalidtransactioniniti": [4, 15], "invalidtransactionst": [4, 15], "invalidtransactiontermin": [4, 15], "invaliduseofescapecharact": [4, 15], "invalidxmlcom": [4, 15], "invalidxmlcont": [4, 15], "invalidxmldocu": [4, 15], "invalidxmlprocessinginstruct": [4, 15], "invent": 3, "invers": 5, "invoc": [4, 15], "invok": [0, 1, 2, 5, 12, 14], "involv": [2, 6], "io": [2, 12], "io_timestamp": 6, "ioerror": [4, 15], "ip": 5, "ipaddress": [6, 12, 17], "ipv4interfac": 6, "ipv4network": 6, "ipv6interfac": 6, "ipv6network": 6, "iron": 12, "ironpython": 9, "is_superus": 1, "isbusi": 12, "isempti": 6, "isexecut": [0, 1], "ish": 12, "isn": 12, "iso": 12, "iso885910": 12, "iso885916": 12, "isol": [1, 2, 8, 12, 17], "isolation_level": [1, 12], "isolation_level_autocommit": [0, 1, 5], "isolation_level_default": [1, 5, 12], "isolation_level_read_commit": 5, "isolation_level_read_uncommit": 5, "isolation_level_repeatable_read": 5, "isolation_level_serializ": 5, "isqlquot": [0, 5, 6], "isreadi": 12, "issu": [0, 1, 2, 7, 12, 17], "item": [1, 2, 5, 6, 7, 11, 12, 14, 17], "iter": [2, 12, 14, 17], "iters": [2, 12, 17], "its": [0, 1, 2, 3, 4, 5, 6, 7, 9, 12, 17], "itself": [0, 2, 4, 11, 15, 17], "jame": 12, "jan": 12, "java": 17, "jdbc": [1, 17], "join": [0, 6, 14], "joiner": 14, "jon": 12, "json": [7, 12, 17], "jsonb": [6, 7, 12], "jsondata": 6, "juggl": 12, "just": [5, 6, 9, 12], "jython": 9, "k": 17, "karsten": 12, "keep": [0, 1, 4, 6, 7, 17], "keepal": [6, 12], "keepalive_interv": [6, 12], "kei": [1, 6, 11, 13, 17], "kept": 1, "kernel": 0, "keyboard": 12, "keyboardinterrupt": [0, 6, 7], "keyerror": [3, 4], "keyword": [1, 5, 11, 12, 14], "kind": [7, 17], "know": [0, 1, 3, 5, 11, 12], "known": [0, 1, 6, 7, 12, 17], "kreen": 12, "kudo": 12, "kwarg": [5, 6, 11, 13, 14], "laci": 12, "lack": 6, "lambda": [6, 7], "languag": [8, 9, 17], "larg": [0, 1, 2, 5, 7, 8, 11, 12], "larger": 12, "last": [1, 2, 3, 6, 7, 9, 12], "lastrowid": [2, 12], "later": [5, 6, 10, 12, 14, 17], "latin": 12, "latin10": 12, "latin9": 17, "latter": [1, 2], "layer": 12, "layout": [11, 12], "lazi": 12, "ld_library_path": 9, "ldd": [7, 9], "lead": [6, 17], "leak": [1, 12], "leakag": 1, "least": [5, 6, 7, 11, 12, 17], "leav": [1, 2, 7, 12], "left": [7, 14, 17], "legaci": 1, "len": [5, 14], "length": [2, 5, 12], "less": [3, 9, 12], "lesser": [5, 6, 10], "let": 17, "level": [1, 2, 6, 7, 8, 11, 12, 17], "lgpl": 8, "lib": 9, "libpq": [0, 1, 2, 5, 7, 8, 9, 11, 12, 17], "libpq_vers": [5, 11, 12], "librari": [1, 5, 6, 7, 8, 9, 10, 11, 12, 17], "libresolv": 12, "libssl": 9, "licens": [8, 12], "lifetim": [2, 17], "lightweight": 7, "like": [2, 3, 5, 9, 10, 11, 12, 14], "limit": [0, 4, 5, 6, 11, 12, 15], "line": [5, 7, 9, 11, 12, 17], "link": [9, 10, 12], "linux": [9, 12], "list": [0, 1, 2, 4, 5, 6, 7, 9, 11, 12, 14], "listen": [0, 5], "liter": [1, 6, 12, 14, 17], "littl": [6, 7, 12], "live": [1, 7, 17], "ll": 12, "lo64": 17, "lo_creat": 12, "lo_export": [5, 17], "lo_import": [1, 17], "lo_trunc": [5, 7], "lo_truncate64": 7, "load": [5, 6, 7, 11, 12], "loadlibrari": [1, 2], "lobject": [1, 5, 12, 17], "lobject_factori": [1, 12], "local": [1, 3, 6, 12, 16], "localtimezon": 16, "locat": [4, 9, 15], "locatorexcept": [4, 15], "lock": [0, 1, 4, 12, 17], "lock_not_avail": 4, "lockfileexist": [4, 15], "locknotavail": [4, 15], "log": [0, 1, 12], "log_conn": 6, "log_cur": 6, "log_min_duration_stat": 1, "log_stat": 1, "logger": [0, 6], "loggeradapt": [6, 12], "loggingconnect": [6, 12], "loggingcursor": [0, 6], "logic": 6, "logical1": 6, "logicalreplicationconnect": [0, 6], "logicalstreamconsum": 6, "logobj": 6, "long": [1, 7, 11, 12, 17], "longer": [0, 6, 12, 17], "longinteg": 5, "longintegerarrai": 5, "look": [0, 1, 3, 5, 6, 7, 9, 17], "lookup": [3, 4, 12], "loop": [0, 2, 6, 7, 12], "loss": [12, 17], "lost": [1, 6, 12], "lot": [7, 8, 12], "low": 6, "lower": 6, "lower_inc": 6, "lower_inf": 6, "lsn": 6, "m": [0, 6, 12], "m1": 12, "maa": 12, "macaddr": [5, 6], "maco": 12, "macro": 12, "made": [0, 2, 5, 12, 14, 17], "magic": 7, "magnitud": 6, "mai": [0, 1, 2, 4, 5, 6, 7, 9, 10, 11, 12, 14, 17], "mail": [7, 9, 12], "main": [8, 9, 12, 17], "maintain": [0, 5, 9, 12], "major": [1, 5, 12], "make": [0, 1, 2, 3, 5, 6, 7, 8, 9, 11, 12, 17], "make_dsn": [5, 12], "malcolm": 12, "malform": 17, "manag": [1, 2, 12, 17], "mani": [0, 1, 2, 4, 5, 6, 8, 11, 12, 14, 17], "manipul": [1, 5, 17], "manner": [0, 5], "manu": 12, "manual": [0, 1, 6, 12], "manylinux": 12, "manylinux2014": 12, "manylinux_2_24": 12, "map": [0, 2, 5, 6, 8, 12, 14, 17], "mark": [10, 12], "marker": 11, "marko": 12, "marti": 12, "master": 6, "match": [0, 2, 5, 6, 8, 9], "matter": 9, "matthew": 12, "matur": 9, "max": [6, 17], "max_replication_slot": 0, "max_wal_send": 0, "maxconn": 13, "maximum": [6, 13, 17], "mayb": [0, 12], "md5": 5, "me": 12, "mean": [1, 2, 5, 6, 7, 12, 17], "meanging": 6, "meaning": 12, "meant": [6, 9, 14], "mechan": [0, 5, 17], "med": [4, 15], "meet": 9, "member": [1, 5], "memo": 17, "memori": [7, 11, 12, 16, 17], "memoryview": [12, 17], "menno": 12, "menu": 12, "merchant": 10, "merg": [5, 6, 12, 14, 17], "mess": 12, "messag": [0, 1, 2, 3, 5, 6, 7, 9, 11, 12], "message_detail": 5, "message_hint": 5, "message_primari": [5, 11], "met": [0, 9, 17], "meta": 8, "method": [0, 1, 2, 4, 5, 6, 7, 11, 12, 13, 14, 16, 17], "microprotocol": [10, 12], "microsecond": 12, "middlewar": [1, 12, 17], "might": [6, 12], "min": 17, "minconn": 13, "mingw": 12, "minimum": [5, 17], "minor": [1, 5, 12], "mintim": 6, "mintimeloggingconnect": 6, "mintimeloggingcursor": [6, 12], "minu": 12, "minut": [11, 12, 16, 17], "miscellan": [8, 12], "miser": 17, "mismatch": 9, "misrepres": 10, "miss": [7, 9, 12], "mistak": 12, "mix": [1, 7, 11, 12, 17], "mm": 16, "mod_wsgi": [7, 12], "mode": [0, 1, 2, 4, 5, 7, 12, 17], "model": [5, 17], "modern": [0, 12], "modifi": [0, 2, 6, 10, 12, 14], "modifyingsqldatanotpermit": [4, 15], "modifyingsqldatanotpermittedext": [4, 15], "modul": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 12, 13, 16], "modwsgi": 7, "mogrif": 12, "mogrifi": [0, 2, 6, 12, 17], "moment": 6, "monitor": 5, "month": 11, "more": [1, 2, 4, 5, 6, 8, 9, 10, 11, 12, 14, 17], "morethanonesqljsonitem": [4, 15], "most": [2, 5, 6, 7, 8, 9, 17], "mostli": [2, 8, 11, 12, 17], "mostspecifictypemismatch": [4, 15], "move": [2, 12, 17], "mscv": 12, "msg": [0, 6], "msvc": 12, "msys2": 12, "much": [0, 12], "multi": [6, 8, 13], "multipl": [2, 6, 12, 14], "multiprocess": [7, 12, 17], "multithread": [0, 2, 12], "musl": 12, "must": [0, 1, 2, 5, 6, 7, 10, 11, 12, 14, 17], "mutex": 12, "mvcc": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17], "mx": [5, 12], "mxdatetim": 12, "my": 7, "my_data": 9, "my_nam": 14, "my_tabl": [7, 14], "my_uuid": 6, "myjson": 6, "mypic": 17, "mytabl": [0, 4, 6, 17], "n": [1, 2, 14], "n74": 2, "name": [0, 1, 2, 3, 4, 5, 6, 7, 11, 12, 14, 15, 16, 17], "namedtupl": [5, 12, 17], "namedtupleconnect": 6, "namedtuplecursor": [6, 12], "namespac": [0, 12], "nametoolong": [4, 15], "nan": 12, "nativ": [1, 5, 12], "na\u00efv": 17, "nearest": 17, "neat": 12, "necessari": [5, 12, 14, 17], "necessarili": [5, 11], "need": [0, 2, 3, 6, 7, 9, 11, 12, 14, 17], "needs_password": 5, "neeed": 17, "neg": [5, 12, 17], "neither": 1, "nelson": 12, "nest": [6, 7], "network": [2, 12, 17], "never": [2, 5, 7, 12, 17], "new": [1, 2, 4, 5, 6, 7, 8, 9, 11, 13, 14, 17], "new_array_typ": [0, 5, 7, 12], "new_fil": [1, 5], "new_oid": [1, 5], "new_typ": [0, 5, 7], "next": [1, 2, 6, 12], "nextset": 2, "noactivesqltransact": [4, 15], "noactivesqltransactionforbranchtransact": [4, 15], "noadditionaldynamicresultsetsreturn": [4, 15], "nodata": [4, 15], "nodatafound": [4, 15], "non": [0, 1, 5, 8, 11, 12, 17], "nonblock": 0, "none": [0, 1, 2, 5, 6, 7, 11, 12, 13, 14, 16, 17], "nonempti": 6, "nonetheless": 0, "nonnumericsqljsonitem": [4, 15], "nonstandarduseofescapecharact": [4, 15], "nonuniquekeysinajsonobject": [4, 15], "nonzero": 1, "nor": [1, 17], "normal": [0, 2, 6, 7, 12, 14, 17], "nosqljsonitem": [4, 15], "notanxmldocu": [4, 15], "note": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 13, 14, 17], "noth": [1, 2, 5, 6], "notic": [1, 10, 12], "notif": [1, 5, 8, 12], "notifi": [0, 1, 5, 12], "notnullviol": [4, 11, 15], "notsupportederror": [1, 2, 4, 5, 11, 12, 15], "now": [0, 1, 2, 6, 7, 12, 14, 17], "nowait": 4, "nspname": 0, "nt_cur": 6, "null": [0, 2, 5, 12, 17], "null_ok": [2, 5], "nullvaluenoindicatorparamet": [4, 15], "nullvaluenotallow": [4, 15], "nullvaluenotallowedext": [4, 15], "num": [2, 6, 17], "number": [1, 2, 5, 6, 7, 8, 9, 11, 12, 14, 16], "numer": [2, 5, 6, 7, 11, 12, 17], "numericoid": 12, "numericrang": 6, "numericvalueoutofrang": [4, 15], "numrang": 6, "o": [0, 5, 9, 12, 17], "obei": 10, "oberstein": 12, "obj": [5, 6], "object": [1, 2, 4, 7, 8, 12, 15], "objectinus": [4, 15], "objectnotinprerequisitest": [4, 15], "oblig": 10, "obscur": 1, "observ": 17, "obtain": [0, 5, 6, 12, 17], "obviou": 6, "obvious": 12, "occasion": 12, "occur": [3, 11], "occurr": 6, "off": [6, 11, 12], "offer": [0, 6, 11, 13, 17], "offici": [9, 12], "offset": [2, 5, 12, 16, 17], "often": [5, 17], "oid": [0, 1, 2, 5, 6, 7, 12], "ok": 12, "old": [7, 9, 12], "older": [1, 5, 7, 12], "oldest": 6, "oleksandr": 12, "onc": [5, 6, 9, 12, 17], "one": [0, 1, 2, 4, 5, 6, 7, 9, 11, 12, 17], "ones": [0, 1, 4, 5, 7, 9, 12, 13, 14, 17], "onli": [0, 1, 2, 5, 6, 7, 9, 11, 12, 13, 14, 16, 17], "onto": 17, "op": [6, 7, 12], "open": [1, 5, 6, 7, 9, 12, 17], "openssl": [10, 12], "oper": [0, 1, 2, 4, 5, 6, 9, 11, 12, 13, 14, 15, 17], "operationalerror": [0, 1, 4, 5, 11, 12, 15], "operatorintervent": [4, 15], "oppos": 7, "opposit": 14, "optim": [2, 12, 14], "option": [0, 1, 2, 4, 5, 6, 7, 9, 10, 12, 13, 15], "order": [0, 2, 4, 5, 6, 9, 12, 17], "ordinari": 6, "org": 10, "origin": [5, 6, 10, 12], "other": [0, 1, 2, 3, 6, 7, 8, 9, 10, 11, 12, 14, 17], "otherwis": [1, 2, 5, 6, 7, 14, 17], "ouch": 3, "our": 7, "out": [0, 2, 6, 8, 9, 11, 12, 17], "outofmemori": [4, 15], "output": [0, 2, 5, 6, 12], "output_plugin": [0, 6], "outsid": [1, 2, 5, 17], "over": [2, 7, 11, 12], "overcom": 11, "overflow": 12, "overhead": [2, 7, 17], "overload": 2, "overrid": [5, 6, 12], "overview": [1, 2, 5], "overwrit": 6, "overwritten": 6, "own": [7, 9, 12], "owner": [1, 5], "p0": [4, 15], "p0000": [4, 15], "p0001": [4, 15], "p0002": [4, 15], "p0003": [4, 15], "p0004": [4, 15], "packag": [7, 12], "packet": 6, "page": [8, 17], "page_s": 6, "pair": 6, "param": [6, 12], "paramet": [0, 1, 2, 5, 6, 7, 8, 11, 12, 13, 14], "parameter_statu": [1, 5], "params_list": 6, "paramstyl": 11, "parlanc": 17, "pars": [0, 5, 6, 7, 12, 17], "parse_dsn": [5, 11, 12], "parse_float": 6, "parser": [7, 12], "part": [2, 5, 6, 7, 14], "parti": 0, "particip": [0, 1, 5], "particular": [6, 10, 11, 17], "particularli": 6, "pass": [0, 1, 2, 3, 5, 6, 7, 8, 11, 12, 13, 14, 16], "password": [1, 5, 11, 12], "password_encrypt": 5, "patch": [0, 12], "path": [5, 7, 9, 12, 17], "pattern": [10, 17], "payload": [0, 1, 5, 6, 12], "pboolean": 12, "pend": 1, "peopl": [12, 14], "pep": [0, 5, 12], "per": [0, 1, 2, 4, 6, 12, 15, 17], "perform": [0, 1, 2, 5, 6, 9, 12, 17], "period": [6, 12], "permiss": 10, "permit": 0, "persist": 17, "persistentconnectionpool": 12, "peter": 12, "petrovich": 12, "pg": 9, "pg_attribut": 5, "pg_catalog": 0, "pg_class": 5, "pg_config": [7, 9, 12], "pg_diag_sever": 5, "pg_drop_replication_slot": 0, "pg_hba": 0, "pg_namespac": 0, "pg_prepared_xact": 1, "pg_servic": 12, "pg_sleep": [0, 7], "pg_type": [0, 5], "pg_xlog": 0, "pgbouncer": [1, 12, 17], "pgcode": [3, 4, 11, 12], "pgconn": [1, 12], "pgconn_ptr": [1, 12], "pgerror": [11, 12], "pgpool": 12, "pgrang": 6, "pgresult": 2, "pgresult_ptr": [2, 12], "pgsql": [4, 12, 15, 17], "phase": [1, 5, 8, 12], "phenomena": 1, "phys_conn": 6, "phys_cur": 6, "physic": 6, "physical1": 6, "physicalreplicationconnect": 6, "pickl": [12, 16], "picklabl": 12, "pictur": 17, "pid": [0, 1, 5, 12], "pip": [9, 12], "piro": [7, 12], "pkei": 14, "pl": [4, 15, 17], "place": [1, 6, 9, 12, 14, 17], "placehold": [2, 6, 7, 12, 14, 17], "plai": [1, 9, 12], "plain": [1, 5, 12], "plainli": 10, "plan": 6, "platform": [12, 16], "pleas": [0, 2, 5, 7, 9, 12, 17], "plpgsql": 17, "plpgsqlerror": [4, 15], "plu": [5, 11, 12], "plug": 12, "plugin": [6, 12], "png": 17, "point": [0, 1, 2, 5, 6, 12, 17], "point_oid": 0, "poll": [0, 1, 6, 8, 12], "poll_error": 5, "poll_ok": [0, 1, 5], "poll_read": [0, 5], "poll_writ": [0, 5], "pollut": [0, 1], "pool": [0, 1, 7, 8, 12], "poorli": 12, "pop": 0, "popul": [1, 5], "popular": 8, "port": [1, 5, 9, 11, 12], "pose": 7, "posit": [2, 5, 6, 7, 12, 14, 17], "possibl": [0, 1, 2, 5, 6, 7, 9, 12, 14, 17], "possibli": [0, 12], "postgr": [0, 1, 2, 5, 9, 11, 17], "postgrespollingstatustyp": 5, "postgresql": [0, 1, 2, 5, 6, 7, 9, 11, 12, 13, 14, 15], "potenti": [1, 12, 14], "ppc64le": 12, "pprint": 1, "pq": [1, 2], "pq_complete_error": 12, "pqbackendpid": [1, 5], "pqcancel": 1, "pqcmdstatu": 2, "pqconnectionneedspassword": 5, "pqconnectionusedpassword": 5, "pqconnectstart": 0, "pqconninfo": [1, 5], "pqconninfopars": 5, "pqdb": 5, "pqencryptpassword": 5, "pqencryptpasswordconn": 5, "pqerrormessag": 5, "pqescapeidentifi": 5, "pqfreemem": 12, "pqfsize": 5, "pqftabl": 5, "pqftablecol": 5, "pqgetresult": 12, "pqhost": 5, "pqlibvers": 5, "pqoption": 5, "pqparameterstatu": [1, 5], "pqpass": 5, "pqport": 5, "pqprotocolvers": [1, 5], "pqresulterrorfield": 5, "pqserververs": [1, 5], "pqsocket": 5, "pqsslattribut": 5, "pqsslattributenam": 5, "pqsslinus": 5, "pqstatu": 5, "pqtransactionstatu": [1, 5], "pquser": 5, "practic": [8, 9, 17], "pre": [9, 12], "preced": [11, 12], "precis": [2, 5, 12, 17], "predat": 6, "prefer": [1, 5, 17], "prefix": 12, "preliminari": 12, "prepar": [0, 1, 5, 6, 12, 17], "prerequisit": [4, 8, 15], "presenc": [0, 14], "present": [2, 11, 14], "press": 0, "prevent": 6, "previosli": 2, "previou": [0, 1, 2, 5, 6, 7, 14, 17], "previous": [0, 1, 2, 4, 5, 11, 12, 16, 17], "primari": [1, 6, 17], "print": [0, 2, 9, 11, 14, 17], "print_funct": 0, "printabl": 5, "prior": 1, "privileg": [4, 15], "probabl": [0, 2, 5, 7], "problem": [1, 5, 8, 11, 12, 14], "proce": [0, 1], "procedur": [2, 12, 17], "process": [0, 1, 2, 4, 5, 6, 7, 8, 11, 12], "process_messag": 6, "processor": 12, "procnam": 2, "produc": [0, 2, 3, 5, 6, 12, 17], "product": [0, 9, 10], "program": [0, 1, 4, 6, 7, 8, 9, 10, 11, 12, 14, 15, 17], "programlimitexceed": [4, 15], "programm": [0, 11], "programmingerror": [0, 1, 2, 4, 5, 6, 11, 12, 15, 17], "progress": [1, 5, 17], "prohibitedsqlstatementattempt": [4, 15], "prohibitedsqlstatementattemptedext": [4, 15], "project": [0, 12], "propag": 12, "proper": [0, 11, 12, 17], "properli": 12, "properti": [1, 5, 6, 12, 17], "proport": 7, "proportion": 17, "propos": [0, 17], "protocol": [1, 6, 8, 12], "protocol_vers": [1, 5, 12], "protocolviol": [4, 15], "proven": 7, "provid": [0, 1, 2, 5, 6, 7, 11, 12, 17], "provok": 12, "psql": 0, "psycogreen": 0, "psycopg": [0, 1, 2, 4, 5, 7, 10, 11, 17], "psycopg1": 12, "psycopg2": [0, 1, 2, 8, 9, 12, 17], "psycopg2_test": [0, 9], "psycopg2_testdb": 9, "psycopg2_testdb_host": 9, "psycopg2_testdb_port": 9, "psycopg2_testdb_us": 9, "psycopg_debug": [9, 12], "psycopg_display_s": 12, "pthread": 12, "public": [6, 10, 12], "publish": [9, 10, 17], "pumukel": 12, "pure": 13, "purpos": 10, "push": 1, "put": [5, 12, 13], "putconn": 13, "py": [5, 9, 12], "py2ex": 12, "pycapsul": 1, "pydat": 5, "pydatearrai": 5, "pydatetim": 5, "pydatetimearrai": 5, "pydatetimetz": 5, "pydatetimetzarrai": 5, "pydll": [1, 2], "pyformat": 11, "pyinterv": 5, "pyintervalarrai": 5, "pyobject_head": 12, "pypi": 9, "pypy3": 12, "pyrang": 6, "pyscopg": 5, "pytest": 0, "python": [1, 2, 5, 6, 7, 11, 12, 13, 14, 16], "python3": [7, 9], "python_egg_cach": 7, "pytim": 5, "pytimearrai": 5, "q1": 14, "q2": 14, "qstring": 12, "qualifi": [2, 5, 6, 12, 14, 17], "qualiti": 9, "queri": [0, 1, 2, 5, 6, 7, 8, 9, 11, 12, 14], "querycancel": [4, 15], "querycancelederror": [1, 5, 7, 12], "question": 8, "quick": [7, 8], "quickest": 9, "quickli": 0, "quit": 12, "quot": [1, 2, 5, 6, 12, 14, 17], "quote_id": [5, 12, 14], "quotedstr": [5, 12], "r": [0, 1, 5, 14, 17], "rais": [0, 1, 2, 3, 4, 5, 6, 7, 9, 11, 12, 17], "raiseexcept": [4, 15], "random": 12, "rang": [11, 12, 17], "rangecast": 6, "rant": 12, "rather": [1, 2, 3, 5, 11, 12], "raudsepp": 12, "raw": [1, 2, 6, 11, 12], "rb": 17, "re": [0, 7, 12], "reach": 6, "read": [0, 1, 2, 5, 6, 7, 9, 12, 17], "read_messag": 6, "readabl": [0, 2, 12], "readi": [0, 1, 5, 13], "readingsqldatanotpermit": [4, 15], "readingsqldatanotpermittedext": [4, 15], "readlin": [2, 17], "readonli": [1, 12], "readonlysqltransact": [4, 15], "real": [0, 1, 12, 17], "realdictconnect": [6, 12], "realdictcursor": [6, 12], "realdictrow": [6, 12], "realli": [6, 12, 14], "reason": [1, 14, 17], "rec": 6, "recalcul": 6, "receiv": [0, 1, 4, 5, 6, 7, 10, 12, 17], "recent": [5, 7, 9, 12], "recept": [0, 5, 12], "recip": 17, "reclassifi": 12, "recogn": [3, 17], "record": [2, 6, 9, 12, 17], "recov": [1, 5, 7], "recoveri": [1, 17], "recurs": 5, "recycl": 6, "red": 12, "redefin": 2, "redistribut": 10, "redshift": 12, "reduc": 6, "refcount": 12, "refcursor": 17, "refer": [0, 2, 4, 5, 6, 12, 17], "referenc": 12, "reffunc": 17, "refus": 12, "regardless": [6, 9], "regist": [0, 2, 5, 6, 7, 17], "register_adapt": [0, 5, 6, 17], "register_composit": [6, 12, 17], "register_default_json": [6, 7], "register_default_jsonb": 6, "register_hstor": [6, 12], "register_inet": 6, "register_ipaddress": 6, "register_json": [6, 7], "register_rang": [6, 12], "register_tstz_w_sec": 12, "register_typ": [0, 2, 5, 7, 12, 17], "register_uuid": [0, 6], "registr": [0, 6], "registri": 12, "regress": 12, "regtyp": 6, "regular": [0, 1, 2, 5, 6, 9, 11, 17], "reilli": [5, 17], "rel": [2, 14], "relat": [1, 2, 5, 11, 12, 17], "releas": [0, 1, 3, 6, 7, 8, 9, 17], "relev": [5, 7], "reli": [0, 1, 5, 9, 17], "reliabl": [2, 6, 17], "reload": 0, "remain": [1, 2, 5, 17], "rememb": [7, 12, 17], "remov": [1, 5, 9, 10, 12], "renam": 12, "reorgan": 12, "repeat": [1, 5, 6, 12, 14, 17], "repeatedli": [6, 12], "replac": [0, 1, 5, 6, 12, 14], "replai": 6, "repli": 6, "replic": [8, 12], "replication_log": 6, "replication_phys": 6, "replicationcursor": [6, 12], "replicationmessag": 6, "report": [1, 5, 6, 7, 9, 11, 12], "repositori": 12, "repr": [12, 17], "repres": [1, 3, 5, 6, 7, 11, 12, 14, 17], "represent": [0, 2, 5, 6, 7, 12, 17], "request": [1, 5, 6, 7, 11, 12, 14], "requir": [0, 1, 2, 5, 6, 7, 10, 11, 12, 17], "resembl": 17, "reserv": 2, "reservednam": [4, 15], "reset": [1, 12], "resourc": [0, 1, 4, 5, 7, 15, 17], "resp": 5, "respect": [1, 10, 11, 12], "respons": [0, 6, 12, 17], "restart": 0, "restor": [1, 12], "restrict": 10, "restrictviol": [4, 15], "restyp": [1, 2], "result": [0, 1, 2, 5, 6, 7, 8, 9, 11, 12, 14, 17], "retain": [2, 6], "retri": 5, "retriev": [0, 2, 5, 6, 9, 12, 17], "retun": 2, "return": [0, 1, 2, 3, 4, 5, 6, 7, 9, 11, 12, 13, 14, 16, 17], "reveal": 12, "revert": [1, 5], "revis": [1, 5, 12, 17], "right": [9, 12], "ringer": 12, "robust": [12, 17], "role": [4, 15], "roll": [1, 17], "rollback": [0, 1, 2, 4, 5, 7, 11, 12, 15, 17], "rome": 17, "ronan": 12, "round": [12, 17], "roundtrip": [2, 6, 12, 17], "rous": 12, "routin": [4, 15], "row": [2, 6, 11, 12], "row_factori": 12, "rowcount": [2, 6, 12], "rowid": [5, 11], "rowidarrai": 5, "rownumb": [2, 12], "rule": [2, 4, 5, 6, 14, 15], "run": [0, 1, 2, 5, 6, 7, 8, 12, 17], "runtim": [5, 7, 12], "rw": 1, "ryan": 12, "s1": 14, "s2": 14, "s3": 14, "s3cr3t": 5, "safe": [0, 1, 2, 5, 7, 12, 13, 14, 17], "safer": 12, "safeti": [1, 2, 7, 8, 11, 12], "sai": 7, "same": [0, 1, 2, 5, 6, 7, 8, 10, 11, 12, 13, 16, 17], "save": [7, 16], "savepoint": [4, 7, 15], "savepointexcept": [4, 15], "scale": [2, 5, 12], "schedul": [0, 12], "schema": [2, 4, 6, 12, 14, 15], "schema_nam": 5, "schemaanddatastatementmixingnotsupport": [4, 15], "scope": [0, 5, 6, 17], "script": [0, 1, 6, 12, 17], "scroll": [1, 2, 12, 17], "scrollabl": [1, 2, 12, 17], "search": [6, 8, 12], "search_path": 12, "second": [0, 5, 6, 7, 11, 12, 17], "secret": [5, 11], "section": 11, "secur": [8, 14], "see": [0, 1, 2, 5, 6, 7, 9, 10, 11, 12, 17], "seek": 5, "seem": [7, 12], "seen": 2, "segfault": [9, 12], "segment": 6, "sel": 6, "select": [0, 1, 2, 3, 5, 6, 7, 9, 11, 12, 14, 17], "self": [0, 6, 9, 17], "semant": [0, 6], "send": [0, 5, 6, 7, 12, 17], "send_feedback": [0, 6], "send_tim": 6, "sent": [0, 1, 2, 5, 6, 12, 17], "sep": 2, "separ": [0, 1, 2, 5, 9, 12, 14, 17], "seq": 14, "sequenc": [1, 2, 5, 6, 7, 12, 14, 17], "sequencegeneratorlimitexceed": [4, 15], "seri": 12, "serial": [1, 5, 6, 12, 17], "serializ": [1, 5], "serializationfailur": [4, 15], "seriou": 14, "serv": 17, "server": [0, 1, 2, 3, 5, 6, 7, 8, 9, 11, 12], "server_encod": 1, "server_vers": [1, 5, 11, 12, 17], "servic": 1, "session": [0, 1, 2, 5, 7, 11, 12, 17], "session_author": 1, "set": [0, 1, 2, 5, 6, 7, 9, 11, 12, 16, 17], "set_client_encod": [0, 1, 12, 17], "set_isolation_level": [0, 1, 5, 12], "set_sess": [0, 1, 5, 12, 17], "set_wait_callback": [0, 1, 5, 6, 7], "setinputs": 2, "setoutputs": 2, "setup": [9, 12], "setuptool": 12, "sever": [0, 1, 5, 6, 7, 8, 11, 12, 17], "severity_nonloc": [5, 12], "share": [0, 1, 7, 8, 11, 12, 13, 17], "shell": [0, 7, 12], "shh": 16, "shift_jis_2004": 12, "ship": 9, "should": [0, 1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 17], "shouldn": [9, 17], "show": [1, 5, 17], "shown": 5, "shulgin": 12, "side": [1, 2, 6, 8, 12], "sigint": 6, "sign": [12, 16], "signal": 12, "signatur": [5, 6], "signific": [2, 5], "silent": [1, 6, 12], "similar": [0, 2, 6, 11, 12, 14, 17], "similarli": 0, "simpl": [0, 1, 5, 6, 11, 12, 13, 17], "simpleconnectionpool": 13, "simplejson": 6, "simpli": 0, "sinc": [0, 1, 5, 6, 11, 16, 17], "singl": [0, 1, 2, 5, 6, 7, 11, 13, 14, 17], "singleton": 11, "singletonsqljsonitemrequir": [4, 15], "site": 17, "situat": [12, 17], "size": [2, 5, 6, 7, 12], "sketch": 6, "skip": 7, "slave": 6, "sleep": 0, "slice": 12, "slightli": 12, "slot": [0, 6], "slot1": 6, "slot_nam": [0, 6], "slot_typ": 6, "slow": [7, 12], "small": [7, 12, 16], "smallint": 17, "smarto": 12, "smit": 12, "snapshot": [4, 5, 15], "snapshottooold": [4, 15], "snif": 6, "snip": 14, "snippet": [6, 14], "snow": 12, "so": [0, 1, 2, 4, 5, 6, 7, 9, 10, 11, 12, 14, 17], "socket": [0, 5, 6, 9, 11, 12], "softwar": [10, 12], "solari": 12, "solid": 12, "solut": [12, 17], "solv": [7, 12], "some": [0, 1, 3, 5, 6, 9, 12, 14, 17], "some_t": [14, 17], "somedb": 5, "someon": 5, "someth": [0, 6, 9, 17], "sometim": [9, 12, 17], "somewhat": 14, "somewher": 14, "soon": [1, 7, 17], "sort": [6, 14], "sourc": [0, 4, 5, 9, 10, 11, 12, 14, 17], "source_fil": 5, "source_funct": 5, "source_lin": 5, "special": [5, 6, 10, 11, 12, 17], "specialis": 4, "specif": [0, 1, 2, 3, 4, 5, 8, 11, 12, 15, 17], "specifi": [0, 1, 2, 5, 6, 9, 11, 12, 14, 17], "speed": 6, "spell": 0, "spew": 12, "split": 12, "spuriou": 12, "sql": [2, 3, 4, 6, 7, 8, 11, 12, 15], "sql1": [1, 17], "sql2": [1, 17], "sql_debug": 0, "sql_in": [5, 12], "sqlalchemi": 0, "sqlclientunabletoestablishsqlconnect": [4, 15], "sqljsonarraynotfound": [4, 15], "sqljsonitemcannotbecasttotargettyp": [4, 15], "sqljsonmembernotfound": [4, 15], "sqljsonnumbernotfound": [4, 15], "sqljsonobjectnotfound": [4, 15], "sqljsonscalarrequir": [4, 15], "sqlroutineexcept": [4, 15], "sqlserverrejectedestablishmentofsqlconnect": [4, 15], "sqlstate": [3, 5, 8, 11, 12, 15], "sqlstatementnotyetcomplet": [4, 15], "srfprotocolviol": [4, 15], "ssl": [5, 7, 9], "ssl_attribut": 5, "ssl_attribute_nam": 5, "ssl_in_us": 5, "sslcertmod": 12, "sslmode": [1, 5, 11, 12], "stabl": [5, 12], "stackeddiagnosticsaccessedwithoutactivehandl": [4, 15], "stamp": 11, "stand": 12, "standard": [0, 1, 2, 3, 4, 5, 6, 8, 11, 15, 17], "standard_conforming_str": [1, 5, 12], "standarderror": 11, "standbi": 6, "starbuck": 9, "start": [1, 5, 6, 7, 9, 12, 17], "start_lsn": 6, "start_repl": [0, 6, 12], "start_replication_expert": [6, 12], "state": [0, 1, 2, 4, 5, 11, 12, 15, 17], "statement": [1, 2, 4, 5, 6, 7, 10, 11, 12, 14, 15], "statement_posit": 5, "statementcompletionunknown": [4, 15], "statementtoocomplex": [4, 15], "static": [5, 9, 12], "statu": [1, 8, 12], "status_begin": 5, "status_in_transact": [1, 5], "status_interv": 6, "status_prepar": 5, "status_readi": [1, 5], "statusmessag": 2, "stderr": [0, 9], "stdin": [2, 7], "stdout": 2, "steal": 17, "steve": 12, "still": [0, 1, 3, 4, 6, 8, 12, 14, 15, 17], "stmt": 6, "stop": 12, "stoprepl": 6, "store": [2, 5, 6, 17], "stori": 17, "str": [0, 1, 5, 6, 7, 12, 14, 17], "strategi": 0, "stream": [0, 6, 9, 17], "streamlin": 9, "stress": 17, "strict": 6, "stricter": 5, "strictest": 5, "string": [0, 1, 2, 5, 6, 7, 8, 11, 12], "string_typ": 5, "stringarrai": 5, "stringdatalengthmismatch": [4, 15], "stringdatarighttrunc": [4, 15], "stringio": 2, "structur": [1, 2, 6, 12, 17], "stuff": 12, "style": [0, 14, 17], "sub": [0, 6, 9, 12], "subclass": [0, 1, 3, 4, 5, 8, 11, 12, 13, 14], "subject": [3, 10], "submit": 2, "subsequ": 17, "substringerror": [4, 15], "subtl": 17, "subtyp": 6, "subtype_oid": 6, "succe": 1, "success": [1, 6], "suggest": [7, 12], "suit": [6, 8], "suitabl": [0, 1, 6, 9, 14, 17], "superclass": [4, 12], "suppli": 2, "support": [1, 2, 4, 7, 8, 9, 11, 12, 13, 14, 15, 16], "suppos": [2, 5, 7], "sure": [0, 6, 7, 9, 12, 17], "swallow": 12, "switch": [0, 1, 5, 12], "sy": [0, 2], "symbol": [1, 3, 5, 7, 11, 12], "sync": [11, 12], "synchron": [0, 6], "syntax": [2, 4, 5, 7, 8, 11, 12, 15, 17], "syntaxerror": [4, 15], "syntaxerrororaccessruleviol": [4, 15], "system": [0, 1, 4, 5, 7, 8, 9, 12, 15, 17], "systemerror": [4, 12, 15], "t": [0, 1, 2, 5, 6, 7, 9, 11, 12, 13, 14, 17], "t1": 14, "t2": 14, "t3": 14, "tab": 2, "tabl": [1, 2, 3, 4, 5, 6, 7, 8, 11, 12, 14, 17], "table_column": [5, 12], "table_nam": [5, 14], "table_oid": [5, 12], "tag": 12, "take": [0, 5, 7, 9, 11, 12, 16], "taken": [1, 2, 17], "tar": 9, "target": [2, 17], "task": 5, "tbar": 2, "tbl": 14, "tcp": [7, 12], "team": 12, "tell": [2, 5, 9], "templat": [6, 14], "term": 10, "termin": [0, 1, 4, 15, 17], "terribl": 17, "test": [0, 1, 2, 3, 5, 6, 8, 11, 12, 17], "test_decod": [0, 6], "test_suit": 9, "text": [6, 12, 17], "textiobas": [2, 12], "textual": [0, 2, 3], "tfoo": 2, "than": [0, 1, 2, 3, 5, 6, 10, 11, 12, 14, 17], "thank": [8, 12], "thei": [0, 2, 5, 6, 7, 9, 11, 12, 14, 17], "them": [0, 1, 2, 5, 6, 7, 9, 12, 14, 17], "themselv": 12, "therebi": 0, "therefor": [0, 6], "thi": [0, 1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 16, 17], "think": [7, 9], "third": 0, "those": 5, "though": [1, 6, 11, 17], "thread": [0, 1, 2, 7, 8, 11, 12, 13], "threadedconnectionpool": 13, "threadsafeti": 11, "three": [3, 7, 12, 17], "through": [0, 2, 5, 11, 12], "throw": [6, 12], "thu": [0, 3, 11, 17], "ti": 0, "tick": 11, "ticket": [9, 12], "tight": 7, "time": [0, 1, 2, 5, 6, 7, 9, 11, 12, 14], "timearrai": 5, "timedelta": [16, 17], "timefrompi": 5, "timefromtick": [11, 12], "timelin": 6, "timeout": [0, 5, 6, 12], "timestamp": [2, 5, 6, 11, 12, 17], "timestampfrompi": 5, "timestampfromtick": [11, 12], "timestamptz": [12, 17], "timetz": [12, 17], "timezon": [1, 2, 5, 12, 16, 17], "tinyerp": 12, "tobia": 12, "togeth": [0, 1, 5, 12], "too": [5, 7, 9, 12, 14, 17], "tool": [11, 12, 17], "toomanyargu": [4, 15], "toomanycolumn": [4, 15], "toomanyconnect": [4, 15], "toomanyjsonarrayel": [4, 15], "toomanyjsonobjectmemb": [4, 15], "toomanyrow": [4, 15], "top": 0, "topic": [6, 8], "total": [2, 5, 6, 12], "total_second": 6, "tpc": 1, "tpc_": 1, "tpc_begin": [1, 17], "tpc_commit": [1, 5, 17], "tpc_prepar": [1, 17], "tpc_recov": [1, 5, 12, 17], "tpc_rollback": [1, 5, 17], "traceback": 7, "tracker": [7, 9], "transact": [0, 1, 2, 4, 8, 11, 12, 15], "transaction_isol": [1, 5], "transaction_statu": [1, 5], "transaction_status_act": 5, "transaction_status_idl": 5, "transaction_status_inerror": 5, "transaction_status_intran": 5, "transaction_status_unknown": 5, "transactionintegrityconstraintviol": [4, 15], "transactionresolutionunknown": [4, 15], "transactionrollback": [4, 15], "transactionrollbackerror": [5, 12], "transactiontimeout": [4, 15], "transfer": [0, 7, 17], "transform": 6, "translat": 17, "transpar": 0, "trap": [5, 11, 12], "treat": [6, 17], "tree": 12, "tri": 9, "trick": 7, "trigger": [4, 15], "triggeredactionexcept": [4, 15], "triggereddatachangeviol": [4, 15], "triggerprotocolviol": [4, 15], "trimerror": [4, 15], "trip": 12, "tripl": 1, "true": [0, 1, 2, 4, 5, 6, 7, 11, 13, 17], "truncat": [5, 11, 12], "try": [0, 1, 2, 3, 4, 6, 7, 9, 11, 12, 17], "tsrang": 6, "tstzrang": 6, "tupl": [1, 2, 5, 6, 7, 12, 14], "tuple_factori": 12, "turn": [11, 12], "twitter": 9, "two": [0, 1, 2, 3, 5, 7, 8, 9, 10, 12, 16], "txt": 9, "typarrai": 5, "type": [1, 2, 8, 12, 14], "type_cod": [2, 5, 11, 12], "typecast": [0, 2, 5, 6, 7, 12, 17], "typeerror": 6, "typenam": 0, "typic": [5, 6, 17], "typnam": [0, 5], "typnamespac": 0, "tz": [2, 7, 8, 12, 17], "tzinfo": [2, 8, 12, 17], "tzinfo_factori": [2, 16], "u": [2, 9, 12, 17], "u20ac": 17, "ui": 1, "ujson": 6, "ultrajson": 6, "unabl": 7, "unauthor": 17, "unbound": [6, 12], "uncheck": 12, "unclean": 1, "uncleanli": 17, "uncommit": [1, 5], "undefin": [1, 7], "undefined_t": 3, "undefinedcolumn": [4, 15], "undefinedfil": [4, 15], "undefinedfunct": [4, 15], "undefinedobject": [4, 15], "undefinedparamet": [4, 15], "undefinedt": [4, 15], "under": [9, 10, 11, 12], "undergo": [14, 17], "underli": [1, 5], "understat": 6, "undesir": [1, 17], "unescap": 17, "unexpect": [9, 11], "unfortun": 17, "unhandl": [6, 12], "unicod": [1, 2, 5, 6, 7, 8, 12], "unicodearrai": [5, 7, 17], "uniformli": 17, "union": 14, "uniqu": 6, "uniqueviol": [4, 15], "uniti": 12, "unittest": 9, "unix": [5, 9, 11], "unknown": [5, 17], "unless": [0, 1, 6, 9, 12], "unlik": 17, "unlink": 5, "unlock": 12, "unpack": [1, 2, 5, 9], "unpars": [5, 7, 17], "unrel": 12, "unreli": 7, "unrespons": 7, "unsaf": 12, "unsafenewenumvalueusag": [4, 15], "unterminatedcstr": [4, 15], "until": [0, 1, 5, 6, 7, 17], "untouch": [1, 14], "untranslatablecharact": [4, 15], "untrust": [14, 17], "untyp": 11, "unus": [1, 2, 7, 12], "unwant": 6, "up": [1, 5, 6, 7, 9, 12, 17], "updat": [1, 2, 6, 7, 8, 12], "upgrad": [7, 9, 12], "upon": [0, 4, 5, 12], "upper": 6, "upper_inc": 6, "upper_inf": 6, "uri": [5, 12], "url": 12, "us": [0, 1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16], "usabl": [1, 17], "usag": [5, 8, 9, 12], "used_password": 5, "user": [0, 1, 2, 5, 6, 7, 9, 11, 12, 17], "usr": 9, "usual": [0, 1, 2, 3, 5, 6, 7, 9, 11, 14, 17], "utc": [12, 16, 17], "utf": [7, 12], "utf8": 17, "util": [1, 2], "uuid": [12, 17], "uuid_adapt": [0, 6], "v": 12, "v1": 6, "v2": 6, "vacuum": [1, 5, 17], "valid": [1, 5, 11, 12, 17], "valu": [0, 1, 2, 3, 4, 5, 6, 7, 8, 11, 12, 14], "valueerror": 12, "var": 2, "varchar": 17, "variabl": [0, 2, 5, 7, 9, 11, 12, 14, 17], "variant": [11, 12], "variou": 12, "varrazzo": 12, "vars_list": 2, "vc9": 12, "verbatim": 11, "verbos": 9, "veri": [6, 7, 9, 11], "verifi": [6, 9, 17], "verion": 14, "version": [0, 1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 14, 16, 17], "via": [0, 1, 2, 5, 6, 12, 17], "viabl": 0, "view": [0, 1, 5], "violat": [4, 15], "virtualenv": 12, "visibl": 2, "vivisect": 12, "w": 1, "wa": [1, 2, 5, 6, 7, 8, 9, 11, 12, 17], "wai": [0, 2, 4, 6, 7, 9, 12, 14, 17], "wait": [0, 1, 5, 6, 14], "wait_select": [0, 5, 6, 7, 12], "wal": 6, "wal_end": [6, 12], "wal_level": 0, "want": [0, 1, 5, 6, 7, 9, 12, 14, 17], "warm": 6, "warn": [0, 4, 11, 12, 15], "warranti": 10, "wasn": [2, 12], "wast": [0, 9], "we": [2, 12, 17], "weak": 14, "weakli": 12, "web": 17, "week": 9, "well": [1, 6, 9, 12, 17], "went": 2, "were": [1, 5, 6, 7, 11, 12, 16, 17], "weren": 5, "what": [1, 3, 4, 5, 7, 8, 11, 17], "whatev": [1, 5, 9], "wheel": [9, 12], "when": [0, 1, 2, 5, 6, 7, 9, 11, 12, 17], "whenc": 5, "whenev": [0, 1, 2, 5], "where": [0, 1, 2, 5, 6, 7, 11, 12, 14, 17], "wherea": 17, "whether": 6, "which": [0, 1, 2, 3, 4, 5, 6, 7, 9, 11, 12, 14, 17], "while": [0, 3, 4, 5, 6, 11, 12, 17], "who": [5, 12], "whole": [6, 7, 12, 17], "whose": [0, 5, 14], "why": 7, "wide": 17, "widespread": 17, "win32": 12, "window": 12, "windowingerror": [4, 15], "winsock2": 12, "wish": [0, 10], "withcheckoptionviol": [4, 15], "wither": 12, "withhold": [1, 2, 17], "within": [1, 3, 5, 6, 17], "without": [0, 1, 6, 9, 10, 12, 17], "woodcraft": 12, "work": [0, 1, 4, 5, 6, 7, 9, 12, 13, 14, 17], "workaround": 6, "worst": 9, "would": [0, 1, 2, 5, 6, 9, 10, 17], "wouldn": 1, "wrap": [0, 1, 2, 5, 6, 11, 14, 17], "wrapped_object": 5, "wrapper": [0, 4, 5, 6, 8, 9, 15, 17], "writabl": [0, 1, 2, 7, 12], "write": [0, 1, 2, 5, 7, 9, 11, 12, 17], "write_lsn": 6, "written": [4, 5, 6, 12, 17], "wrong": [7, 11, 12, 17], "wrongli": 12, "wrongobjecttyp": [4, 15], "wrote": 10, "wsgipythonegg": 7, "www": 10, "x": [0, 2, 6, 7, 9, 12, 16, 17], "x00": 5, "x08": 5, "x0f": 5, "x82": 17, "x86_64": 12, "xa": [1, 5, 17], "xa0": 17, "xa4": 17, "xa8": 17, "xac": 17, "xb2": 17, "xb9": 17, "xc3": 17, "xe0": 17, "xe2": 17, "xe8": 17, "xec": 17, "xf2": 17, "xf9": 17, "xid": [1, 5, 17], "xx": [4, 15], "xx000": [4, 15], "xx001": [4, 15], "xx002": [4, 15], "xxx": 6, "y": [0, 9], "y10k": 12, "year": [7, 11], "yet": [2, 4, 5, 7, 9, 15], "you": [0, 1, 2, 5, 6, 7, 8, 10, 11, 12, 14, 17], "your": [1, 2, 4, 5, 6, 7, 9, 10, 12, 14, 17], "z": 14, "zero": [0, 11], "zerolengthcharacterstr": [4, 15], "zip": 6, "zone": [2, 12], "zope": 12, "zope2": 12, "zpsycopgda": 12, "zsql": 12, "\u00e0\u00e8\u00ec\u00f2\u00f9": 17}, "titles": ["More advanced topics", "The <code class=\"docutils literal notranslate\"><span class=\"pre\">connection</span></code> class", "The <code class=\"docutils literal notranslate\"><span class=\"pre\">cursor</span></code> class", "<code class=\"xref py py-obj docutils literal notranslate\"><span class=\"pre\">psycopg2.errorcodes</span></code> \u2013 Error codes defined by PostgreSQL", "<code class=\"xref py py-obj docutils literal notranslate\"><span class=\"pre\">psycopg2.errors</span></code> \u2013 Exception classes mapping PostgreSQL errors", "<code class=\"xref py py-obj docutils literal notranslate\"><span class=\"pre\">psycopg2.extensions</span></code> \u2013 Extensions to the DB API", "<code class=\"xref py py-obj docutils literal notranslate\"><span class=\"pre\">psycopg2.extras</span></code> \u2013 Miscellaneous goodies for Psycopg 2", "Frequently Asked Questions", "Psycopg \u2013 PostgreSQL database adapter for Python", "Installation", "License", "The <code class=\"xref py py-obj docutils literal notranslate\"><span class=\"pre\">psycopg2</span></code> module content", "Release notes", "<code class=\"xref py py-obj docutils literal notranslate\"><span class=\"pre\">psycopg2.pool</span></code> \u2013 Connections pooling", "<code class=\"xref py py-obj docutils literal notranslate\"><span class=\"pre\">psycopg2.sql</span></code> \u2013 SQL string composition", "&lt;no title&gt;", "<code class=\"xref py py-obj docutils literal notranslate\"><span class=\"pre\">psycopg2.tz</span></code> \u2013  <code class=\"docutils literal notranslate\"><span class=\"pre\">tzinfo</span></code> implementations for Psycopg 2", "Basic module usage"], "titleterms": {"": 12, "0": 12, "1": 12, "10": 12, "11": 12, "12": 12, "13": 12, "14": 12, "2": [6, 9, 12, 16], "3": 12, "4": 12, "5": 12, "6": 12, "7": [9, 12], "8": [9, 12], "9": 12, "99": 12, "If": 9, "TO": 17, "The": [1, 2, 11, 17], "access": 17, "adapt": [0, 5, 6, 8, 17], "addit": [5, 6], "advanc": 0, "altern": 10, "api": [1, 2, 5, 11], "ask": 7, "asynchron": 0, "backslash": 17, "basic": 17, "best": 7, "beta": 12, "between": 9, "binari": [9, 17], "build": 9, "cast": [0, 5, 6], "chang": 9, "class": [1, 2, 4, 5], "code": 3, "commit": 17, "compil": 7, "composit": [6, 14], "connect": [0, 1, 5, 6, 13], "constant": [5, 17], "constructor": 11, "contain": 17, "content": 11, "control": 17, "convers": 7, "copi": 17, "coroutin": [0, 5, 6], "creat": 9, "current": 12, "cursor": [0, 2, 6, 17], "data": 6, "databas": [5, 8], "date": 17, "db": [1, 2, 5, 11], "debug": 9, "defin": 3, "definit": 5, "dictionari": 6, "error": [3, 4], "errorcod": 3, "except": [4, 5, 11], "execut": 6, "extens": [1, 2, 5, 11], "extra": 6, "factori": 0, "fast": 6, "frequent": 7, "from": 17, "function": 5, "goodi": 6, "handl": [7, 17], "have": 9, "helper": 6, "hstore": 6, "implement": [9, 16], "infinit": 17, "instal": [7, 9], "isol": 5, "json": 6, "larg": 17, "level": 5, "lgpl": 10, "librari": 0, "licens": 10, "like": [6, 17], "list": 17, "log": 6, "logic": 0, "map": 4, "meta": 7, "miscellan": 6, "modul": [11, 14, 17], "more": 0, "namedtupl": 6, "network": 6, "new": [0, 12], "non": 9, "note": 12, "notif": 0, "number": 17, "object": [0, 5, 6, 11, 14, 17], "other": 5, "packag": 9, "paramet": 17, "pass": 17, "phase": 17, "poll": 5, "pool": 13, "postgresql": [3, 4, 8, 17], "practic": 7, "prerequisit": 9, "problem": [7, 9, 17], "process": 17, "protocol": [0, 5, 17], "psycopg": [6, 8, 9, 12, 16], "psycopg2": [3, 4, 5, 6, 7, 10, 11, 13, 14, 16], "python": [0, 8, 9, 17], "queri": 17, "question": 7, "quick": [0, 9], "rang": 6, "real": 6, "releas": 12, "replic": [0, 6], "requir": 9, "run": 9, "runtim": 9, "safeti": 17, "server": 17, "side": 17, "sql": [0, 5, 14, 17], "sqlstate": 4, "standard": 9, "start": 0, "statement": 17, "statu": 5, "still": 9, "string": [14, 17], "subclass": 6, "suit": 9, "support": [0, 5, 6, 17], "syntax": 0, "test": 9, "thread": 17, "time": 17, "topic": 0, "transact": [5, 7, 17], "tupl": 17, "two": 17, "type": [0, 5, 6, 7, 11, 17], "tz": 16, "tzinfo": 16, "unicod": 17, "us": 17, "usag": [14, 17], "uuid": 6, "v": 9, "valu": 17, "what": 12, "you": 9, "zone": 17}})