[Zope] Zope/PostgreSQL/PoPy

[Russell Hires]

I'm in the same boat. When I was having trouble connecting to the PostgreSQL 
db, I got an interesting response from Thierry Michel, the author of of the 
PoPy adapter: look at the permissions on the database. Sure enough, I didn't 
have permission to make a local connection. 

I told you all of that so I could tell you this: I think this might be the 
same error: something may be wrong at the db level, and not with zope or the 
adapter. Of course, I have no idea what it could be, and I've checked a 
number of PostgreSQL docs to find out what could be the problem with "string" 
but nothing yet. I tried the "nb" type as well, and no go. I haven't done too 
much with the numeric types yet...maybe I'll test those to make sure they all 
work. But float does!

Russell
On Wednesday 22 August 2001 15:47, you wrote:
> Hello all,
>
>   I have successfully installed the PoPyDA product in Zope and am able to
> query existing PostgreSQL databses but am getting the following error when
> I try to INSERT a new record into the database:
>
> Error, exceptions.NameError: global name 'string' is not defined
>
> <snip/>
>
>   File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 544,
> in __call__ (Object: <string>)
>   File /usr/local/zope/lib/python/Shared/DC/ZRDB/sqlvar.py, line 206, in
> render (Object: job_num)
>   File /usr/local/zope/lib/python/Products/zpopyda/PoPy_DA.py, line 103, in
> sql_quote__ (Object: RoleManager)
> NameError: (see above)
>
>
>   I'm using the <dtml-sqlvar name type="string"> tag to insert the
> variables, which works fine when I use Gadfly.
>
>   If anyone has any suggestions (or a FM I can R), I be most appreciative.
>
> Thanks,
> Matt Hand
> matt@bitflip.com
>
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )