New answers tagged postgresql-9.4
0
votes
Why am I getting permission denied on an ownership change?
A variation of the great answer by @OtoShavadze:
mydb=> GRANT admin TO <current_user>;
GRANT ROLE
mydb=> GRANT new_admin TO <current_user>;
GRANT ROLE
mydb=> REASSIGN OWNED BY ...
Top 50 recent answers are included
Related Tags
postgresql-9.4 × 509postgresql × 427
performance × 47
index × 29
json × 28
replication × 25
postgresql-performance × 15
postgresql-9.3 × 15
pg-dump × 15
aggregate × 14
query-performance × 13
plpgsql × 12
database-design × 11
optimization × 11
functions × 11
array × 11
backup × 10
upgrade × 10
update × 9
amazon-rds × 9
postgresql-9.5 × 9
pgadmin × 9
join × 8
trigger × 8
index-tuning × 8