I have installed PostgreSQL on Windows 2000. I was not able to test it
from the command line as the password always fails. It seems this is a
known problem to be fixed in the next release.
Well,
Both dev and prod cfg's:
sqlobject.dburi="postgres://superuser:superuserpw@/test2db"
and creating the database (test2db) with the graphical administrator.
using model.py:
from sqlobject import *
from turbogears.database import PackageHub
# Uncomment the following line if you wish to use Identity and
SO_Provider
# from turbogears.identity.soprovider import TG_User, TG_Group,
TG_Permission
hub = PackageHub("test2")
__connection__ = hub
class User(SQLObject):
email = StringCol(alternateID=True)
lists = MultipleJoin('List')
class List(SQLObject):
title = UnicodeCol(notNone=True)
user = ForeignKey('User')
items = MultipleJoin('Item')
class Item(SQLObject):
value = UnicodeCol(notNone=True)
list = ForeignKey('List')
I get the error:
C:\test2>tg-admin sql create
Using database URI postgres://superuser:superuserpw@/test2db
Traceback (most recent call last):
File "C:\Python24\Scripts\tg-admin-script.py", line 7, in ?
sys.exit(
File
"c:\python24\lib\site-packages\TurboGears-0.9a4-py2.4.egg\turbogears\comm
and\base.py", line 262, in main
command.run()
File
"c:\python24\lib\site-packages\TurboGears-0.9a4-py2.4.egg\turbogears\comm
and\base.py", line 121, in run
command.the_runner.run(sys.argv)
File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje
ct\manager\command.py", line 102, in run
runner.run()
File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje
ct\manager\command.py", line 233, in run
self.command()
File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje
ct\manager\command.py", line 569, in command
soClass.createTable()
File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje
ct\main.py", line 1322, in createTable
conn.createTable(cls)
File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje
ct\dbconnection.py", line 524, in createTable
self.query(self.createTableSQL(soClass))
File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje
ct\dbconnection.py", line 305, in query
return self._runWithConnection(self._query, s)
File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje
ct\dbconnection.py", line 219, in _runWithConnection
val = meth(conn, *args)
File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje
ct\dbconnection.py", line 302, in _query
self._executeRetry(conn, conn.cursor(), s)
File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje
ct\dbconnection.py", line 297, in _executeRetry
return cursor.execute(query)
psycopg2.ProgrammingError: relation "list" does not exist
This is where I started days ago. It appears there is some confusion
with relations.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/turbogears
-~----------~----~----~----~------~----~------~--~---
