summaryrefslogtreecommitdiff
path: root/django/db/backends/postgresql/operations.py
Commit message (Collapse)AuthorAgeFilesLines
...
* Removed unnecessary casting when using builtin lookups on PostgreSQL.Simon Charette2016-09-221-0/+2
|
* Fixed #26348 -- Added TruncTime and exposed it through the __time lookup.Simon Charette2016-07-081-0/+5
| | | | Thanks Tim for the review.
* Refs #25774, #26348 -- Allowed Trunc functions to operate with time fields.Simon Charette2016-07-081-0/+3
| | | | Thanks Josh for the amazing testing setup and Tim for the review.
* Refs #3254 -- Added full text search to contrib.postgres.Marc Tamlyn2016-04-221-0/+6
| | | | | | | | | | Adds a reasonably feature complete implementation of full text search using the built in PostgreSQL engine. It uses public APIs from Expression and Lookup. With thanks to Tim Graham, Simon Charettes, Josh Smeaton, Mikey Ariel and many others for their advice and review. Particular thanks also go to the supporters of the contrib.postgres kickstarter.
* Fixed E128 flake8 warnings in django/.Tim Graham2016-04-081-4/+4
|
* Refs #19527 -- Allowed QuerySet.bulk_create() to set the primary key of its ↵acrefoot2016-03-021-0/+8
| | | | | | | | objects. PostgreSQL support only. Thanks Vladislav Manchev and alesasnouski for working on the patch.
* Fixed #24793 -- Unified temporal difference support.Simon Charette2016-02-261-0/+7
|
* Fixed #24509 -- Added Expression support to SQLInsertCompilerAlex Hill2015-09-221-3/+4
|
* Fixed #25175 -- Renamed the postgresql_psycopg2 database backend to postgresql.Caio Ariede2015-08-071-0/+240
|
* Deprecated the psycopg-based postgresql database backend.Russell Keith-Magee2011-04-021-205/+0
| | | | git-svn-id: http://code.djangoproject.com/svn/django/trunk@15980 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #10154: Allow combining F expressions with timedelta values.Karen Tracey2010-12-221-0/+17
| | | | git-svn-id: http://code.djangoproject.com/svn/django/trunk@15018 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #13821 -- Added a double-quoting to the PostgreSQL sequence reset ↵Russell Keith-Magee2010-07-301-4/+5
| | | | | | code. Thanks to PaulM for the report, and to PaulM and Simon Meers for their work on the patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@13450 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #13941 -- Corrected the way sequence names are reset under Postgres, ↵Russell Keith-Magee2010-07-301-1/+1
| | | | | | especially when generic foreign keys are involved. Thanks to Ales Zoulek for the report and patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@13449 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #8901 -- Reapplied r13328 (with extra docs) now that we have a 1.3 ↵Russell Keith-Magee2010-06-211-11/+19
| | | | | | development branch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@13363 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Refs #8901 -- Reverted r13328 because the patch imposes a minimum version ↵Russell Keith-Magee2010-06-101-19/+11
| | | | | | requirement of Postgres 8.0; we can't impose that on Django 1.2, so we need to wait until the 1.3 is branched before we can apply this change. git-svn-id: http://code.djangoproject.com/svn/django/trunk@13348 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #8901 -- Corrected the PostgreSQL sequence reset code when field ↵Russell Keith-Magee2010-06-071-11/+19
| | | | | | identifiers exceed the maximum identifier length. Thanks to adam@zuerchertech.com for the report, and Matt Hoskins for the patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@13328 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #13441 -- Enforced a maximum identifier length of 63 for PostgreSQL. ↵Russell Keith-Magee2010-04-291-0/+14
| | | | | | Thanks to aball for the report and patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@13044 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #1142 -- Added multiple database support.Russell Keith-Magee2009-12-221-3/+4
| | | | | | | | | | | | | | | | | This monster of a patch is the result of Alex Gaynor's 2009 Google Summer of Code project. Congratulations to Alex for a job well done. Big thanks also go to: * Justin Bronn for keeping GIS in line with the changes, * Karen Tracey and Jani Tiainen for their help testing Oracle support * Brett Hoerner, Jon Loyens, and Craig Kimmerer for their feedback. * Malcolm Treddinick for his guidance during the GSoC submission process. * Simon Willison for driving the original design process * Cal Henderson for complaining about ponies he wanted. ... and everyone else too numerous to mention that helped to bring this feature into fruition. git-svn-id: http://code.djangoproject.com/svn/django/trunk@11952 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #11107 -- Corrected the generation of sequence reset SQL for m2m ↵Russell Keith-Magee2009-07-111-8/+9
| | | | | | fields with an intermediate model. Thanks to J Clifford Dyer for the report and fix. git-svn-id: http://code.djangoproject.com/svn/django/trunk@11215 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Corrected PostgreSQL version comparisons from r10730. Thanks to rozwell for ↵Russell Keith-Magee2009-05-111-3/+3
| | | | | | the report on IRC. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10735 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #10906 -- Added a check for PostgreSQL pre 8.2 when using ↵Russell Keith-Magee2009-05-101-1/+8
| | | | | | StdDev/Variance aggregates. Thanks to Richard Davies for the report and patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10731 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #10842 -- Corrected parsing of version numbers for PostgreSQL 8.4beta ↵Russell Keith-Magee2009-05-101-11/+6
| | | | | | series. Thanks to hgdeoro for the report and fix. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10730 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #10071 -- Changed some internal database data representations.Malcolm Tredinnick2009-04-121-3/+2
| | | | | | | | | | We now pass numbers used in data queries as actualy numbers (integers) to the database backends, rather than string forms. This is easier for some of the less flexible backeds. Based on a patch from Leo Soto and Ramiro Morales. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10530 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #10289 -- Corrected typo that produced oversensitive rejection of ↵Russell Keith-Magee2009-02-171-1/+1
| | | | | | Postgres versions. Thanks to Ian Kelly for the report. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9845 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #7672 -- Added a 'week_day' lookup type. Many thanks to Ross Poulton ↵Karen Tracey2009-02-081-1/+6
| | | | | | for the proposal and implementation on all built-in database backends.. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9818 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #10142 -- Added docs and an exploding error message to highlight an ↵Russell Keith-Magee2009-02-021-0/+11
| | | | | | error present in the implementation of STDDEV_POP and VAR_POP in PostgreSQL 8.2-8.2.4 that will give incorrect answers (the database function mistakenly returns sample, rather than population deviation/variance). Thanks to Vinay Sajip <vinay_sajip@yahoo.co.uk> for the report, and Ian Kelly for pointing out the cause of the problem. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9804 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #8597 -- Allow the use of strings containing underscores and percentageMalcolm Tredinnick2008-08-281-0/+2
| | | | | | | signs in "iexact" queries on PostgreSQL again (this case was missed in [8536]). git-svn-id: http://code.djangoproject.com/svn/django/trunk@8646 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #3575: use UPPER() instead ILIKE for postgres case-insensitive ↵Jacob Kaplan-Moss2008-08-251-4/+12
| | | | | | comparisons. git-svn-id: http://code.djangoproject.com/svn/django/trunk@8536 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Added savepoint support to the transaction code.Malcolm Tredinnick2008-08-121-0/+10
| | | | | | | | | | This is a no-op for most databases. Only necessary on PostgreSQL so that we can do things which will possibly intentionally raise an IntegrityError and not have to rollback the entire transaction. Not supported for PostgreSQL versions prior to 8.0, so should be used sparingly in internal Django code. git-svn-id: http://code.djangoproject.com/svn/django/trunk@8314 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #6523 -- Use the correct cast on field types for PostgreSQL whenMalcolm Tredinnick2008-08-081-0/+6
| | | | | | | | searching within a field column (e.g. "like", "contains", etc). Required for PostgreSQL 8.3. Thanks to Dan Watson for the patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@8242 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #7565 -- Fixed a problem with PostgreSQL sequence resetting in loaddata.Malcolm Tredinnick2008-06-301-1/+1
| | | | git-svn-id: http://code.djangoproject.com/svn/django/trunk@7789 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Merged the queryset-refactor branch into trunk.Malcolm Tredinnick2008-04-271-0/+3
| | | | | | | | | | This is a big internal change, but mostly backwards compatible with existing code. Also adds a couple of new features. Fixed #245, #1050, #1656, #1801, #2076, #2091, #2150, #2253, #2306, #2400, #2430, #2482, #2496, #2676, #2737, #2874, #2902, #2939, #3037, #3141, #3288, #3440, #3592, #3739, #4088, #4260, #4289, #4306, #4358, #4464, #4510, #4858, #5012, #5020, #5261, #5295, #5321, #5324, #5325, #5555, #5707, #5796, #5817, #5987, #6018, #6074, #6088, #6154, #6177, #6180, #6203, #6658 git-svn-id: http://code.djangoproject.com/svn/django/trunk@7477 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #6433 -- Handle some varied PostgreSQL version strings (beta versions andMalcolm Tredinnick2008-04-131-1/+9
| | | | | | | Windows version strings). Patch from jerickso. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7415 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Re-enable substring lookups for IP address fields in Postgres using HOST() ↵Jacob Kaplan-Moss2008-02-261-0/+5
| | | | | | Thanks for the suggestion, Thomas Adamcik. Fixes #708. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7161 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Reverted [7151] since it breaks exact IP lookups on PostgreSQL. Reopens #708Jacob Kaplan-Moss2008-02-261-5/+0
| | | | git-svn-id: http://code.djangoproject.com/svn/django/trunk@7160 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #708 -- Fixed searching within IP fields on PostgreSQL.Malcolm Tredinnick2008-02-231-0/+5
| | | | | | | Based on a patch from Matt McClanahan. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7151 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #5710 -- Fixed a missing table name quoting in the postgresql backend, ↵Gary Wilson Jr2007-10-141-1/+1
| | | | | | thanks davep@atomicdroplet.com. git-svn-id: http://code.djangoproject.com/svn/django/trunk@6507 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Changed postgresql and postgresql_psycopg2 backends NOT to do a SELECT ↵Adrian Holovaty2007-08-251-3/+12
| | | | | | version() for every connection, which was ludicrous. Now the version is only retrieved if it needs to be, via a lazy loader. git-svn-id: http://code.djangoproject.com/svn/django/trunk@6012 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Fixed #5055 -- Changed Postgres DatabaseOperations.sql_flush() to use ↵Adrian Holovaty2007-08-251-21/+7
| | | | | | 'SELECT setval()' instead of 'ALTER SEQUENCE', because the latter only works with Postgres 7.3+. Thanks, Don Arbow git-svn-id: http://code.djangoproject.com/svn/django/trunk@6009 bcc190cf-cafb-0310-a4f2-bffc1f526a37
* Moved postgresql backend DatabaseOperations class into a new module, ↵Adrian Holovaty2007-08-201-0/+109
postgresql/operations.py, so that it can be imported by both the postgresql and postgresql_psycopg2 backends. Hence the two backends no longer have a duplicated DatabaseOperations class git-svn-id: http://code.djangoproject.com/svn/django/trunk@5972 bcc190cf-cafb-0310-a4f2-bffc1f526a37
View Lorry Controller Status