Subquery has too many columns

[timc3]

This is a continuation of a thread I started a couple of months ago
but didn't have time to investigate more:

http://groups.google.com/group/django-users/browse_frm/thread/dc2e49515ddcbf73?hl=en&tvc=1

It seems to be some problem with psycopg2 on my Ubuntu production test
machines as I am not getting the error on my OS X development boxes.


<class 'psycopg2.ProgrammingError'> Traceback (most recent call
last)

/home/cc/src/contentcentre/development/BrokerService/code/brokersite/
<ipython console> in <module>()

/var/lib/python-support/python2.5/IPython/Prompts.py in __call__(self,
arg)
521
522 # and now call a possibly user-defined print
mechanism
--> 523 manipulated_val = self.display(arg)
524
525 # user display hooks can change the variable to be
stored in

/var/lib/python-support/python2.5/IPython/Prompts.py in _display(self,
arg)
545 """
546
--> 547 return self.shell.hooks.result_display(arg)
548
549 # Assign the default display method:

/var/lib/python-support/python2.5/IPython/hooks.py in __call__(self,
*args, **kw)
132 #print "prio",prio,"cmd",cmd #dbg
133 try:
--> 134 ret = cmd(*args, **kw)
135 return ret
136 except ipapi.TryNext, exc:

/var/lib/python-support/python2.5/IPython/hooks.py in result_display
(self, arg)
160
161 if self.rc.pprint:
--> 162 out = pformat(arg)
163 if '\n' in out:
164 # So that multi-line strings line up with the left
column of

/usr/lib/python2.5/pprint.py in pformat(self, object)
109 def pformat(self, object):
110 sio = _StringIO()
--> 111 self._format(object, sio, 0, 0, {}, 0)
112 return sio.getvalue()
113

/usr/lib/python2.5/pprint.py in _format(self, object, stream, indent,
allowance, context, level)
127 self._readable = False
128 return
--> 129 rep = self._repr(object, context, level - 1)
130 typ = _type(object)
131 sepLines = _len(rep) > (self._width - 1 - indent -
allowance)

/usr/lib/python2.5/pprint.py in _repr(self, object, context, level)
193 def _repr(self, object, context, level):
194 repr, readable, recursive = self.format(object,
context.copy(),
--> 195 self._depth,
level)
196 if not readable:
197 self._readable = False

/usr/lib/python2.5/pprint.py in format(self, object, context,
maxlevels, level)
205 and whether the object represents a recursive
construct.
206 """
--> 207 return _safe_repr(object, context, maxlevels, level)
208
209

/usr/lib/python2.5/pprint.py in _safe_repr(object, context, maxlevels,
level)
290 return format % _commajoin(components), readable,
recursive
291
--> 292 rep = repr(object)
293 return rep, (rep and not rep.startswith('<')), False
294

/usr/lib/python2.5/site-packages/django/db/models/query.py in __repr__
(self)
145
146 def __repr__(self):
--> 147 data = list(self[:REPR_OUTPUT_SIZE + 1])
148 if len(data) > REPR_OUTPUT_SIZE:
149 data[-1] = "...(remaining elements truncated)..."

/usr/lib/python2.5/site-packages/django/db/models/query.py in __len__
(self)
160 self._result_cache = list(self.iterator())
161 elif self._iter:
--> 162 self._result_cache.extend(list(self._iter))
163 return len(self._result_cache)
164

/usr/lib/python2.5/site-packages/django/db/models/query.py in iterator
(self)
273 extra_select = self.query.extra_select.keys()
274 index_start = len(extra_select)
--> 275 for row in self.query.results_iter():
276 if fill_cache:
277 obj, _ = get_cached_row(self.model, row,
index_start,

/usr/lib/python2.5/site-packages/django/db/models/sql/query.py in
results_iter(self)
201 resolve_columns = hasattr(self, 'resolve_columns')
202 fields = None
--> 203 for rows in self.execute_sql(MULTI):
204 for row in rows:
205 if resolve_columns:

/usr/lib/python2.5/site-packages/django/db/models/sql/query.py in
execute_sql(self, result_type)
1750
1751 cursor = self.connection.cursor()
-> 1752 cursor.execute(sql, params)
1753
1754 if not result_type:

/usr/lib/python2.5/site-packages/django/db/backends/util.py in execute
(self, sql, params)
17 start = time()
18 try:
---> 19 return self.cursor.execute(sql, params)
20 finally:
21 stop = time()

<class 'psycopg2.ProgrammingError'>: subquery has too many columns

[timc3]

Well I fixed this by updating to the latest django trunk.