Ubuntu
python-django package

PostGIS does not properly escape data with PostgreSQL 9.1

Bug #1004204 reported by Dave Pifke on 2012-05-24

This bug affects 3 people

Affects

Status

Importance

Assigned to

Milestone

python-django (Ubuntu)

Confirmed

Undecided

Unassigned

You need to log in to change this bug's status.

Affecting:	python-django (Ubuntu)
Filed here by:	Dave Pifke
When:	2012-05-24
Confirmed:	2012-07-09

Target

Distribution
Package	(Find…)
Project	(Find…)

Status	Importance
	Undecided

Assigned to

	Nobody
	Me

Comment on this change (optional)

E-mail me about changes to this bug report

(?)

Bug Description

The PostGIS database backend does not properly escape geography data when "standard_conforming_strings = off" is set in the PostgreSQL configuration. This is the default setting in PostgreSQL 9.1. As a result, trying to insert GIS database fails with the exception:

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://code.djangoproject.com/ticket/16778

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
ProcVersionSignature: Ubuntu 3.2.0-24.38-virtual 3.2.16
Uname: Linux 3.2.0-24-virtual x86_64
ApportVersion: 2.0.1-0ubuntu7
Architecture: amd64
Date: Thu May 24 21:42:31 2012
PackageArchitecture: all
ProcEnviron:
TERM=xterm-256color
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: python-django
UpgradeStatus: No upgrade log present (probably fresh install)

Tags: Edit Tag help

Dave Pifke (dave-thingomatic) wrote on 2012-05-24:

Dependencies.txt Edit (768 bytes, text/plain; charset="utf-8")

Patch to PostGIS database backend from upstream issue 16778 Edit (1.2 KiB, text/plain)

Ubuntu Foundations Team Bug Bot (crichton) wrote on 2012-05-25:

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.]

tags:

added: patch

Launchpad Janitor (janitor) wrote on 2012-07-09:

Status changed to 'Confirmed' because the bug affects multiple users.