[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