grants files - Search results in mailing lists

2025-06-18 23:57:55 | Re: pg_dump/pg_dumpall help synopses and terminology (Robert Treat)

files or archives?) - restore a PostgreSQL database or cluster - from an archive created by pg_dump or + restore PostgreSQL databases from archives + created by pg_dump or pg_dumpall I don't know if there

2025-06-09 09:00:00 | Re: strange perf regression with data checksums (Alexander Lakhin)

grant all on schema public to u; set session authorization u; create table tbl1 (a int); create function f1() returns int language plpgsql as $$ invalid $$; select sum(1) over (partition by 1 order by objid

2025-04-20 20:12:01 | Re: [PoC] Federated Authn/z with OAUTHBEARER (Ivan Kush)

file, name oauth_conf GUC oauth_conf = /var/lib/postgres/data/oauth.conf ================= 2) Google requires client_secret only in the Device Access Token Request (Section 3.3 RFC-8628). Also note that secret is in a body of a request

2025-04-13 23:17:59 | Re: Horribly slow pg_upgrade performance with many Large Objects (Hannu Krosing)

GRANT / LO hannuk@db01-c1a:~/work/lo-testing$ time pg_dump --schema-only --quote-all-identifiers --binary-upgrade --format=custom --file

2025-04-05 09:13:47 | Re: RFC: Logging plan of the running query (Atsushi Torikoshi)

files dynamic_explain.h and dynamic_explain.c, which you named and it seems fine to me, and move most of the code to them. Added below explanation like other functions: This function is restricted

2025-04-01 18:13:27 | Re: Draft for basic NUMA observability (Bertrand Drouvot)

grant appropriate privs. Also it should mention: " \echo Use "ALTER EXTENSION pg_buffercache UPDATE TO '1.6'" to load this file

2025-03-30 19:10:17 | Re: SQLFunctionCache and generic plans (Tom Lane)

files changed, 103 insertions(+) diff --git a/src/test/regress/expected/rowsecurity.out b/src/test/regress/expected/rowsecurity.out index 87929191d06..8f2c8319172 100644 --- a/src/test/regress/expected/rowsecurity.out +++ b/src/test/regress/expected/rowsecurity.out @@ -4695,6 +4695,65 @@ RESET ROLE; DROP FUNCTION rls_f(); DROP VIEW rls_v; DROP TABLE rls_t; +-- Check that

2025-03-17 16:19:27 | Re: PATCH: warn about, and deprecate, clear text passwords (Robert Haas)

file" and a warning doesn't stop that. Granted, other people may hear different complaints

2025-03-14 20:39:30 | More Perl cleanups (Dagfinn Ilmari Mannsåker)

files, compression $method"); diff --git a/src/interfaces/ecpg/preproc/parse.pl b/src/interfaces/ecpg/preproc/parse.pl index f22ca213c21..257174e277e 100644 --- a/src/interfaces/ecpg/preproc/parse.pl +++ b/src/interfaces/ecpg/preproc/parse.pl @@ -39,12 +39,12 @@ GetOptions( # Substitutions to apply to tokens whenever they are seen in a rule. my %replace_token = ( - 'BCONST

2025-03-08 08:03:49 | Re: Allow database owners to CREATE EVENT TRIGGER (Steve Chavez)

files and pg_execute_server_program..." " ..they could be used to gain superuser-level access, therefore great care should be taken when granting

2025-03-08 00:11:18 | Re: Update Unicode data to Unicode 16.0.0 (Jeff Davis)

file. The next example is tuniq, which is similar except that the index is a unique index, and the table has two values: U&'\019B' and U&'\A7DC'. In PG17, LOWER() returns U&'\019B

2025-03-07 17:37:27 | Re: [PATCH] New predefined role pg_manage_extensions (Michael Banck)

granting pg_manage_extensions. On the other hand, maybe trusted should be part of the catalog and not (just) the extension control file

2024-12-01 02:33:24 | Re: CREATE SCHEMA ... CREATE DOMAIN support (Tom Lane)

files changed, 123 insertions(+), 118 deletions(-) diff --git a/doc/src/sgml/ref/create_schema.sgml b/doc/src/sgml/ref/create_schema.sgml index ed69298ccc..625793a6b6 100644 --- a/doc/src/sgml/ref/create_schema.sgml +++ b/doc/src/sgml/ref/create_schema.sgml @@ -193,12 +193,10 @@ CREATE VIEW hollywood.winners AS - The SQL standard specifies that the subcommands in CREATE - SCHEMA

2024-11-13 23:10:46 | Re: split func.sgml to separated individual sgml files (Corey Huinker)

file gets its own commit, allowing the reviewer to more easily (if not programmatically) verify that the text that moved out of func.sgml moved into func-sect-foo.sgml. Granted

2024-09-27 03:30:05 | Re: Truncate logs by max_log_size (Euler Taveira)

GRANT ... ON PARAMETER and SET LOCAL commands are your friends. Hence, you can disable specific long queries even if you are not a superuser. If your main problem is disk space, you can adjust