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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---