justanyone ha scritto:
> In Postgres at least, serial columns are typically defined as:
>
> CREATE TABLE FOO (
> id_piano serial primary key,
> ...
> )
>
> This automatically creates a sequence foo_id_piano_seq. Of course,
> you can also create a sequence separate from a table with CREATE
> SEQUENCE, but this is (IMHO) wordy.
>
> You can select from it to find the current value with CURRVAL(), or
> get the value and increment it in one operation as:
>
> SELECT NEXTVAL ( <sequencename> );
>
> -- Kevin
>
>
Thank you kevin , i've worked a lot over PG and this tecnique is
consolidated in our model.. but here the problem is that the column
is a simply <column_name> INTEGER NOT NULL references
<other_table>(id) and i cannot understand why sqlalchemy whant to use it
as a
<column_name> SERIAL
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
-~----------~----~----~----~------~----~------~--~---