I may be missing something fundamental here, but why doesn't it
already know the metadata since I defined the columns in which I'm
interested?
thing_table = sa.Table("thing", md, sa.Column('id', sa.Integer,
primary_key = True))
On 3/17/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
> the cursor metadata often cannot be read until fetchone() is called
> first. the current result set implementation we have doesnt call
> fetchone() before it tries to get the metadata, and normally it
> shouldnt (since the result set doesnt even know if its the result of a
> select/insert/whatever). id like an alternate result set class to go
> into effect when PG/server side cursors/select is used to do this, i
> think someone was supposed to send a patch. its hard for me to
> develop since my version of PG 8.1 doesnt seem to reproduce the issue.
>
> On Mar 17, 8:14 pm, "[EMAIL PROTECTED]"
> <[EMAIL PROTECTED]> wrote:
> > I was excited to see the server_side_cursors option that was added
> > recently.
> >
> > I saw the reports of it not working with autoload = True, but I've
> > been having trouble getting it to work at all.
> >
> > When attempting to select a row using:
> >
> > >>> t2.select().execute().fetchone()
> >
> > I get:
> >
> > INFO sqlalchemy.engine.base.Engine.0x..d0 SELECT thing.id FROM thing
> > INFO sqlalchemy.engine.base.Engine.0x..d0 {}
> > Traceback (most recent call last): File "<stdin>", line 1, in ?
> > File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line
> > 811, in __repr__
> > File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line
> > 671, in _get_col
> > File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line
> > 659, in _convert_key
> > sqlalchemy.exceptions.NoSuchColumnError: "Could not locate column in
> > row for column '0'"
> >
> > This query runs fine without server_side_cursors = True
> >
> > Any suggestions?
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
