On 05/01/2013 04:43 PM, Paul McNett wrote:
On 5/1/13 4:16 PM, John Fabiani wrote:
Hi,
In the past I was able to use a temp table doing the following:
csql = 'a long create temp table statement with the name tempstudent'
biz = dabo.biz.dBizobj(connection)
biz.execute(csql)
biz.DataSource = 'temptstudent' #the temp table name
biz.KeyField = "pkid"
biz.new()
What is the correct to use a temp table (a temp table must be used within the
same
session)?
This looks right. But you have:
biz.DataSource = 'temptstudent'
and then:
File "/home/johnf/dabo/dabo/db/dCursorMixin.py", line 389, in execute
raise dException.DBQueryException(errMsg)
dabo.dException.DBQueryException: relation "tempstudent" does not exist
LINE 2: from tempstudent
So it looks to me like you jumped to the conclusion your typo was Dabo's fault.
;)
Paul
I know it's not a typo. On a hunch I decided to check other postgres
installs.
My setup is new -
I have setup hot_standby replication on a postgres 9.1.9 (uses two
computers) and that is where I'm seeing the problem of access.
On a single setup postgres 9.1.4 I do not see the problem.
No changes to the code - so I doubt this directly something to do with
Dabo. But I have to find it.
Thanks,
Johnf
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
