This forum is now a read-only archive. All commenting, posting, registration services have been turned off. Those needing community support and/or wanting to ask questions should refer to the Tag/Forum map, and to http://spring.io/questions for a curated list of stackoverflow tags that Pivotal engineers, and the community, monitor.
No announcement yet.
Does anyone use PostgreSQL with spring?Page Title Module
To the best of my knowledge, PostgreSQL doesn't support this. I'm pretty sure it didn't in v. 7, and I'm not aware that's changed in 8.
From the manual:
The data types serial and bigserial are not true types, but merely a notational convenience for setting up unique identifier columns (similar to the AUTO_INCREMENT property supported by some other databases). In the current implementation, specifying
The only difference is, that in the firstcase a drop table cascades and also deletes the sequence - this isn't the case if the sequence is created manually.
So, there is a serial. But this serial is just used for creating sequences in a convenient way. What the initial author was asking for (if I understood him correctly) is "auto increment" - and that isn't supported by PostgreSQL.