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 -~----------~----~----~----~------~----~------~--~---