github devrimgunduz/pagila pagila-v4.1.2
4.1.2: PostgreSQL 19 RC1 fixes and improve README

2 hours ago
  • Remove the UPDATE/DELETE ... FOR PORTION OF statements from pagila-temporal-setup.sql and the README, since FOR PORTION OF was reverted from PostgreSQL 19
  • Lower the temporal tables example's requirement from PostgreSQL 19 to 18, which is where WITHOUT OVERLAPS and temporal foreign keys arrived, in the README, pagila-temporal-setup.sql and `pagila-schema-dia>
  • Set search_path in pagila-temporal-setup.sql, so it works with \i from the session that loaded pagila-schema.sql/pagila-data.sql
  • Add README examples of writes rejected by the WITHOUT OVERLAPS key and the temporal foreign key
  • Move the README's install notes ahead of the example queries and expand them into step-by-step instructions, including prerequisites, optional components and the correct pagila-schema-jsonb.sql file name
  • Document podman compose as an alternative to docker-compose
  • Add an example of loading the JSONB files into a running container
  • Replace the MIT licence text in LICENSE.txt with the PostgreSQL License text, which the README already named as pagila's licence, and add the years to its copyright line

Don't miss a new pagila release

NewReleases is sending notifications on new releases.