So, John and I tracked down the error. I had named the table UnitCategory and the CD is trying to access unitcategory. Somewhere in the translation the table name is getting converted to lower case.
On 6/13/07, johnf <[EMAIL PROTECTED]> wrote: > On Wednesday 13 June 2007 13:36, Ed Leafe wrote: > > On Jun 13, 2007, at 4:12 PM, Nate Lowrie wrote: > > > File "c:\Python25\lib\site-packages\dabo-full\trunk\dabo\db > > > \dbPostgreSQL.py", > > > line 69, in getTables > > > tempCursor.execute(sqltablestr) > > > ProgrammingError: relation "public.unitcategory" does not exist > > > > > > I created the database and the tables in PdAdmin III and could query > > > them using psycopg2 and the python interpreter, so I am pretty sure it > > > is not the database. I named the table UnitCategory, so I am not sure > > > if capitalization matters. > > > > I'll defer to the Postgres experts. I'm not sure why it calls that a > > 'relation'. > > > > -- Ed Leafe > > -- http://leafe.com > > -- http://dabodev.com > I wonder do the table have PKID's? > > -- > John Fabiani > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/dabo-dev/[EMAIL PROTECTED]
