PostGIS does not properly escape data with PostgreSQL 9.1
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| | python-django (Ubuntu) |
Undecided
|
Unassigned | ||
Bug Description
The PostGIS database backend does not properly escape geography data when "standard_
DatabaseError: invalid byte sequence for encoding "UTF8": 0x00
This is upstream issue 16778. Django 1.4 contains a fix for this issue, however the developers have stated that they do not intend to backport it to Django 1.3.x. See:
https:/
The patch from the above ticket applies cleanly; I've attached it to this ticket for convenience. After applying both the attached patch and the patch from LP: #1004180 I am able to successfully insert GIS data on Ubuntu 12.04LTS.
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: python-django 1.3.1-4ubuntu1
ProcVersionSign
Uname: Linux 3.2.0-24-virtual x86_64
ApportVersion: 2.0.1-0ubuntu7
Architecture: amd64
Date: Thu May 24 21:42:31 2012
PackageArchitec
ProcEnviron:
TERM=xterm-
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: python-django
UpgradeStatus: No upgrade log present (probably fresh install)
| Dave Pifke (dave-thingomatic) wrote : | #1 |
| Launchpad Janitor (janitor) wrote : | #3 |
Status changed to 'Confirmed' because the bug affects multiple users.
The attachment "Patch to PostGIS database backend from upstream issue 16778" of this bug report has been identified as being a patch. The ubuntu-reviewers team has been subscribed to the bug report so that they can review the patch. In the event that this is in fact not a patch you can resolve this situation by removing the tag 'patch' from the bug report and editing the attachment so that it is not flagged as a patch. Additionally, if you are member of the ubuntu-reviewers team please also unsubscribe the team from this bug report.
[This is an automated message performed by a Launchpad user owned by Brian Murray. Please contact him regarding any issues with the action taken in this bug report.]