postgresql-tableversion

postgresql-tableversion copied to clipboard

## Checklist - [ ] Update local tags using `git fetch --tags`. - [ ] Check `git tag --sort=version:refname` for the latest released version. - [ ] Depending on whether...

palmerj

Bumps [actions/upload-artifact](https://github.com/actions/upload-artifact) from 3.1.3 to 4.3.1. Release notes Sourced from actions/upload-artifact's releases. v4.3.1 Bump @​actions/artifacts to latest version to include updated GHES host check v4.3.0 What's Changed Reorganize upload code...

dependabot[bot]

Bumps [cachix/install-nix-action](https://github.com/cachix/install-nix-action) from 23 to 25. Release notes Sourced from cachix/install-nix-action's releases. install-nix-action-v25 Nix 2.19.2 install-nix-action-v24 Nix 2.19.1 enables KVM on linux set TMPDIR to avoid potential disk space issues...

dependabot[bot]

See [PR](https://github.com/linz/postgresql-tableversion/pull/383).

l0b0

Review the way schema changes are revisioned.

4

Dropping columns in revisioned data has caused some issues and is not best practice as we lose history. One idea is to not allow dropping columns for revisioned data. This...

billgeo

Prevent altering of table columns for versioned table

1

It would be nice if tableversion prevented users altering table columns for versioned tables. At the moment this is possible and causes some some tableversion functions to error if the...

billgeo

Add foreign key constraints to versioned table data

6

Table-specific revision tables might be good to have a foreign key constraints to table_version.revision table. To be verified performance cost of this. \cc @palmerj @imincik

strk

Moving where tableversion data is stored

25

Not sure if this is best practice or a good idea, but would it be possible to move tableversion data into the schema of the table that has been versioned?...

billgeo

Use jq in Makefile to pull extension name from META.json.in rather than messy sed command

1

https://github.com/linz/postgresql-tableversion/issues/283 is a pre-requisite for this issue.

MitchellPaff

cannot version unversioned table (inconsistent view on the matter)

10

See this session: ``` lol_3_17=# select table_version.ver_version(); 1.7.0dev 1.6.0-16-g7fabb6f lol_3_17=# select table_version.ver_is_table_versioned('bde_ext', 'adjustment_run'); f lol_3_17=# select table_version.ver_enable_versioning('bde_ext', 'adjustment_run'); ERROR: Table bde_ext.adjustment_run is already versioned ``` Basically, `ver_is_table_versioned` says a table...

strk