| From: | carlos(dot)vasquez(at)clearcorp(dot)co(dot)cr |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #12008: REASSIGN OWNED changes other databases |
| Date: | 2014-11-19 18:37:21 |
| Message-ID: | 20141119183721.2476.90123@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 12008
Logged by: Carlos Vásquez
Email address: carlos(dot)vasquez(at)clearcorp(dot)co(dot)cr
PostgreSQL version: 9.3.5
Operating system: Ubuntu 14.04
Description:
Bug explained in stackoverflow
(http://stackoverflow.com/questions/27003415/postgres-reassign-owned-for-only-1-database)
I am using package 9.3.5-0ubuntu0.14.04.1 in ubuntu 14.04 without any
modification.
If I have multiple databases owned by user1 and I run REASSIGN OWNED BY
user1 TO user2; in 1 specific database, the command also changes the owner
of the other databases that user1 owns. This affects only the databases, not
the objects inside. Only the objects in the open database get changed to
user2 as it should be.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-11-19 21:06:41 | Re: BUG #12000: "CROSS JOIN" not equivalent to "," |
| Previous Message | Tom Lane | 2014-11-19 16:04:12 | Re: BUG #12000: "CROSS JOIN" not equivalent to "," |