github/databasus
1
1
Fork 0
mirror of https://github.com/databasus/databasus.git synced 2026-04-06 00:32:03 +02:00
Code Issues 3 Packages Projects Releases Wiki Activity

permission denied #152

New Issue
Closed
opened 2026-04-05 16:15:51 +02:00 by MrUnknownDE · 0 comments
MrUnknownDE commented 2026-04-05 16:15:51 +02:00
Owner
Copy Link

Originally created by @lujay on 2/9/2026

We have a partitioned table, and we pre-create five partitions in advance each time.
It seems that our predefined database user does not have LOCK privileges on the newly created tables.

pg_dump: error: query failed: ERROR: permission denied for table call_sharding_20260209
pg_dump: detail: Query was: LOCK TABLE call_sharding_20260209 IN ACCESS SHARE MODE

*Originally created by @lujay on 2/9/2026* We have a partitioned table, and we pre-create five partitions in advance each time. It seems that our predefined database user does not have LOCK privileges on the newly created tables. pg_dump: error: query failed: ERROR: permission denied for table call_sharding_20260209 pg_dump: detail: Query was: LOCK TABLE call_sharding_20260209 IN ACCESS SHARE MODE
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
bug
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
MrUnknownDE
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github/databasus#152
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?