[Dbix-class] Deploying schemas with autoincrement

Rob Kinyon rob.kinyon at gmail.com
Fri Mar 13 13:15:04 GMT 2009


autoincrement is standard idea that every single RDBMS has a different
way of implementing. Something like this will be supported in SQLA2,
but not now. :-/

Rob

On Fri, Mar 13, 2009 at 07:11, Ian Wells <ijw at cack.org.uk> wrote:
> I'm trying to do the above with $schema->deploy(), but I've not found
> a database-agnostic way of describing the key column in the schema
> (for instance, I have to use the Pg type 'serial' to get a Pg
> deployment, which means that SQLite doesn't like it).
>
> I tried going backwards, generating the schema from the database, but
> that comes up with even weirder stuff (default value of 'nextval(...)'
> - exactly as postgres makes it happen, but again, not portable).
>
> Can I do this?  Is it even possible?
>
> --
> Ian.
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>



-- 
Thanks,
Rob Kinyon



More information about the DBIx-Class mailing list