[Z3-sqlos] SQL error in sqlos_sample

[Brian Sutherland]

On Wed, Feb 01, 2006 at 11:20:57AM -0800, Rob Campbell wrote:
> I answered my own question.  The sequence was not created by the 
> included postgres.sql script.  So I had to add the sequence manually 
> with CREATE SEQUENCE person_id_seq.

If you post a patch, I'll make sure that it is committed. Unfortunately
the example is not functionally tested, so cannot really be maintained
easily.

> Rob Campbell
> Pacific Coast Wireless Internet
> 
> Rob Campbell wrote:
> > Hello,
> > 
> > I was just trying out sqlos with Zope 3.2.0 and PostgreSQL 8.0.3.  I was 
> > able to add it to Zope, but when I try to add a new person I get the 
> > following error:
> > 
> > DatabaseException: ERROR:  relation "person_id_seq" does not exist
> > 
> > SELECT NEXTVAL('person_id_seq')
> > 
> > Does anyone know what is causing this error?  I tried looking for where 
> > it is referenced in the code, but I could not find anything about an 
> > id_seq.
> > 
> > Rob Campbell
> > Pacific Coast Wireless Internet
> > _______________________________________________
> > z3-sqlos mailing list
> > z3-sqlos at codespeak.net
> > http://codespeak.net/mailman/listinfo/z3-sqlos
> _______________________________________________
> z3-sqlos mailing list
> z3-sqlos at codespeak.net
> http://codespeak.net/mailman/listinfo/z3-sqlos
> 

-- 
Brian Sutherland

Metropolis - "it's the first movie with a robot. And she's a woman.
              And she's EVIL!!"