proposal: change postgresql to use SERIAL

Hans Lellelid <[email protected]> Thu, 01 Sep 2005 22:05:53 -0400
Newsgroups gmane.comp.php.creole.devel,gmane.mail.eyebrowse.user
Message-ID <4317B381.8000007__24863.9529374943$1125626836$gmane$org@velum.net>
I'd like to propose changing the IdGenerator stuff for PostgreSQL based 
on the assumption that auto-increment/sequence columns are now commonly 
specified using the SERIAL datatype (which essentially behaves like an 
auto-increment column rather than a traditional sequence).  This would 
change the PgSQLIdGenerator class to return AUTO_INCREMENT rather than 
SEQUENCE as the id generator type.

Is everyone OK with this change?  This will necessitate that next Creole 
version be 1.1, as this could break some backwards compatibility (though 
technically Creole is designed such that your application can check 
whether the driver uses sequence/auto-increment and behave accordingly).

Cheers,
Hans