Hi all, i've added a new table recentli in main DB, but at first 
insertion have this problem:
any time i try an insertion the sqlalchemy engine search nextval of a 
partial primary key.....

SQLError: (ProgrammingError) relation "scadenziario_id_piano_seq" does 
not exist
 'select nextval(\'"scadenziario_id_piano_seq"\')' {}

but............

the table is:


CREATE TABLE scadenziario (
        id_piano                INTEGER NOT NULL references piano(id),
        data_creazione          DATE,
        data_programmata        DATE NOT NULL,
        cod_verifica            TEXT NOT NULL references 
verifica(codice) ON UPDATE CASCADE,
);



How  and why  SQLAlchemy read a serial for the id_piano column ?


Thank you
Glauco

-- 
+------------------------------------------------------------+
                                  Glauco Uri - Programmatore
                                    glauco(at)allevatori.com 
                               
  Sfera Carta Software(r)      [EMAIL PROTECTED]
  Via Bazzanese,69  Casalecchio di Reno(BO) - Tel. 051591054 
+------------------------------------------------------------+



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to