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