[Z3-sqlos] SQL error in sqlos_sample

Rob Campbell rcampbell at pcwi.net
Wed Feb 1 20:20:57 CET 2006


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.

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



More information about the z3-sqlos mailing list