New Features
- Model#qualified_pk_hash has been added, which is similar to Model#pk_hash,
but uses qualified keys.
- Dataset#distinct now accepts a virtual row block.
- Database#drop_table with :foreign=>true option now drops foreign tables
on PostgreSQL. Database#create_table with :foreign option is now reversible
on PostgreSQL.
Other Improvements
- Sequel::Model.cache_associations = false now skips the database‘s
schema cache when loading the schema for a model. This fixes some issues in
environments that use code reloading.
- Database#create_table? and create_join_table? no longer use IF NOT EXISTS
if indexes are being created.
- Model.primary_key_hash and .qualified_primary_key_hash have been optimized.
- validates_unique in the validation_helpers plugin now uses a qualified
primary key if the model‘s dataset is joined. This fixes a case when
the auto_validations and class_table_inheritance plugins are used together.
- Disconnect errors are now recognized in the postgres adapter when SSL is
used for connecting.
- Empty string default values are no longer converted to nil default values
on MySQL.
- Database#foreign_key_list now works correctly on Microsoft SQL Server 2005.