postgres
postgres copied to clipboard
supabase
Unmodified Postgres with some useful plugins
# Bug report - [ X] I confirm this is a bug with Supabase, not with my own application. - [ X] I confirm I have searched the [Docs](https://docs.supabase.com), GitHub...
## Problem When CI fails due to an error in the tests, they're hard to visualize: - The raw logs have to be accessed. - Then one has to CTRL...
# Bug report Basically, this worked in older projects. In newer projects, the permissions are stricter and one cannot enable this, safeguarding, `safeupdate` extension. But this is a crucial help...
## What kind of change does this PR introduce? pgbouncer needs updating for for prepared statement support, addressing incorporation of upgrades This PR updates the version to 1.24.1 This PR...
## Problem There are various cases where bash scripts are source from within Nix and then they have their variables replaced with `substitute`: - https://github.com/supabase/postgres/blob/61ff753243078fe2b14e5b8f184f4a00c80342ee/flake.nix#L498-L510 - https://github.com/supabase/postgres/blob/61ff753243078fe2b14e5b8f184f4a00c80342ee/flake.nix#L523-L528 - https://github.com/supabase/postgres/blob/61ff753243078fe2b14e5b8f184f4a00c80342ee/flake.nix#L535-L537 This...
## Problem It's hard to navigate `flake.nix` since it contains many scripts. ## Solution Modularize the scripts into different folders. This should be done after https://github.com/supabase/postgres/issues/1563, to identify potential deduplication...
## Problem GRANT OPTION is not tested on `vault` tests and some others: https://github.com/supabase/postgres/blob/f670f7d0291a27d0305dfb2d48e3b52b23461771/nix/tests/expected/vault.out#L28-L37 For reference, GRANT OPTION is added like ``` grant select, delete, truncate, references on vault.secrets, vault.decrypted_secrets...
## Problem By default NULLs show as blank on the test outputs, see: https://github.com/supabase/postgres/blob/edaca40d9121d771ac58b535d9bef701548976dd/nix/tests/expected/pgbouncer.out#L74-L78 This makes the NULL results not obvious at first sight. ## Solution Try adding an option...
## Problem `nix flake check` runs all the tests we have, this can take a long time and the generated output files are big as well. This is inefficient, considering...
## Problem We currently have these tests: https://github.com/supabase/postgres/blob/61ff753243078fe2b14e5b8f184f4a00c80342ee/migrations/tests/database/exists.sql#L2-L8 As one example, `has_schema('storage');` is redundant with https://github.com/supabase/postgres/blob/61ff753243078fe2b14e5b8f184f4a00c80342ee/nix/tests/expected/storage.out#L1-L14 Which provides more information. Editing the `exists.sql` file makes up for more work on...