grants gives - Search results in mailing lists

2024-05-22 15:11:00 | Ynt: Postgresql 16.3 installation error (setup file) on Windows 11 (Ugur Yilmaz)

give some clue. On Thu, May 16, 2024 at 11:57 AM Sandeep Thakkar > wrote: Thank you for sharing details. We are unable to reproduce the issue on Windows Server

2024-03-14 06:03:17 | Re: BUG #18392: Can't restore database (using pg_restore) after latest Feb 8 update (Carl Smith)

give me a private address to send it to) Thanks, Carl Command failed: pg_restore -U postgres --clean --if-exists --dbname tmf_app_manager /Users/carl/GitHub/conforma/conforma-server/database/_snapshots/TEST_14_11_2024-03-14_15-27-40/database.dump pg_restore: error: could not execute query: ERROR: relation "public

2024-03-13 18:32:55 | Re: BUG #18387: Erroneous permission checks and/or misleading error messages with refresh materialized view (Tom Lane)

giving away security information, but I'm not sure how much sense that really makes. We already show the specific object that didn't have permissions. I think it would be good for these errors

2024-01-23 23:51:52 | v17 Possible Union All Bug (David G. Johnston)

grants have two different grantors and combine them into a single newline separated presentation. Note that both v16 examples below show this expected output as does the "working" view in v17. The "broken" view

2023-11-06 10:30:49 | BUG #18183: Unable to grant similar roles after changing user from No inheritance to Inheritance (PG Bug reporting form)

grant all privileges. 2. provide inherit privilege to 't1' user. then revoke the 'test' role from 't1' and assign it again. But Ideally, It should be able to use the role which is already assigned

2023-09-10 15:45:22 | [16+] subscription can end up in inconsistent state (Jeff Davis)

gives the subscription to a non-superuser, or if the subowner loses their superuser status, then the subscription is in a weird state: subpasswordrequired may be true even if subconninfo doesn't have a password

2023-04-12 00:23:52 | BUG #17891: MAIF - Strange behavior on Grants with Groups (PG Bug reporting form)

Give SELECT grant on the table and the view grant select on table za_ifs_data

2023-02-27 22:54:23 | Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware) (Tom Lane)

granting that Pbc is strict for B Suppose that we are given a FROM clause in the first form and that there's a non-strict WHERE clause referencing a column of C. That clause

2021-08-20 14:57:46 | Re: Urgent Support Need (Sunil Choudhary)

give grant access again on db user then it work fine....any idea what went

2021-04-11 10:34:43 | Re: BUG #16957: initdb.exe initialize a database cluster has stopped working (sadaqat)

giving the same error. I am sharing with you the temp log file of official gui installer of postgresql. May be it is of some help. ... ... upacking... unpacking.. Unpacking C:\Program Files\PostgreSQL

2021-04-09 06:52:10 | Update locks the row even if there is no row to update (Roman)

gives us an opportunity to update 'boolupdate' and if 'boolupdate' doesn't satisfy the requirement we are waiting some time for another transaction that updates the row to satisfy. create or replace function "UpdateOrWait" ( updid

2020-12-28 19:29:46 | BUG #16795: Can't give "grant execute on pg_start_backup to .." (PG Bug reporting form)

granted EXECUTE on the function) and issue the command: SELECT pg_start_backup('label', false, false); But I can't give

2019-11-17 17:30:39 | Re: 回复: 回复: 回复: BUG #16101: tables in the DB is not available after pg (Tomas Vondra)

gives you a simple workaround - you can use "-c" when runnig pg_dump, and it should work. Alternatively, you can do GRANT

2018-02-23 18:06:03 | BUG #15081: pg_hba_file_rules permission issue (PG Bug reporting form)

give access to pg_shadow view without granting access to pg_authid table even though

2017-03-17 17:56:47 | [BUGS] QGIS Seem To Bypass PostgreSQL/PostGIS User Privileges/Permissions (Osahon Oduware)

GRANT [role_name] TO [user_name] Next, I test this by trying to UPDATE a column in a table (same schema as above) with pgAdmin/psql and this works fine by giving